topic Re: Create Feature Report in Microsoft Flow - Power Automate in ArcGIS Survey123 Questions

Create Feature Report in Microsoft Flow - Power Automate

wcozzens — Mon, 01 Jun 2020 12:02:10 GMT

Currently what is the best method to create feature report from Survey123 in MS Flow/Power Automate?

I have this process running successfully in Integromat, but am looking at transitioning this over to MS Flow (Power Automate)

There is no "Create Feature Report" module in MS Flow like there is in Integromat. I did notice in another post there is a (Premium) service in Flow called "Populate a Microsoft Word Template". Is that the only way now to handle this process in Flow?

Is there another "Create Feature Report" module planned for releasing in MS Flow? Since the "Populate a Microsoft Word Template" is a Premium service, I cannot access that to try.

Re: Create Feature Report in Microsoft Flow - Power Automate

JamesTedrick — Thu, 30 Jul 2020 20:52:28 GMT

Hello,

Apologies for the delay in response. Currently, creating a report from Power Automate is possible only through the manual creation of a webhook action to trigger the report creation and monitor the job status. The Survey123 team is researching the possibility of incorporating feature report in to the Power Automate connector in the future.

Re: Create Feature Report in Microsoft Flow - Power Automate

MikeFiguray — Wed, 26 Aug 2020 18:41:38 GMT

Hi James Tedrick, is there documentation on how to manually create the webhook to trigger a feature report? I've tried to switch to integromat for this purpose, but apparently they can only accept credit card or paypal as payment methods. As a government agency we do not have the ability to pay using either of those.

Thanks!
Mike

Re: Create Feature Report in Microsoft Flow - Power Automate

JamesTedrick — Fri, 28 Aug 2020 00:06:51 GMT

Hi Mike,

There is documentation for starting the Create Feature Report job in the Early Adopter Community. That being said, this is an asynchronous process, so your flow will need to process that (it does not currently support the default asynchronous pattern Power Automate expects).

Re: Create Feature Report in Microsoft Flow - Power Automate

PrachiPatel — Tue, 16 Mar 2021 15:23:07 GMT

Hi James,

The documentation for starting the Create Feature Report job is no more available on Early Adopter Community page. Does the documentation exist elsewhere?

Re: Create Feature Report in Microsoft Flow - Power Automate

EricChez — Tue, 30 Mar 2021 12:45:02 GMT

Hi James,

Just a follow up on this, will this be on the roadmap for release this year?

I'd love to transition all my survey123 report integromat scenarios over to Power Automate.

Re: Create Feature Report in Microsoft Flow - Power Automate

TMaddio — Tue, 13 Apr 2021 14:27:37 GMT

Did you ever get the correct link for the Create Feature Report Job? I'm trying to get something like this to work in Power Automate.

Thanks.

Re: Create Feature Report in Microsoft Flow - Power Automate

PrachiPatel — Tue, 13 Apr 2021 14:32:32 GMT

I have not. I ended up setting up an automated email with summary information from the submitted survey that the submitter is instructed to print to pdf.

Re: Create Feature Report in Microsoft Flow - Power Automate

TMaddio — Tue, 13 Apr 2021 14:36:55 GMT

Ok. Thanks. That is the option I am using also for now. Hopefully there will be a Feature Report connector available for Power Automate in the near future. We are unable to use our Microsoft OneDrive with 3rd party apps like Integromat.

Re: Create Feature Report in Microsoft Flow - Power Automate

ZoltanKelly — Mon, 31 May 2021 20:00:00 GMT

Hi @JamesTedrick , as mentioned below, the documentation for starting g the Create Feature Report job via Microsoft Flow is no longer available in the early adopter site (that I could find). Is this available elsewhere?

Re: Create Feature Report in Microsoft Flow - Power Automate

Ruth_JiatengXu — Thu, 08 Jul 2021 07:35:26 GMT

Hi @ZoltanKelly @TMaddio @PrachiPatel

The link that James provided is the instruction on how to use Report REST API, and the developer documentation for the Report REST API is now publicly available on https://developers.arcgis.com/survey123/api-reference/rest/report/. You can try using the REST API with power automate to generate report.

Thanks,

Ruth

Re: Create Feature Report in Microsoft Flow - Power Automate

ZoltanKelly — Tue, 20 Jul 2021 10:28:57 GMT

Hi @Ruth_JiatengXu - thanks. The documentation is no longer accessible in the Early Adopter community - the message on the page is 'The page you are attempting to access is unavailable.'. it's not visible anywhere in the documentation section either.

However with the REST API docs i've managed to kludge a workflow as an Azure Logic App (which is ~Power Automate aka MS Flow) but allows for pay per use instead of fixed costs for their 'premium' HTTP connecter (as of July 2021).

Below is for reference for anyone else. python would be neater but Logic Apps meets our requirements to schedule and manage.

Re: Create Feature Report in Microsoft Flow - Power Automate

JoseVidal — Tue, 17 Aug 2021 18:07:07 GMT

Can you post the details of your workflow above? Open up the boxes and let us see what the URLs/params/etc. is inside them? Thanks!

Re: Create Feature Report in Microsoft Flow - Power Automate

WalterWilliams — Sat, 18 Sep 2021 15:13:41 GMT

I am also interested in the link above. would be grateful if it is shared here again.

Re: Create Feature Report in Microsoft Flow - Power Automate

ZoltanKelly — Sun, 19 Sep 2021 01:28:48 GMT

Hi, here are expanded steps. note:

1. this probably could be a heap cleaner but just conceptually can get you started

2. see these docs to understand logic of the api - Report | ArcGIS Survey123

2. this is sending a specific email for a specific form. intention is we refactor this so it grabs all the parameters (source form, email subject/body/addresses, anything else) from a table so we can have a single flow running that can be dynamically picked up.

Re: Create Feature Report in Microsoft Flow - Power Automate

wcozzens — Tue, 05 Oct 2021 12:57:51 GMT

Hi Zoltan,

Thanks for posting that. I recreated that flow and everything works - except if the report template contains a geopoint type question, then it fails with:

["An error occurred when rendering by the report engine. Failed to print map for `$map_geopoint`. waiting for function failed: timeout 180000ms exceeded"]

If I remove the geopoint question from the MS Word feature report template, then it works fine and generates the report from the Flow API request. When the geopoint question is included, the report generates normally without error from the Survey123 web site, but fails if called from the Flow API.

I have already opened a support request with ESRI on this issue, but so far we have been unable to resolve this. The query works and everything is returned, but it seems like it cannot access the map used for printing the geopoint in the MS Word feature template.

We have tried many things to to resolve this, including adding the webmapItemId and mapScale parameters and trying different formatting of the request within Flow and also using Postman, but nothing seems to work when a geopoint question is included.

Just wondering if you or anyone else has tried including a geopoint question in the MS Word feature report and then using the API request from Flow to generate the report. Has anyone successfully done this, had similar issues or found a way to resolve this problem? I'm testing with a report template that is very basic - one question and one geopoint... no repeats or anything.

Re: Create Feature Report in Microsoft Flow - Power Automate

wcozzens — Thu, 27 Jan 2022 12:26:52 GMT

Thanks to James Tedrick at ESRI - the solution to the issue we were having generating reports using the Create Feature Report API in Microsoft Power Power Automate has been resolved. The issue was a bit difficult to diagnose, since everything worked as expected except when a geopoint question was included in the report template, then it could not render the map on the report and the process would timeout.

The solution is to make sure the generateToken API request in the flow includes the value referer=https://survey123.arcgis.com