Make Excel Cell Value as Trigger Condition in Recurrence/ Scheduled flow

[jaina]

Hi,

I have a flow where in it captures the value presented in Excel and then capture in SharePoint List.

Here's how my excel looks like:

I need to set a trigger condition wherein if the RPA_Status = 'Completed' it will only get the data and store it in SP List. 

Here's my flow:

[tom_riha · Accepted solution]

Hello @jaina ,

you can't build a trigger condition based on values in an Excel file (reading data from Excel comes after the flow is triggered).

But to process the data differently based on the RPA_Status column you can use the 'Filter array' action. After you 'List rows...', filter the 'value' results in the 'Filter array' action to keep only the ones where RPA_Status is equal to 'Completed'. All rows that stay in the output of the 'Filter array' can be just stored.

Then you can add another 'Filter array' to get only the rows where RPA_Status is not equal to 'Completed' and process them differently.