How can I put data from a Forms form to a variable?

[fsalazarma]

Hello to the entire power automate community, 

I appreciate you tell me how I can put data into a variable from a Forms survey, I need to enter data such as completion date and other 55 fields from a survey to automate an approval process and have a Database for subsequent downloads. It is also necessary to create additional variables to manually enter data by the approvers. In some cases the fields are calculated with excel functions.

I ask the question because I don't know how to do it. 

Thank you very much for your help.

[Rahber · Accepted solution]

Hello,

You can use Microsoft Forms Trigger "When a new response is submitted"

As you can see that i can get all my variables of the Form in the Dynamic Content. After this Flow i can use Approvals Action to trigger and Approval and then save it into a database or excel sheet where ever you like.

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,

Rahber

[fsalazarma · Accepted solution]

Hi, thanks for your answer. I have anpther problem, i cant see the questions of survey in the dynamic content, when i use HTML to Text (preview). 

Thanks for your help.

[v-litu-msft]

Hi @fsalazarma,

That is the content limits. If you still want to get the dynamic content which not is HTML, you could add a compose action before the HTML to text action, put these dynamic content into the Compose action, then put the Output of compose into the HTML to text action:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.