topic Survey123 Create Report Automation Failing in ArcGIS Survey123 Questions

Survey123 Create Report Automation Failing

MariusVerdes — Thu, 25 Jan 2024 15:16:25 GMT

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!

Re: Survey123 Create Report Automation Failing

abureaux — Thu, 25 Jan 2024 15:33:31 GMT

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.

Re: Survey123 Create Report Automation Failing

MariusVerdes — Fri, 26 Jan 2024 13:47:50 GMT

Hi @abureaux ,
Thanks for the suggestion. But when I try to replicate your first recommendation Power Automate automatically adds a "for each" condition to the HHTP GET (I use the "url" from the create report action to populate the field). Do you know why and how I can work around it?