nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

TaylorSchyrbiak

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?

Najděte více příspěvků označených jako

Accepted answers

ZacharySutherby

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

All comments

ZacharySutherby

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

TaylorSchyrbiak

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

Sent from my iPhone

ZacharySutherby

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

JoshuaFergusonPCW

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.

RobertAnderson3

@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!

TaylorSchyrbiak

@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.

RobertAnderson3

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

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.