cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Applty to each dynamic content not available

Hello all,

I'm trying to connect a MS Form to Power BI dataset as presented in the below thread but I just can't figure out why I don't have a Dynamic Content option for Apply to each Control.

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/From-Forms-to-PowerBI-and-the-glue...

See attached what I meanflow.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
rimatos
Community Support
Community Support

HI @Anonymous ,

 

This is true, it seems there was a design change recently for the output of this trigger. Essentially the trigger is supposed to split entities so that a single entity will be processed in a distinct run. Therefore, the dynamic value is unable to be put into the Apply to each block, because a single entity is processed in a single run.

 

However, if you still want to use the previous output as an array, you can go to the trigger settings and Turn off ‘Split on’ option:

 

Then you can find this value in For each loop:

 
 

image.png

 

Hope this helps you have a better understanding of the reasoning behind this 🙂


Regards,

Ricardo

View solution in original post

7 REPLIES 7
manuelstgomes
Community Champion
Community Champion

Hi @Anonymous 

 

For that, you need an extra step to get the values from that reply. You need to do something like this:

2020-02-11 13_31_25-Window.png

 

Since each response triggers Flow, you don't need the For Each.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

 

 

Anonymous
Not applicable

Hello @manuelstgomes ,

 

I tried that, still no dynamic content. The Get reponse details does bring List of response dynamic content... 

 

Hi @Anonymous 

 

And I right to understand that your "Get response details" come back empty. But your Flow triggers when there's a new reply correct?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

rimatos
Community Support
Community Support

Hi @Anonymous ,

 

Sorry to interrupt your discussion. 🙂

 

 

So I just reproduced this in my environment and I was not able to find any Dynamic content either when using Apply to Each.

 

As a workaround, you can create a Template that uses Microsoft Forms, and copy the Dynamic content from there into your Flow:

 

image.png

 

image.png

 

 

Additionally, my suggestion here would be to open a Service Request with Microsoft, so we can further investigate this issue, and you can keep track of the situation.

 

 

Hope this helps!

 

Regards,

Ricardo

Just to chip in here for clarification: when you have a trigger of When a new response is submitted you must also after that have a Get response details action. And in that you have List of Response notifications Response Id which is selected from the dynamic content box. You can then follow that with the rest of your flow actions.

getResponseDetails3.png

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks. 

Anonymous
Not applicable

Hello all,

 

You are both right... but I found something even easier...

it looks like you don't even need apply to each at all anymore in this scenario.

see below how my finalised flow looks like image 1.png

rimatos
Community Support
Community Support

HI @Anonymous ,

 

This is true, it seems there was a design change recently for the output of this trigger. Essentially the trigger is supposed to split entities so that a single entity will be processed in a distinct run. Therefore, the dynamic value is unable to be put into the Apply to each block, because a single entity is processed in a single run.

 

However, if you still want to use the previous output as an array, you can go to the trigger settings and Turn off ‘Split on’ option:

 

Then you can find this value in For each loop:

 
 

image.png

 

Hope this helps you have a better understanding of the reasoning behind this 🙂


Regards,

Ricardo

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,122)