Answered

Update SharePoint List existing line item from form entry using email

(0) Share

Report

Posted on by sberry

Hello Microsoft Power Automate Community,

I have a SharePoint list pre-populated with learners names, emails, and columns for each week a homework needs to be completed. When the learner completes their homework form, I want their row and specific homework week column to be updated.

In the flow we currently have, we are just trying to get the email from the form to line up with the email of the SharePoint list. The flow below will run through all the steps but it comes back as false for the condition and will not update the SharePoint.

Let me know if I am making any sense or if you need additional pictures

Thank you,

Sam

Get items

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@sberry

Can you share screens from your flow run history please?

Your flow looks structured correctly so it needs a bit of debugging.

Was this reply helpful? Yes No
sberry 23 on at

Like (1)

Report

Hey @Mira_Ghaly

I'm sorry I missed your response! I went into settings to ensure I'm will get them in the future. So I may have modified this flow since Feb but here is the updated version below. I've been watching a ton of power automate Youtube videos and found out how to get the correct name of columns and updated that.

When I run my flow, its successful but no updates in SharePoint list.

Was this reply helpful? Yes No
sberry 23 on at

Like (1)

Report

The flow isn't failing and is pick matching my email but in the condition nothing happens to the SharePoint list isn't updated. @Mira_Ghaly

Was this reply helpful? Yes No
jabrehmer 13 on at

Like (0)

Report

Mine passes all steps, but fails to update the sharepoint list as well.

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

If your filter query is set up how you show it in your screen shot, you are not using the dynamic content of the field that contains the user's e-mail address. It looks like you just hard coded '[Email from the form]' into the query, which will not work. If the submitter of the form is the e-mail address, you can use Responder's Email from the dynamic content picker. It would then look like this in the filter query:

Was this reply helpful? Yes No
sberry 23 on at

Like (0)

Report

I updated it with the tag like you did but it keeps going back to this output expression I entered since posting this

The screenshot below shows how it didn't match up emails I suppose.

Was this reply helpful? Yes No
Verified answer

sberry 23 on at

Like (0)

Report

ok, I was able to get it to work. My column in SharePoint was not pulling up in the filterquery so I created a test column, reloaded the SharePoint list in the flow, and then the emails matched!

It looks like we can't use a people or group column for email to match an email from form. I had to recreate my email column as single text.

Was this reply helpful? Yes No