User Profile
DogAndPonyShow
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Reminder emails (Power Automate) - dealing with blank people field
Hi there, I hope you can help. In Power Automate I want to check for blank email values in a people SharePoint column. Design solution: I have a flow which sends emails 4 days before a target date as reminders. The datasource is a SharePoint Online list. On the list, TargetCompletionDate is a Date/Time column showing date only in a standard format. Owner is a person/group column, allowing selection of 'People and Groups'. It's this value used to send an e-mail for items nearing their completion date. On the Get Items action, there's a filter query: TargetCompletionDate ne null to filter out items with blank 'TargetCompletionDate' values, so the flow doesn't error on those items. A condition uses the 'addDays' function adding 4 days from now & checks against the 'TargetCompletionDate' value (see screenshot Reminder Flow 3). If that condition is met there's a second condition to only send emails if the 'Owner' value isn't blank (screenshot Reminder Flow 4). If there's an email address, it sends the reminder email. Question: is there a better way to check for empty email values? Instead of a condition, can I use a Trigger Condition or an addition to the Filter Query. I've tried a few things, but with no success. Trigger Conditions I've tried: @not(empty(triggerBody()?['Owner'])) @not(empty(triggerBody()?['Owner/EMail'])) @not(equals(triggerBody()?['Owner'],null)) @not(equals(triggerBody()?['Owner/EMail'],null)) If I strip out the existing Filter Query, I can get it to work with Owner ne null -- however I'll need to check TargetCompletionDate isn't empty, otherwise the flow will error on items where it is. I'm not getting the syntax right. For instance, this isn't working:TargetCompletionDate ne null or Owner/EMail ne null (I suspect this is because there will always be a ; (semi-colon) in the TO: field, using theSend an email notification (V3) action) Can anyone suggest alternatives to the second condition action? Thanks!Upgrade 'Team site (classic)' to modern experience
I have a S/P Online site which is using the Team site (classic experience) Template. I am a site/site collection admin. What is the best/easiest way to convert this site to a fully modern experience, ideally a 'Communications' site template? I thought you could use the site collection upgrade facility, but I'm not sure how this works. When I click the 'REVIEW SITE COLLECTION UPGRADE STATUS' link from the 'upgrade' option, the status is 'Upgrade Completed Successfully' with no errors or warnings. I'm not aware of carrying this out myself. Clicking "Let's see the new site" still shows the site with classic features. For instance, the site's global navigation menu is on the left, vertically (rather than along the top) for all pages. My understanding is you can carry out 'site modernisation' from either the site settings or the Admin console, but PowerShell scripts may be required. Any help would be greatly appreciated - thank you! (for reference, attached are the site settings I presently see - again indicative of a 'classic' site)Lookup values invisible on QuickEdit (JSON formatted)
Hi there, I hope you can help. Values on a Choice column appear colour formatted on QuickEdit view. However values in a Lookup column (values taken from a lookup list) are invisible on QuickEdit. The values are there, but are only visible when you click into the cell. Both Choice & Lookup columns have the same formatting. The screenshot below shows how the columns display in regular list view versus QuickEdit view. Attached is the JSON formatting code I have. Can anyone help please? Thanks.
