cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lipster26
Frequent Visitor

Check if excel Table exists

Hello,

 

Looking for a way to create a condition to check if an table already exists in an excel file. Any way to do this with a condition step?

 

Thanks.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
CraigStewart
Super User
Super User

Yes this can be done.

 

I have this set up to ensure that the proper template is being used for uploading documents:

 

I've set the name as a variable so that I can change it easily if required.

 

I used get tables to list all tables in the excel document

Filter the array to look specifically for the tablename

Then used the condition to validate that the table name actually exists.

 

CraigStewart_0-1661958408986.png

 

 

View solution in original post

2 REPLIES 2
CraigStewart
Super User
Super User

Yes this can be done.

 

I have this set up to ensure that the proper template is being used for uploading documents:

 

I've set the name as a variable so that I can change it easily if required.

 

I used get tables to list all tables in the excel document

Filter the array to look specifically for the tablename

Then used the condition to validate that the table name actually exists.

 

CraigStewart_0-1661958408986.png

 

 

lipster26
Frequent Visitor

Great this works, thanks!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,810)