Unanswered

Update a SharePoint list when a From is submitted

(0) Share

Report

Posted on by AnnetteM

I have a flow that is triggered when a form response is submitted. I then do the following:

Get the form's response details
Get the SharePoint list details
Filter Array where the recipient email address in the SharePoint list matches the responders email address in the form
Apply to each with an update to a SharePoint list's column to the date the form was submitted

I thought the filter array would do it, however EVERY ITEM in the list is getting updated and not the ones where the email addresses match. Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 68,898 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Make sure you are using the Filter Array output in your apply to each and not the Original SharePoint Get Items. One of the problems with Filter Array is that it doesn't re-apply the schema from the array automatically. So you don't see the individual values in the array after filtering unless you do a Parse JSON on the output. As a result people often mistakenly use values from the original array (Get Items) instead of the filtered ones. That will result in the problem you are seeing.

Was this reply helpful? Yes No
AnnetteM on at

Like (0)

Report
Copy link

Link copied!

Oh, I am not sure how to do that. Is there a different, more straight forward way to accomplish this? I want a trigger when a form is submitted, call up the SharePoint list, find where the forms respondent (email address) is the same as the sharepoint list column for email address and then update another column in the SharePoint list with the date of form submission.

Was this reply helpful? Yes No