Nested Repeats in Microsoft Power Automate, Survey123 Connect

Question

Hello ESRI Community!

Does anyone know how to deal with nested repeats in Microsoft Power Automate?

Here was my process:

1)  I coded a survey in Survey123 Connect (version 3.19.104.0) (see XLSForm below).

2)  I used the "When a survey123 response is submitted" flow trigger in Microsoft Power Automate.

3)  I used the "Add a Row" function to send data from my survey to an online Excel table. (see photo of flow below).

The survey has two levels of repeat ("plant" within "species_group_repeat"). When I tried to create a flow with the nested repeat, it created three "for each" loops (photo below). In the spreadsheet the data is mostly there but each response is entered multiple times. I've successfully done the above process with one repeat, but never with nested repeats. Does anyone know how to fix this?

Thank you in advance for any insight!

XLSForm

MPA Flow

abureaux · Answer

Thanks. I'll toss it in and have a quick look.

And just to be clear, swapping out of (or into) AI mode won't necessarily fix (or break) anything, it's just that the "normal" mode (aka, not the AI mode) can give you a more clear and intuitive picture of what is actually going on.

Sammy_SalmonNSEA · Answer

Hi @abureaux, thank you for your response!

I'll try switching out of AI mode, hopefully that will solve the issue. I've attached the XLSForm.

Vegetatation_Monitoring_XLSForm.xlsx

abureaux · Answer

Two questions. 1) Have you swapped out of AI mode to see what is actually being referenced in the For Each? You can do that clicking the ellipses (...) in the top right. (Personally, I really don't like that AI assistant. It can make simple tasks difficult), and 2) Can you upload the XLSX? I'm actually not sure off-hand why you have three For Each.