I assume you are Enterprise, but if you are AGO, it is slightly different (and easier, since you can skip a step). Also, if you are Enterprise, but you have an old connection (like I did), you will not see any of the new options unless you update your old connector (which is easy, but annoying).
If you are Enterprise and are making a connection to Power Automate for the first time, it's relatively straight forward:
- Follow instructions here. Esri hasn't updated the graphics in a while, but it is still valid.
- After you add that connection and test connections successfully, you are done! You will see all the new options when you create a flow.
Beyond that, it is really up to you for what you want to do. Personally, I upload all generated reports to SharePoint for storage, then I use those files in all subsequent processes (mainly to avoid issues pulling a report at a later time).
Is there a specific thing that isn't working or place you are stuck?
Ahh. So it shouldn't be necessary to do this inside an Apply to Each Do Until. I only figured out my connection was outdated earlier this year, and have since updated that and modernized all my flows. As such, I've been using the new workflow for most of the last year, and haven't run into any issues yet.
Here is my (very simplified) process:
When adding the Value to your Variable, you need to select status of the first result file. If you select the other "status", your Set Variable step will be tossed into an apply to each. That is because Esri's Create Report step is a self-contained Do Until. Esri set up all of the "... of the first result file" variables specifically for situations like this.
NOTE: I suppose you could probably skip over the Variable entirely if you really wanted. I just like variables.
