Power Automate - Excel Fails Workflow When Row Not Found

[Anonymous]

Hi all,

So the Excel module fails a workflow when a match isn't found, however I intended for users to be able to put in data that may not match that in the table and then create a branch is excel did not find the results. Essentially the workflow is testing if the data is present in the table.

Is it possible to get around this and use flow to check if data is present in a table?

Thanks,

Josh

[OliverR-82]

Hi @Anonymous , 

Can you post a screenshot of your current flow?

[v-qiaqi-msft]

Hi @Anonymous,

Do you want to check if the data existed in the excel table?

Could you please share a bit more about your scenario?

There are ways to achieve your need, one is using condition action split a flow to “have been found” and “haven’t been found” paths.

Here is an example that if the flow find the value, it will insert a row, otherwise, end the flow.

One the other hand, I think you should use the Error handling.

[Anonymous]

Hi Qi,

Thanks a lot for your help - still seeing excel failing the whole workflow, despite having a condition that is available if excel is unable to return a result. Don't understand why excel still seems to insist on stopping everything!

 I have attached a screenshot of the workflow I built on your advice. I think it will work fine if Excel doesn't forcibly fail the whole workflow!

Kind Regards,

Josh.