I am using the modern excel activities and would like to use the Rename Sheet activity. However, I do not know the sheet will be named after the download of the Excel file, so I would like to reference it as the first sheet (sheet 0) and then change the name that way.
Is this possible? Thanks
It is possible to rename the sheet only if the mentioned name in the rename Sheet exists
other you cannot imagine what the name of the sheet it will come when you download
Hey @jpreziuso ,
You can use below activity
It will take the index as an input and outs the column name
Hope it helps you!
Hi @jpreziuso
In modern activities there is an activity called For each excel sheet activity which iterates the sheets in the excel.
Inside the For each excel sheet activity you can get the name of the column.
Check the below workflow image for better understanding.
Hope it helps!!
