Need help to compare the list items and then do an action based on the output.

[Santhosh_V_26]

Hi All,

Flow Details: I am having a flow that gets the data from email and create a item in SPO List. And the column names are Record Number, City, Country and so on. I was getting multiple emails for one record number and at that time the flow need to check If the record number is existing or not in the SPO list.

Actions:

• If the record number is already exists in the list, then need to just update the Column values
• If the record number is not found, then need to create an item in the list.

Any suggestions on the condition part..

Thank you.

[henkenTech · Accepted solution]

• When you get your items, add an OData filter for the Record id (ColumnName eq 'RecordId').
• Then, in your condition, count the returned items using the length() function and use the greater than condition with a 0 on the other side. When the item is not yet in the list, the No branch of the condition will be activated and the other if the item is already in the list.
• Then, use a Create Item and Update Item respecitvely.

Hope this help 🙂

[ekarim2020 · Accepted solution]

For the record number, you should check that the SP list ensures that there are no duplicate Record numbers:

It probably needs to be a required field too:

Filter query can be used to Get Items (uses oData filters to construct the query):

Use a condition to check to see if any records are returned:

If length(outputs('Get_items')?['body/value']) is greater 0 - that means a record was returned by the filter:

Note that even though only one record is returned, Get Items returns an array, which Power Automate will need to cycle through, hence the use of Apply to each loop.

I hope this helps.

Ellis