Power Automate - How to extract values from Microsoft Forms Multiple Choice Responses?
HTML-код
- Опубликовано: 22 июн 2023
- This video explains how to extract MS Forms multiple choice responses values.
Power Automate Community Thread
powerusers.microsoft.com/t5/B...
Expressions I used
outputs('Compose_2')?[0]
outputs('Compose_2')?[1]
outputs('Compose_2')?[2]
outputs('Compose_2')?[3]
Hi, this is informative. I would like to ask you one doubt. I have a form input it is a string( selecting class from the drop down list eg 1 to 12) but it is taking the power automate as a string so how to convert it to number as i am using condition here using Control if else . This is my code (int(body('Get_response_details')?['r7155e3b91d8e4955b38a64f28fa2d6a1']) less than or equal 2 but this is not converting to int
).
Fantastic video! Could you provide the link to your other video showing how to map the responses to a specific column?
Hi
Apologies for the late reply. I was away for a family emergency. Which video link are you after? Please let me know.
Thanks
Very well explained. Is it possible to make a video of how we can get only one response from people outside the organisation? At the moment we can get unique responses for sending forms to people in the organisation. Thank you in advance. 😊
Hi
Apologies for the late reply. I was away for a family emergency.
Unfortunately its not possible to do this. Here is the explanation about it.
answers.microsoft.com/en-us/msoffice/forum/all/can-we-limit-form-responses-so-one-person-cannot/c03b492d-e8c0-4b23-a23b-03034da03e2e#:~:text=If%20you%20go%20to%20the,with%20the%20link%20can%20respond%E2%80%9D.
Best channel for Power Automate, your knowledge sharing helped me to create many flows. I have a small usecase, we have to add users to the Azure AD groups when user submit microsoft forms with user email and AD group name. But unfortunately i am not able to get "group id " details with "get group" action with group name. Could you please suggest a solution to retrive the group id detials
Hi
Apologies for the late reply. I was away for a family emergency. I need to look into this. I will let you know soon.
Thanks
Very helpful video, thank you. Can this be done with a text field response instead of multi-choice? For example, text field response is: 'aaa bbbb 222 33 cccddd'. Can that be extracted and separated?
Thanks for you comment and question.
Yes you can. Use the below expression
Add a compose and use the below expression
split('aaa bbb 222 333 cccddd', ' ')
Then to iterate the array add an apply to each and inside add another Compose action step, add expression item()
This will get each values from the array.
Thanks
@abm4975 thanks for your quick reply! I have tried this and it looks good. After testing I can see that within the apply to each there are 5 results (aaa, bbbbb, etc). From here, how can I use/reference each separate result of the compose that's inside the apply to each so that I can either populate an html table or excel cell, etc? Would I need to initialize a variable before the apply to each control or is there a different way? Thank you!
Hi
If you have fixed length and spaces then you can retrieve using the split()?[0] index. Also use the first() and last() expression to get the first and the last values. Another way is to declare variables and store it.
This is impractical for me as I have 9 options in my multiple choice
Could you please explain more?
Thanks
@@abm4975 we have the same issue. I have 20 multiple selection on MS Forms. I think that is what he meant by it.
Compose has no such options. Seems to be outdated.
Hi
Apologies for the late reply. I was away for a family emergency. If you need any further help in this please let me know.
Thanks
Worked perfectly for me.- Are you in New Designer mode?
😬 "Promosm"