Hi everyone,
I need to create a flow to help me filter data in an excel table. Then create item in a SharePoint list if there are rows that meet the condition. These are my actions:
The flow ran successfully but no record was created. What exactly went wrong with my flow?
Hi @Daniel-tqd ,
Please check the run history and see if outputs of List rows present in a table action is empty. Based on the official doc:
Excel Online (Business) - Connectors | Microsoft Learn
Only 1 filter function can be applied on a column.
So, please try and use Filter array to get rows from the Excel table. Be noted that Pagination in settings of Excel action needs to be turned on.
Best regards,
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2