Power Platform Community Forum Thread Details

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.

Categories:

General topics

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