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.
Hi, Is it possible to find out how many responses are selected so that when I add the outputs to my rows it does not create additional rows for outputs that have no value?
Not sure what you meant by additional rows for outputs that have no value? When user submits there must be some value. Hope you have some mandatory fields. If not add an IF condition to determine whether the response of each question is empty or not? Thanks
So essentially, I have extracted the values from my Microsoft forms multi-choice field. I have a currency multi-choice field that users can select multiple currencies; I want to add a new row if the outputs from my compose steps are not empty. Essentially, I only want to create a new row if the currency has been listed in compose outputs. If they are empty to ignore them. Is there a way to test for this based on your solution above?
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, 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 ).
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.
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
@@abm4975hi. One that shows how to extract general values, not just multiple choice.
What do you mean by general values? Please explain a bit more. Thanks
@@abm4975 general, meaning WHATEVER I decide to add.
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.
Hi, Is it possible to find out how many responses are selected so that when I add the outputs to my rows it does not create additional rows for outputs that have no value?
Not sure what you meant by additional rows for outputs that have no value? When user submits there must be some value. Hope you have some mandatory fields. If not add an IF condition to determine whether the response of each question is empty or not?
Thanks
So essentially, I have extracted the values from my Microsoft forms multi-choice field. I have a currency multi-choice field that users can select multiple currencies; I want to add a new row if the outputs from my compose steps are not empty. Essentially, I only want to create a new row if the currency has been listed in compose outputs. If they are empty to ignore them. Is there a way to test for this based on your solution above?
Yes check the compose output under the IF condition.
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
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
).
What error are you getting?
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?
I still use the old designer. New one still have few issues.
I agree with you. I can't find Compose either although I am using the most recent version of Power Auto
😬 "Promosm"