Unanswered

When a File is Created triggers too soon

(0) Share

Report

Posted on by Community Power Pla...

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.

Categories:

Using flows

I have the same question (0)

All responses (12)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

AFter the file is created trigger fires add a delay to the Flow. The issue a Get File properties to get a fresh set of the metadata for the file. by then hopefully the date you are waiting for will populate.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

Thanks for your prompt reply.

I have tested a delay of 5 minutes. But the content of the email is still not pick up the dynamic content, i.e. due date.
The due date column is updated within 1 minute after the file loaded to SharePoint.

Any alternative way to resolve this?

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Pstork1,

I have tested with get file properties. The auto email notification is sent without the due date too.
😞

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-yamao-msft,

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.

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-yamao-msft

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.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Pstork1

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?

Was this reply helpful? Yes No