I have created an MS Form that has similar questions based on the branching and answers to previous questions. This means that the Excel data from Forms ends up with multiple columns with the same name (EX: Entity, Entity2, Entity3). In building the flow in Power Automate, the Dynamic Content shows 3 options when I search dynamic content (EX: Entity, Entity, Entity) and does not have the identifier of 2 vs 3. This causes issue with selecting the correct responses inline with the form submission.
Is there a way to use the Expression formulas instead of the Dynamic Content search?
Is there a better way to pull this data? My Excel from MS Forms has 123 columns.
You could use the following expression to get a value from Forms:
where redd2289989892 is the identifier of your question in Forms.
How do we get this identifier? If we have a look at the output of the "Get response details" action we can get it through its values:
Hope it helps!
Whenever you execute your flow, you can inspect the 28-day run history, and see in details what's been going on inside the flow:
Hope it helps!
@fchopo It doesn't seem that the identifiers are in same order as the response questions. EX:
Column2: Start Time
Column3: Completion Time
"submitDate": "4/20/2021 1:42:34 PM",
"r6bb78f5ea7954a5898047c84065f7d2b": "John@test.com ",
Is there a different way to capture the identifiers? Is it pulling the identifiers in the order of the Form (in edit mode) without the branching?
Thank you for your help!
As I understand, it doesn't matter the order of the identifiers. I mean, you only need to identify the fields Id, and in the output of the "get response details" you should have all the output fields.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!