You’re offline. This is a read only version of the page.
Hi,
I would like create an auto email notification when a file is created and due date is updated in the SharePoint column. The email notification is with dynamic content to pick up due date from the SharePoint column.
The problem I have is the email notification is not able to pick up the due date as the 'When a file is created' is triggers too soon.
Seeking your guide. Thanks in advance.
Mabel,
I get it now. Thanks it's working.
Thank you so much for your guidance. I'm lucky to have a great support from both of you.
Best Regards,
Doris
Hi @Anonymous ,
Please make sure the dynamic content DueDate comes from action Get file properties, but not from the trigger.
Best regards,
Mabel
Print screen below is the delay and get file properties I have added. The you no action I can be added in the loop. Could you guide how I can do so and anything on the print screen below is not correct?
You are using the Due Date from the SharePoint action that you did at the beginning of the Flow (I don't think the one inside the loop will be available once the loop exits) You either need to put the email action inside the loop or use the variable that you are setting.
Yes. The 'send email' action is outside of the Do Until. Below are the print screens.
The last print screen is an excerpt of the email has been sent. You can see the due date is missing. I have updated the due date within 1 minute after loaded the file to SharePoint.
Hi @Anonymous ,
It works perfectly on my side.
Could you share an image on your current flow?
Please make sure the send email action is added under (outside of the do until loop) the do until loop.
Best regards,
Mabel
Thanks for your guide. You're right. It's exactly what I'm looking for.
I have tried exactly the way you suggested, but the auto email notification is sent without due date.
Is yours successful?
Thanks in advance.
I have tested with get file properties. The auto email notification is sent without the due date too.
😞
Hi @Anonymous ,
Do you want to send out the email when a file is created and due date is updated?
Please consider using Do-until loop, so that only when the due date column updated, an email will be sent out.
I have set up the flow likes below for your reference.
After the trigger when a file is created, initialize a String variable first.
Then add a Do until loop, set the do until condition as variable Test is not qual to empty.
Within the loop, add Delay with 1 minute, then Get file properties, select ID from the trigger.
In the action Set variable, select dynamic content DueDate from Get file properties action.
Note: Value used in the Do until condition should be from actions that we’ve added in Do until loop.
Under the loop, add action to send an email.
An image for your reference.
Best regards,
Mabel
ARe you still using the properties form the trigger? Those won't work because they aren't updated after the trigger fires. That's why I said you needed to do another get file properties after the delay. That set of properties should be the updated ones. But you have to be careful which ones you are using in the dynamic content list.
#1
WarrenBelz
146,658
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
