You’re offline. This is a read only version of the page.
17
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.
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
Share
Report
All responses (
Answers (
