Mar 16 2020 06:44 AM
I have a lot of external customers who need to be notified when a technical spec changes. I am looking to store the documents in a SharePoint library
Rather then emailing every time a spec changes, it is possible to
Many thanks
Mar 16 2020 11:40 PM
Mar 17 2020 03:16 AM - edited Mar 17 2020 04:11 AM
@marionkd Neither of those methods is necessary, it can all be done within a single simple flow that looks at the existing library. I will post the method shortly.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Mar 17 2020 04:10 AM - edited Mar 17 2020 05:09 AM
Solution@marionkd the flow to achieve what you're trying to do is shown below.
The trigger is a Recurrence schedule set to run every 2 weeks on a Friday at 1500 hours.
The first action is a Get past time and I've set that to 14 days.
Next, add a SharePoint Get files (properties only) action and add a filter query of Modified ge '{Past time}'. ge means greater than or equal to, so it's only going to bring back items from the library modified within the last 14 days. Make sure you wrap the Past time expression in single quotes.
Next we create the table. Start with a Select control, select value from the dynamic content and then add in the columns you want in your table. Then add a Create HTML table using the output of the Select. Finally we apply a bit of styling to the table using a Compose control and adding in a replace expression:
Finally add a Send an Email (v2) action and in the body of the email just select from the dynamic content the output of the Compose where you applied the formatting.
The result of the email looks like this:
Hope that helps but come back with any questions.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Mar 17 2020 01:57 PM
@RobElliott Thank you so much for this. Cannot wait to test it out. Your help is much appreciated
Mar 17 2020 04:10 AM - edited Mar 17 2020 05:09 AM
Solution@marionkd the flow to achieve what you're trying to do is shown below.
The trigger is a Recurrence schedule set to run every 2 weeks on a Friday at 1500 hours.
The first action is a Get past time and I've set that to 14 days.
Next, add a SharePoint Get files (properties only) action and add a filter query of Modified ge '{Past time}'. ge means greater than or equal to, so it's only going to bring back items from the library modified within the last 14 days. Make sure you wrap the Past time expression in single quotes.
Next we create the table. Start with a Select control, select value from the dynamic content and then add in the columns you want in your table. Then add a Create HTML table using the output of the Select. Finally we apply a bit of styling to the table using a Compose control and adding in a replace expression:
Finally add a Send an Email (v2) action and in the body of the email just select from the dynamic content the output of the Compose where you applied the formatting.
The result of the email looks like this:
Hope that helps but come back with any questions.
Rob
Los Gallardos
Microsoft Power Automate Community Super User