Unanswered

Updating specific Sharepoint list items that meet the criteria from a filter array

(0) Share

Report

Posted on by svzbk

Hello,

I have a Sharepoint list and spreadsheet that has info added from 1 flow triggered when a User completes an MS form submission (that all works).

Following that, an administrator checks the spreadsheet and adds today's date when they are happy all the data is correct.

My second flow runs daily and applies a filter to check for 'Today's date' and sends an email to those specific Users who had their application approved 'Today'. Again, that bit works.

However, I'm coming unstuck trying to update the Sharepoint list automatically by altering the approval status, start date and end date for those specific Users. I'm trying to use the outputs of the filter, but currently every entry in the list is being updated with the same data from the first entry that is a valid output from the filter.

Can anyone help?

Cheers,

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@svzbk the filter that you have applied is that on spreadsheet rows or SharePoint list items? It looks like the ID value that you have used in the Update Item action is coming from Get Items output, which updates all the items that are returned by Get Items.

Was this reply helpful? Yes No
svzbk 10 on at

Like (1)

Report
Copy link

Link copied!

@annajhaveri,
Thank you for replying.
I realised that I had been making life harder for myself by trying to go from a from, to a spreadsheet, which some info then added/duplicated to List, and then updates required to both.

I ended up redesigning the process so that it is List based and any salient points are drawn across to the spreadsheet with a daily update.

So, in the flow about, by Getting and Filtering the List as the first step it all went well.
Thank you.

Was this reply helpful? Yes No