I have been working on one large workflow to be able to pull reports my department needs multiple times a day, through our very old legacy reporting service, Qport.
I have basically every part of this flow down, except for one report. Each report requests a date or multiple dates to pull data from, and this specific report, requires me to enter two dates, the beginning date for the period, and the current date. I have this, and other reports pulling the current date perfectly fine, but when it comes to the beginning period date is when I've run into some problems.
I want it to automatically pull these dates i have entered in an Excel spreadsheet, and when we've moved onto the next period, have it automatically move onto the next date without any contact from me. Following is the excel sheet with our month starts dates that I would like it to automatically move down. We go by a retail fiscal 4-4-5 calendar.
I currently have the date extraction set up like this but don't know how to move forward with it. Please let me know if I am on the right track, what I can do to finish off this process, or if this may not be possible to do with Power Automate. Thank you all for any help that can be given and have a great week


Report
All responses (
Answers (