Unanswered

I need flow to trigger only at first modification

(0) Share

Report

Posted on by SLBMetrology

I have a SharePoint List that is generated by a form (A). When form A data is input into the list it assigns tasks which a secondary flow sends out emails to the corresponding team members assigned. Each person assigned fills out Form B and it backfills to the list on the same line item using a filter.

My issue is that it is resending the original email to everyone for their assigned tasks each time a team member fills out form B since the line item is technically being updated. I only want the first email flow to trigger the one time. Not each time a response is added. Is there a way to limit this??

Thank you in advance for your help.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Re: I need flow to trigger only at first modification

Add a field to the list that tracks whether its been modified or not. In the flow set that field the first time the flow runs. Then add a trigger query to check that value to control whether the flow triggers or not. That will keep it from triggering on anything other than the first modification.

Was this reply helpful? Yes No
SLBMetrology 88 on at

Like (0)

Report

Re: I need flow to trigger only at first modification

@Pstork1 Possible silly question but pertaining to the field I add to the list, how would i have it indicate whether or not anything has been modified?? In other words how would it know??

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

Like (0)

Report

Re: I need flow to trigger only at first modification

You can do it however you like, but the easiest would be a single line of Text field that gets filled in with "Emails Sent" or "Modified" or something like that.

Was this reply helpful? Yes No
SLBMetrology 88 on at

Like (0)

Report

Re: I need flow to trigger only at first modification

@Pstork1 Would I set the trigger query between "get changes" and "condition". I'm very new to all this so thank you for your patients.

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

Like (0)

Report

Re: I need flow to trigger only at first modification

Its actually a query you set in the settings of the trigger. Here's an article that describes how to do it.

Power Automate Trigger Conditions made EASY - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
SLBMetrology 88 on at

Like (0)

Report

Re: I need flow to trigger only at first modification

@Pstork1 I'm super lost. Even with the article. Apparently "Made Easy" is not easy enough for a newbie. lol I dont even know where to begin creating a function.

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

Like (0)

Report
Re: I need flow to trigger only at first modification

Use the following

@equals(triggerBody()?['columnName'],'')

Where columnName is name of the text column you create in SharePoint. Put this in the trigger conditions in the settings of the Trigger.

Was this reply helpful? Yes No
SLBMetrology 88 on at

Like (0)

Report

Re: I need flow to trigger only at first modification

I have it set to switch to "complete" when an audit is completed. This should trigger the initial emails to the team. With what I have below it isn't even sending that initial email.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report
Re: I need flow to trigger only at first modification

If you want to send the emails when it is set to 'complete' then that is what you should be checking, not ''. Then after the emails are sent change it to something else so it doesn't fire again.

@equals(triggerBody()?['FlashAuditComplete'],'complete')

Was this reply helpful? Yes No