12-22-2022 09:50 AM
Hello everyone,
In this video, you will learn how to build Dynamic Forms in Power Apps.
We will create the controls of the Form dynamically using a Configuration Table coming from your data source of choice.
We will store the form results in JSON Format & leverage the MatchAll function to parse JSON in Power Apps (JSON to Collection). This offers a lot of flexibility in not only storing the data but also the form schema.
Video tutorial includes Dynamic Form examples with Excel & SharePoint.
Video covers the following:
✅ Build Dynamic PowerApps Forms
✅ Leverage Gallery to add form controls from configuration list
✅ Store results in JSON Format
✅ Reload JSON string in Power Apps as a Collection (Array) using MatchAll Power Fx function.
✅ Demos - Dynamic Surveys for Training & Open Enrollments.
✅ Dynamically load forms based on type selection.
⬇️ Download App Samples showcased in Video:
https://github.com/rdorrani/PowerApps/tree/master/DynamicForms
🔗 Joey's Blog
https://steelcutbytes.com/2021/12/06/easily-collect-array-data-in-powerapps-from-a-flow/
🔗 Power Apps Form Control Tutorial
https://www.youtube.com/watch?v=aVEaRpAlaTA
🔗 Power Apps Gallery Designs (Styling as Cards & more)
#PowerApps #FormControl #DynamicForms #Excel #SharePoint
Thanks,
Reza Dorrani, MVP
YouTube
Twitter
watch?v=wQqetH2QLyk
Hi Reza, thank you! How did you get the new input gallery to reset? For example, if you submit a result and are navigated to the home screen, then you try to enter a new record again the previous values are still shown in the input gallery.
Hi Reza, Thanks for the explanation and the workaround to get the dynamic form up and running. You hard-coded the field names to map them to the result capturing; is there a way to do it dynamically without knowing the question's (from the template, field name)?