Answered

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

(0) Share

Report

Posted on by Amanda_S

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 (8)

Answers (1)

Sort by

Suggested answer

PowerDeveloperTP 453 on at

Like
a
(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
Amanda_S 24 on at

Like
a
(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 453 on at

Like
a
(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
Amanda_S 24 on at

Like
a
(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
Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(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
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @AS-17031936-0

If this solution helped, please consider marking it as the verified answer so it can help others in the community 😊
If you still need assistance, feel free to let us know, we’re happy to help!

Was this reply helpful? Yes No
Amanda_S 24 on at

Like
a
(0)

Report
Copy link

Link copied!

It was this combination that worked:

Has Column Changed: Status is equal to true

Status Value is equal to Eligible

Thank you so much for your help!

Was this reply helpful? Yes No
Amanda_S 24 on at

Like
a
(0)

Report
Copy link

Link copied!

I would like to add to this flow...I have created a new column in my SP List to capture whether or not the email was sent successfully. The corresponding field in the column should say Sent if the email was sent successfully and Failed if the email was not sent successfully.

What should the Condition be following the Send an email (V2) step?

Was this reply helpful? Yes No