Hi,
I have a list of dates in an Excel file. I want to read the date (one at a time) in the file and enter it into a date field on a website so that I can download a year's worth of data from the website. This reading, entering and downloading actions will have to be repeated multiple times since the website limits the date range to maximum one month only.
The Excel file content looks like this:
I know how to make Power Automate Desktop enter the dates and download data from the website. But I have trouble to read the dates in the Excel file dynamically. Specifically I need help on action 5 here:
I want to specify the row and column that I want in the variables called RowNumber and ColumnNumber and use them in the MonthRange variable, not by hardcoding the row number and column number in the variable like this: MonthRange[0][0]. The idea is to increase the RowNumber and ColumnNumber variables by one when a loop repeats, so that I can read the dates in the next row and column when the loop repeats itself.
But it seems like the syntax %MonthRange[%RowNumber%][%ColumnNumber%]% is not correct as shown in the error message.
Can anyone guide me how to do this in Power Automate Desktop? Any help is appreciated. Thank you.
Fairuz
