Power Platform Community Forum Thread Details

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

Categories:

Using connectors