Survey123 Create Report Automation Failing
Hello,
I'm trying to set up a Power Automate flow with the Create Report function using a custom connector from our ArcGIS Enterprise 11.1.
However, after trying everything from this tutorial, I am still receiving an error at the "Upload file from URL" (3rd step). Does anyone know how to overcome it? Or if there is a workaround?
I also found this thread in the community, but since I am a Power Automate novice, I wasn't able to follow all the steps.
My custom connector is working because I use it in another flow where I populate a predefined Word file with data from Survey123 and is refreshed every 14 days due to the token expiration date.
Below is how my flow is currently structured:
Thank you in advance!
I have 2 recommendations.
1. To resolve your report issue, maybe try an HTTP Get after the report generation. Then, Use that HTTP step to upload:
In my example, I am uploading to SharePoint. You can just replace that with One Drive.
2. The Create Report step is a self-contained Do Until. It will always "Do Until" a report is created. The issue is that it always succeeds even if report generation fails. As such, I would add this:
Just be sure to choose this "status":
Then, use a Condition. You want all of your flows "bulk" to be in the "yes" side of this condition.
This is a simplified version of my flow, but really the most important parts.
