Thanks Daniel. Next up handling those multichoice questions from a form and mapping into a list. Tricky and a bit more advanced but something people's will run into very quickly.
I could tell you a couple of options on that. 1. Is the way I got from Reza. Put them in a choice multiple select option. Which is ok, 2. If you need need the answers put them separately in the Sp list. So give each one a field in the list. Make compose actions in the flow with if contains expressions. Looking for the answer text from the form answer. Then use the output of those steps to populate the fields on the create item action. At least that is how I worked around it. The advantage of that is filtering and sorting of the data in the list.
Thank you. Do you know if it is possible to embed the MS Form in a canvas Power App? I have a requirement that the user not leave the app to complete a form entry. I could create a form in power app of course, but the MS Form looks so good and easy and has good functionality. Thanks again.
Hi Hassan, I haven't done a step-by-step video on building this form. I referred to this form alot in my video on Microsoft Forms sections and here is the link ua-cam.com/video/ZGAZJAuF-FU/v-deo.html
Hey Daniel Thanks for this tutorial you mentioned in the beginning of the video that there is a tutorial on how you developed the form itself. Can you share that?
Daniel, is it possible to have a Power apps form connect to a large SP custom list and bring in fields that are populated to be used as part of this new form? The caveat is that this large SP list already has an InfoPath form with views currently on it. Instead of creating yet another InfoPath view, could the next view of the form be done in Power Apps?
Hi Marie, Yes, it is possible to switch between the existing InfoPath form and the customized Power Apps form. For your SP list, go to settings>Form settings.
What if you lose connection to your source before you are completed updating the existing information? Where will the updated information get saved? Thanks 🙏🏿
If you haven't done a submit or patch then you will lose all that information. If your users are in the situation where they might lose internet connection then consider using the SaveData and LoadData functions. These will save the data on your local device. Here's the link docs.microsoft.com/en-us/power-platform/power-fx/reference/function-savedata-loaddata
Thanks Daniel, great video. how are you managing the no of characters in the form? And to write it in a single line of textcolumn in Sharepoint? Please advise?
Hi Neelesh, Yes, you can out-of-box using Microsoft Forms. In Power Apps you can use the Rand function. Here's an example powerusers.microsoft.com/t5/Building-Power-Apps/getting-a-random-item-set-from-a-collection/td-p/120048
very good, congrats, excelent video, happy day,
Thank you! Cheers!
Thanks Daniel.
Next up handling those multichoice questions from a form and mapping into a list.
Tricky and a bit more advanced but something people's will run into very quickly.
Great suggestion!
I could tell you a couple of options on that.
1. Is the way I got from Reza. Put them in a choice multiple select option. Which is ok,
2. If you need need the answers put them separately in the Sp list.
So give each one a field in the list. Make compose actions in the flow with if contains expressions. Looking for the answer text from the form answer. Then use the output of those steps to populate the fields on the create item action. At least that is how I worked around it.
The advantage of that is filtering and sorting of the data in the list.
Awesome. Thanks for the great lesson.
Glad you liked it!
Thank you very much. Excellent video and greatly explained.
Glad you enjoyed it!
Thank you for the lessons 🙌🏼
My pleasure!
Thanks Daniel Amazing video! like!
Glad you liked it!
Thank you. Do you know if it is possible to embed the MS Form in a canvas Power App? I have a requirement that the user not leave the app to complete a form entry. I could create a form in power app of course, but the MS Form looks so good and easy and has good functionality. Thanks again.
Hi Defiant3D,
I have tried this yet, but you can use the HTML control and embed the Microsoft Form in there.
Hello Daniel. Which video do you build the initial power app? I don't see the previous video you mention. Thank you for your help.
Hey John,
It's in the Microsoft Forms vs Microsoft Power Apps video ua-cam.com/video/scaNDRXhFvo/v-deo.html
Good Stuff, Daniel!
Thanks for compliment.
Is there a video where you have talked step by steps to create the app
Thanks Daniel
Your welcome!
Could you pls post the link for the UA-cam video how you created this form?
Hi Hassan,
I haven't done a step-by-step video on building this form. I referred to this form alot in my video on Microsoft Forms sections and here is the link ua-cam.com/video/ZGAZJAuF-FU/v-deo.html
Hey Daniel Thanks for this tutorial you mentioned in the beginning of the video that there is a tutorial on how you developed the form itself. Can you share that?
Hi Maria,
Here's my playlist of all my Microsoft Forms videos ua-cam.com/play/PLdvjDcj8jpwm095LaEtD9exUq0NUABOjo.html
Thank you Daniel. Are there any special considerations with SQL?
Your welcome Ziad.
Nothing special for SQL. As like all data connections, verify user permissions.
Daniel, is it possible to have a Power apps form connect to a large SP custom list and bring in fields that are populated to be used as part of this new form? The caveat is that this large SP list already has an InfoPath form with views currently on it. Instead of creating yet another InfoPath view, could the next view of the form be done in Power Apps?
Hi Marie,
Yes, it is possible to switch between the existing InfoPath form and the customized Power Apps form. For your SP list, go to settings>Form settings.
@@DanielChristian19 I can't switch the existing forms out of InfoPath yet as those are in use. This would be new forms.
What if you lose connection to your source before you are completed updating the existing information? Where will the updated information get saved? Thanks 🙏🏿
If you haven't done a submit or patch then you will lose all that information. If your users are in the situation where they might lose internet connection then consider using the SaveData and LoadData functions. These will save the data on your local device. Here's the link docs.microsoft.com/en-us/power-platform/power-fx/reference/function-savedata-loaddata
Thanks Daniel, great video. how are you managing the no of characters in the form? And to write it in a single line of textcolumn in Sharepoint? Please advise?
Can I randomise the questions on the level of difficulty from the question bank
Hi Neelesh,
Yes, you can out-of-box using Microsoft Forms. In Power Apps you can use the Rand function. Here's an example powerusers.microsoft.com/t5/Building-Power-Apps/getting-a-random-item-set-from-a-collection/td-p/120048