- Are you using AGO or Enterprise?
- AGO, you can skip this step
- Enterprise, you first need to create a Custom Power Automate Connector. Follow this guide from Esri. The screen caps are a little out of date, but all the steps are the same so this works beautifully. Be aware that if you generate Feature Reports using this connector, you need to refresh the connectors credentials every two weeks (I do mine every Monday). It's not hard -- takes about 10 seconds from opening web browser to completing task.
- There are a few different resources kicking around. And what you are looking to do could end up looking slightly different from someone else doing the same task.
- Here is generating a Feature Report and uploading to One Drive.
For reference, I have all of my flows split into (at least) two parts. Part 1 dumps raw data into an SP list as fast as possible. Step 2 involves all the complicated tasks. That way, if there are any errors at any point in the process, the flow will attempt to self-correct. I recommend this as sometimes, things like to fail for "no apparent reason". It's not common, but sometimes SP for instance returns an error, the flows tries again, and everything is fine. I was hoping to put together a guide for this set-up someday so I could just refer people there.