Send Email to Form Submitter When Status of List Item is Modified

(0) Share

Report

Posted on by AS-17031936-0

I have a SharePoint list that is populated from MS Form submissions. The list contains a Status column as well as the First Name, Last Name, and Email Address of the person submitting the form. I would like to create a flow that sends an email to the submitter's email address when their status is changed from New to Eligible. Any help here would be greatly appreciated. Thanks so much!
Amanda

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

PowerDeveloperTP 379 on at

Like (0)

Report
Copy link

Link copied!
Hello,

You can create power automate with following steps:

Trigger: When an item is modified

Choose trigger: “When an item is modified” (SharePoint)

Add “Get changes for an item or file (properties only)”

This step is key to detect actual changes.

Site Address , List Name, Id → ID (from trigger), Since → Trigger Window Start Token

Add a Condition

Now check two things:

Has Column Changed: Status = true
AND

Status = Eligible

If YES → Send email : Use Send an email (V2)

Thank you.

Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

Was this reply helpful? Yes No
AS-17031936-0 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for the quick response!

Unfortunately, my flow keeps failing. I have included my current configuration.

The error appears to be occurring in Step 2. I have also included the error status message.

Any suggestions?

Send Email to For...

Was this reply helpful? Yes No
Suggested answer

PowerDeveloperTP 379 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Thanks for the details.

One thing I observed is that you have hardcoded the "trigger window start token" in Get changes action.

It should be picked up from the trigger like below

Hope this would be helpful.

Thank you.

Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

Was this reply helpful? Yes No
AS-17031936-0 4 on at

Like (0)

Report
Copy link

Link copied!

Welp, that's odd. Thank you for catching it! I've fixed that and it appears to be running, however, I'm now getting an Expression result of False for my Condition as well as the following alert in my Send an email step:

ActionBranchingConditionNotSatisfied. The execution of template action 'Send_an_email_(V2)' skipped: the branching condition for this action is not satisfied.

I have tried Status is equal to Eligible and Status Value is equal to Eligible, but I get the same result either way when I update the Status field to Eligible in my SP list.

Was this reply helpful? Yes No
Suggested answer

Kalathiya 1,574 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @AS-17031936-0,

I think the issue is that the condition. You’ve written True, but it needs to be lowercase true. Change it to true and it should work correctly.

Because of this, the condition isn’t satisfying.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No