how to get file name and compare it to excel sheet name

[barney1234]

hi everybody. i am really new to this world. i want to create a flow that when i add a file name to a folder.

it will get the file name, compare the file name to an excel worksheet and check if they match. if they don't, it I will create a new excel sheet by the file name.

[eric-cheng · Accepted solution]

Hi @barney1234 ,

Try the below flow.

1) Use a when a file is created in a folder trigger and then get metadata

2) Initialize a Boolean variable and set it to @false.  Add a Get worksheets action to get all the worksheets in your Excel

3) Loop through each Excel worksheet and add a condition where Name of worksheet is equal to Name of file (from Get File Metadata).  If found, set Boolean variable to @true

4) Exit the loop.  Add another condition to check whether your Boolean is false (i.e. it did not find a worksheet with the same name).  If true, create a worksheet with the name of the file (from Get File Metadata).

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn