You’re offline. This is a read only version of the page.
15
Hello, Desperately seeking advice for this flow that I have been working on for the last couple of weeks. I finally have it updating the SharePoint list correctly and filtering correctly, however, when I go to have the Excel row updated after an item is created in the SharePoint list, it is updating the rows sequentially and not updating the row that was filtered and added to the SharePoint list. Am I missing something between Create Item and Update a Row? If so, please, somebody, anybody, help me figure out what it is I'm missing.
The flow starts with a manual trigger and lists the rows in my table.
I then have it filter for the jobs that have been 'awarded' based on the status column. I then have a control that says if it is awarded and listed as no for being imported (hoping this will avoid repeated items in the list getting created so that this list can be automated in the future) it is determined if the criteria is met, an item will be created in a SharePoint list.
The items are getting created on the list, as you can see, however in the screen grab below it, you will see that the List ID and Job Number do not match the rows that were updated with 'Yes, ID' in the Excel sheet. My goal is for 23052 (ID 1837) to be updated in the Excel as 'Yes, ID'.
Huge thank you in advance!!
When using Update a row, the Key Column would need to contain unique values. If you use Imported as the Key Column and have the Value of No, then it will find the first row in your Excel Table that has the value No in the Imported column, and update that item.
I would suggest using Master Job Number as the Key Column and adding the actual Master Job Number as the Value as this looks to be unique in your Excel Table.
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
