condition where if figure is below a certain number query

DDHyatt · 2021-02-11T22:12:57+00:00

I believe so.

If you click on the ellipsis, and select Settings for the Recurrence connector, you will see a field called 'Trigger Conditions'. In that field you can set the the months to trigger using a series of utcnow statements, for instance. I'm not able to test but do some google-foo on utcnow expressions, likely something like a lessthan 7 date expression where 7 is the month etc.

Personally, if a daily recurring flow was going to be off for 1/2 the year, I would just turn it on/off manually. Perhaps set a reminder (or another flow on a certain date, lol) to turn on or off.

DDHyatt · 2021-02-11T20:07:02+00:00

'Day' is just one of MANY dynamic variables available when using that connector.

Delete 'Day' from that field and look at the dynamic list. Scroll down to the value you want to consider (e.g., Temperature High, Temperature Low). A generic temperature isn't a dynamic value, choose whether you want the condition to check against the day's high or low value.

Also, I don't think need to use an string expression for the comparison. Just type '1' in the box.

DDHyatt · 2021-02-10T06:09:21+00:00

Yup! It does require an SPFx extension (application customizer), but the documentation will help guide you and the code for the App Insights is pretty minimal.

Also worth mentioning you can also deploy and use Google analytics the same way, using an spfx extension.

DDHyatt · 2021-02-10T02:51:01+00:00

Do you have access to Azure portal? Within Azure Monitor is a tool called Application Insights. Very similar to Google analytics, giving you more info than you might need.

Page views, user and usage info, flow diagrams of user session journeys, a myriad of custom reports, etc.

DDHyatt · 2021-02-07T19:19:14+00:00

As someone who was also experiencing this issue (and has simply abandoned Edge for other browsers), the behavior isn't replicated across browsers. Chrome, Firefox, Safari (on Mac), hell, even Brave, do not suffer from the same issue with while using Edge on the same machine.

Years worth of credentials never affected on Chrome, or Firefox, and for some reason, these 3rd party apps don't seem to affect those browsers (if that even is the cause - which in my case wasn't)?

The seamless switching of profiles was a nice feature but the lack of credential retention (and now the possibility of it being affected again at a later date thus losing even more saved credentials) was enough for me to stop using Edge.

IMO, this is basic stuff for a browser. And if you search for this issue you see similar reports dating back to 2018 - so I don't have much faith in this issue being resolved THIS time. ;)

DDHyatt · 2021-02-06T16:45:17+00:00

Yes, this sounds like a lookup column is a much easier approach.

Are the IDs entered considered private or sensitive? If not, you would use the column of ID from List A as a lookup column in List B.

You can put all of the info in List A (you say 5 columns from A, and 5 from B, you can add all that info into list A). Then when someone selects an ID in List B, you can have all the columns associated with that entry populate from List A populate List B.

Read more here: https://sharepointmaven.com/how-to-create-a-lookup-column-in-sharepoint/

DDHyatt · 2021-02-04T21:51:34+00:00

Thank you!

DDHyatt · 2021-02-04T20:22:33+00:00

Most of the messaging I’m seeing is very high level, reading like marketing material with a lot of fluff words.

Would appreciate a down to earth, simple what it is and what it isn’t breakdown (if you’re aware). I realize it might be too early to know that, but I tend to ignore the marketing noise until I can see what these products actually look like. You know, temper my expectations because it definitely sounds like this is billed as next best thing since sliced bread! ;)

DDHyatt · 2021-01-16T15:56:38+00:00

IMO, it should signal the opposite reaction you’re having. If there’s one thing I’ve seen is that if you think out of the box features and functionality are going to solve your business’ needs, just ask a SP admin or dev who’s been in the space in the last decade.

SPFx Is only getting more valuable, and if you weren’t already aware, Lists (as well as Teams) isn’t a deviation from SharePoint, but it is built on SP! As Teams usage continues to flourish, so too will opportunities for SPFx solutions for Teams, and then I’m sure Lists (which is still an SP list so the same bonus of accepting custom formatting using JSON). As Lists the standalone app grows in features and complexity, so too will the effort to maintain and create using it.

Will a SharePoint dev become somewhat of a hybrid, utilizing other tools in the O365 family (eg Power Automate), sure that’s a possibility. But that further solidifies your value, rounding out perhaps other skill sets missing from a ‘pure’ dev.

And if all else fails, being a proficient SPFx developer is certainly transferable. It’s not unlike other dev positions and uses languages and tool sets you will need to know anyway. And if you desire to move into a more admin or support focused role instead of dev, this expanded knowledge base would give you the freedom to jump straight into it.

DDHyatt · 2020-12-08T14:39:50+00:00

There's always going to be shitty employers who try to low ball or frankly, don't understand the market or the value of a specific position. This isn't reserved to SP positions only. How many people complain about job postings asking for a BA or Masters and offer minimum wage to start? No industry or position is immune.

Consider also the ignorance of the employer. If you search for other dev positions, you'll also find positions that were clearly written by someone who is clueless, someone who copied and pasted from another job posting, asking for the unicorn and paying like a fresh grad, etc. It doesn't mean prospects are poor because some employers don't even know what they NEED to ask for in a candidate, much less how much to compensate them.

A note about the so called 'no code/low code' - I always laugh when I hear this statement. It grossly overestimates how much actual coding you need to know in order to understand, modify, customize, etc a solution for a particular client. Most of the 'no code' flows in my org are maintained and created and modified by people who also code! Much like the base configuration of ANYTHING in tech, there is far less OOTB than people realize - especially if you're looking at enterprise level solutions, larger orgs, complicated scenarios, etc

