Power Platform Community Forum Thread Details

Hi,

I need help with a flow. I have a list that is populated by a spreadsheet. I need a flow that checks the spreadsheet to see if a specific column doesn't say "Not Cancelled. Then I want it to update the existing item on the list to change a column to "yes" if the condition is met. I thought this would be an easy task, but I just cant get it to work.

So far I have:

Recurrence>Get Item>List Rows Present in Table>For Each>Condition>For Each>Update Item.

How do I get it to match the fields between the excel and the list so that it can update the correct entries on the list?

The data in the excel has a unique identifier that is carried over to the list.

Categories:

Building flows

Do you have a unique field in your spreadsheet that you also populate to the SharePoint list. This is a concept known as a primary key. If you don't have this, then you need to create one to do what you want. If you are not familiar with the concept of a primary key, here is some information to assist you: Primary Key in DBMS - GeeksforGeeks

Once you have the relationship set up, then it is just a matter of using an apply to each to update the SharePoint list. In the apply to each:

Add a Get items action
1. Add a filter query using the internal name of the field in your SharePoint list where it is eq (equal) to the value in the spreadsheet (note, in the example below, it is checking numeric data. If you are using a string as your primary key, the value from the Excel spreadsheet needs to be in quotes).
Add a second Apply to each set to the items returned from the first Get items action.
Add an Update item action in the second apply to each.
1. Configure it to the same SharePoint list as the Get items action and use the ID from that action in the Id field.
2. If you have set up your primary key accurately, only one record should be updated for each item in the spreadsheet.

The flow will look like this:

If you do not correctly set up the primary key between your Excel file and the SharePoint list, if the Get items filter finds more than one item based on the filter query, it will update every item matching the filter query.