Unanswered

How to check if a table exists in excel using power automate

(0) Share

Report

Posted on by birenpat

Hi,

Can anyone provide a solution on how to check in the excel whether a table exists or not. How to validate it? If table doesn't exist then create a new one, otherwise do nothing.

Appreciate a reply at the earliest.

Regards

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

gyjhfyjdrfhj 49 on at

Like (0)

Report

Oh man! I just created the same exact post! lol

To check if a table exists I am using the Get tables box and then checking if length(outputs('Get_Tables')?['body/value']) is equal to zero. How to create one if it doesn't exist is where I'm having an issue...

Was this reply helpful? Yes No
BB-03031942-0 4 on at

Like (0)

Report

Did you ever sort this? I'm using "Get tables" and the if condition. I can get it to work if table does exist, and it just by passes. But when table doesn't exist, the workflow fails with "Action 'Get_tables' failed: Item not found clientRequestId: ", it seems to just fail because the table doesn't exist, rather than move to the condition check and then create if false.

Was this reply helpful? Yes No