You’re offline. This is a read only version of the page.
Announcements
37
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
I feel like one of the best ways to go about this would be to create an expression or variable that specifies that I need to pull the value in my worksheet that is less than the current date. I am just new to Power Automate and not sure how to go about this.
Share
Report
All responses (
Answers (
