Power Platform Community Forum Thread Details

I am setting up a flow triggered by a new survey submitted to Survey123, which then splits into parallel flow branches which each add a row to separate sheets in an online Excel document. The multiple sheets are to have the Excel set up essentally in the same way as exported Survey123 data, so where there are repeats, each repeat section is in a new sheet.

I found this thread which gives some information but I've not been able to successfully figure out how to apply to my own data. Solved: How do you pass Survey123 repeat records to Excel ... - Esri Community

I'd really appreciate assistance with exact steps (with images if possible!) for setting up the flow in this sort of situation.

For context, the variables that I want to pull from repeats are:

Each repeat's objectID and globalID
1 item from the main survey NOT from within the repeats
Each repeat's ParentGlobalID (*note on another issue with this below)
Repeat-specific items in these forms: text, integer, multiple select, single select, date

*ParentGlobalID issue: in exported data from Survey123 survey with repeats, within repeats there is a ParentGlobalID field to link repeats to the overall survey submission. However, when I am trying to select the relevant dynamic content, there is no option for ParentGlobalID. I'm therefore not sure how I can make sure that the repeat data can clearly be matched to their parent submission.

I will have some nested repeats at some point, but I think that's a problem for another day!

Categories:

Building flows