topic Re: Survey123 submission that is resent from inbox or sent folder in the ios app is not triggering microsoft flow in ArcGIS Survey123 Questions

Survey123 submission that is resent from inbox or sent folder in the ios app is not triggering microsoft flow

TaylorSchyrbiak — Wed, 04 Nov 2020 21:05:21 GMT

I have successfully created a flow from my survey123 survey created from connect to an excel online file. I can get the flow to add new rows to the table. However, after several attempts and trialing a few other forums suggestions, I still cannot get the flow to trigger, let alone update an existing row in my table, when editing and resending a survey from the inbox or sent folders of the ios app. I have tried using the objectId as well as calculated uuid() for indicators. The flow itself will also perform without error, but when tested for a resubmission, it is not triggered.

Can someone provide a template on how to "update a row" in an excel file when an existing survey response has been edited from the ios app?

Re: Survey123 submission that is resent from inbox or sent folder in the ios app is not triggering microsoft flow

ZacharySutherby — Fri, 06 Nov 2020 21:46:50 GMT

Hello Taylor Schyrbiak‌,

In the Survey123 website if you navigate to Settings > Webhooks > Edit webhook is "Existing record edited" enabled for Trigger events?

Thank you,

Zach

Re: Survey123 submission that is resent from inbox or sent folder in the ios app is not triggering microsoft flow

TaylorSchyrbiak — Fri, 06 Nov 2020 23:21:30 GMT

Yes, that was it! I guess mine were all defaulted to off.

Sent from my iPhone

Re: Survey123 submission that is resent from inbox or sent folder in the ios app is not triggering microsoft flow

ZacharySutherby — Fri, 06 Nov 2020 23:29:19 GMT

Hello Taylor Schyrbiak‌,

Sweet I am glad that worked out! Unfortunately with the Survey123 Power Automate connector monitoring for updating records is not enabled by default.

- Zach

Re: Survey123 submission that is resent from inbox or sent folder in the ios app is not triggering microsoft flow

JoshuaFergusonPCW — Mon, 08 Feb 2021 22:55:38 GMT

Do you mind showing your flow with any expressions clearly shown. I'm trying to do the same thing but not having any luck with the updating of a row.

Re: Survey123 submission that is resent from inbox or sent folder in the ios app is not triggering microsoft flow

RobertAnderson3 — Thu, 11 May 2023 15:15:15 GMT

@TaylorSchyrbiak Did you ever manage getting it to update the specific row instead of just creating a new entry? This is something I would love to be able to set up I'm just not sure how to go about it.

Thanks!

Re: Survey123 submission that is resent from inbox or sent folder in the ios app is not triggering microsoft flow

TaylorSchyrbiak — Thu, 11 May 2023 15:33:18 GMT

@JoshuaFergusonPCW and @RobertAnderson3

For the survey where I have 1 record populate 1 row, I have the ObjectID as a column in my excel sheet and use this in my flow:

Where string(...) is equal to string(triggerOutputs()?['body/feature/result/objectId'])

and empty(...) is equal to empty(body('Filter_array'))

**Keep in mind, the "List rows present in a table" has a maximum records that it will search through** So this option is only really viable if you have a maximum of 5000 rows in your excel sheet.

I've also set something up where there are multiple lines populated in excel per survey entry, but that flow is a bit more complicated for updates.

Re: Survey123 submission that is resent from inbox or sent folder in the ios app is not triggering microsoft flow

RobertAnderson3 — Thu, 11 May 2023 18:52:22 GMT

Thank you so much for taking the time to reply to this! I'll have to take the time to try this out.