You’re offline. This is a read only version of the page.
Announcements
Hi,
I am new to Power Automate hopefully I have asked my question on the right channel.
I have a system developed via Power Automate. All of the flows use an Excel online sheet to read and update the necessary data. I have one test and one live file. Some of the flows has 20 excel file related steps (get a row, update a row etc.) in the flow so to run the flow with the test file I have to go through every step to change the file name and when the test is successful I have to revert the file name again.
I tried to have some test records on the live file, however this time I need to change get row filters all the time before triggering the flows not to consider the live data and only to cover the test data that I have, it is not something easy to maintain.
I am looking for a way that I can define the filename as a variable / parameter, so to run the flow via test file I will not need to change every step to update the file name, one parameter change would be enough to switch between the live file and the test file. Is there any way of achieving this?
Kind regards,
Funda
Hi @Anonymous,
You could use Get file properties action to extract the File identifier, then append it to the File box could approach that.
PS: The table name should append as a custom value:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Share
Report
All responses (
Answers (
522