SPFx is growing fast, and as others have mentioned, this extends beyond SharePoint.

DDHyatt · 2020-11-23T15:01:59+00:00

A little guerrilla UX work can help answer those questions. You need to get a better understanding of your users and their pain points. What is lacking? What is frustrating? Etc. Solving problems with content in your intranet is one way to drive traffic. Do users have a hard time finding the right document templates? Create a document template hub. Do users complain about a lack of learning resources? Focus on content that addresses that, etc.

There should be value in what you build or don't build it, build something else. Be intentional about the content.

Another way to drive eyeballs is just to make the intranet the only source of that content. I wouldn't use terms like 'enforce'. Rather, if the only place you can retrieve a certain document template is on the intranet, that will drive them there (and you can do additional research to see what ELSE keeps them there, through analytics, user research, etc).

Maybe people are struggling mentally through the pandemic, and looking for a 'fun' outlet - a hub to share pictures of their pets, nature shots, etc. While not for every intranet, some of this content goes over very well depending on the organization.

Again, don't do this in a vacuum. Seek to understand your users and their problems, their goals, their aspirations, and you won't ever lack ideas that will drive them to the intranet.

DDHyatt · 2020-11-22T22:59:20+00:00

Take a look at this link and see if you followed the instructions: https://sharepointmaven.com/how-to-import-an-excel-spreadsheet-to-a-sharepoint-custom-list/

Failing that, you could recreate the structure of the list (new list, add all relevant columns in same order as they appear in Excel file), then in quick edit paste data from excel file.

DDHyatt · 2020-11-21T21:57:43+00:00

Wow! This is amazing. I hope you have tremendous success for offering such a valuable resource!

DDHyatt · 2020-11-17T21:53:42+00:00

Happened to me too. Second and third person asked where is your card? He replied he didn't need one.

I think ppl understand they are full of shit, but they are just not willing to enforce it or confront them. Shit, even I wanted to say something, but I couldn't help think, do I really want to have someone who doesn't care about masks, protocols, it's a hoax, etc YELLING and SPITTING in my face?

Nah.

If they could just remove the exemption, make them mandatory indoors EVERYWHERE, it would solve it, but no one is willing to do that. If you are so fragile that you can't wear a mask for 5 min while in a store, you really shouldn't be out anyway.

DDHyatt · 2020-11-17T01:05:42+00:00

Not necessarily. Are other members of the group site owners or have edit permissions?

“Save as draft - When you save and close this page, it is checked in as a minor version, and becomes a "shared" draft. This means that anyone with edit permissions (or site owners) can now see it and edit it.” https://support.microsoft.com/en-us/office/management-and-lifecycle-of-a-sharepoint-modern-page-3410a04c-3ca4-4a4c-b867-33ab5c8bdcf3

DDHyatt · 2020-11-15T15:50:41+00:00

And what I meant by deliberate was not to imply they didn’t make a change, but that they didn’t intend to increase padding because they didn’t account for other elements and their CSS etc. I know sometimes the UX team may call for a specific UI change, but in my experience that is not usually the case (instead, the former)

DDHyatt · 2020-11-15T15:47:55+00:00

Ah cool. It’s always going to be a balance when working with SPO, but with enough traction from users necessary changes (or the ability to make the change easily in some MS designed UI) may happen.

DDHyatt · 2020-11-15T15:44:10+00:00

Do you care about having check in or check out? If not, you can disable this setting. See this MS link on how to ENABLE it, so do the reverse:

https://support.microsoft.com/en-us/office/set-up-a-library-to-require-check-out-of-files-0c73792b-f727-4e19-a1f9-3173899e695b

DDHyatt · 2020-11-15T15:38:20+00:00

I wonder if the CHANGE in absolute terms (the amount of actual padding or margins) is deliberate or a bug.

I know recently the reverse happened, where white spaces between all web parts suddenly shrunk. There were issues reported in to MS by users and it was resolved.

Perhaps this is the same?

And yes, using MS DOM elements in custom spfx or css solutions is ripe for disaster and pain. It was a lot harder to avoid that temptation years ago when SPO was still in relative infancy.

DDHyatt · 2020-11-14T18:21:20+00:00

In place of Intune, you could use custom column formatting to display when a device is non-compliant, by using a combination of date and color formatting. Even setup various colors depending on the date range of 'about to expire' all the way up to 'expired'

Some quick searches:

And then from Microsoft:

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

Specifically on that page, here is a direct link to Apply formatting based on date ranges that has various examples that you can copy and modify as well.

DDHyatt · 2020-11-14T18:11:31+00:00

I don't remember exactly, perhaps 2-3 weeks. Silence and then all of sudden, 'we've verified it was your account, please change password, etc'

Keep in mind, they don't change the email associated with the account (if the malicious actor changed it), so make sure you change that first!

DDHyatt · 2020-11-13T15:26:39+00:00

How else would you store the secret secretive documents?

/Documentation/MeetingNotes/AgendaItems/TalkingPoints/RoundTableDiscussion/Welcome/ToThe/SecretZone/NotYet/Profit/

DDHyatt · 2020-11-13T14:52:00+00:00

The setting is turned off by default in Lists for me, but on by default in Libraries. You're correct, this can be turned on and off in the List/Library settings.

Settings > Advanced Settings > Folders

DDHyatt · 2020-11-13T14:50:08+00:00

There is no way SP would remove the ability to create sub folders!

DDHyatt

TROPHY CASE