Build Dynamic Forms in Power Apps

[et_pb_section fb_built=”1″ _builder_version=”4.7.4″ _module_preset=”default”][et_pb_row _builder_version=”4.7.4″ _module_preset=”default”][et_pb_column _builder_version=”4.7.4″ _module_preset=”default” type=”4_4″][et_pb_video src=”https://youtu.be/wQqetH2QLyk” _builder_version=”4.7.4″ _module_preset=”default” hover_enabled=”0″ sticky_enabled=”0″][/et_pb_video][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”4.7.4″ _module_preset=”default” custom_padding=”0px|||||” custom_margin=”-46px|||||”][et_pb_row _builder_version=”4.7.4″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.7.4″ _module_preset=”default”][et_pb_text _builder_version=”4.7.4″ _module_preset=”default” hover_enabled=”0″ sticky_enabled=”0″]

SETUP POWER APPS DYNAMIC FORM:

Step 1

Create a SP list with the following name: Form Template

Column Name Column Type Comments
Title Single line of Text This will be the default column that gets created in a SharePoint list
Column Type Single line of Text
Required Single line of Text
Choices Single line of Text

Add data as follows:

Title Column Type Required Choices
Name Text Yes NA
Age Number No NA
Enrolled Yes/No No NA
Enrolled Date Date Yes NA
Region Choice Yes North;South;East;West
Email Text No NA

Step 2

Create a SP list with the following name: Form Results

Column Name Column Type Comments
Title Single line of Text This will be the default column that gets created in a SharePoint list
Result Multiple line of Text
Age Number
Enrolled Single line of Text
Region Single line of Text

Step 3

Import App zip file in Power Apps.

Step 4

Edit the App.
Remove the data source connection to “Form Template”& “Form Results”
Add new data source connection & connect to your newly created SharePoint Lists Form Template & Form Results
Save the App & Close the App
Edit the App again and test.

SETUP POWER APPS DYNAMIC SURVEYS

Step 1

Create a SP list with the following name: Survey Results

Column Name Column Type Comments
Title Single line of Text This will be the default column that gets created in a SharePoint list
Survey Response Multiple lines of Text
Survey Type Single line of Text

Step 2

Import Survey Template excel file to OneDrive

Step 3

Import App zip file in Power Apps.

Step 4

Edit the App.
Fix connection for SharePoint or Excel Online if prompted.
Remove the data source connection to “Survey Results”
Add new data source connection & connect to your newly created SharePoint List Survey Results
Remove the data source connection to “TypeA” & “TypeB”
Add new data source connection for Excel Online (Business) & connect to your newly added Excel file in OneDrive for Business FormTemplate.xlsx
Choose Tables “TypeA” & “TypeB” & Connect.
Use unique column for TypeA – select Title & Connect.
Use unique column for TypeB – select PowerAppsId & Connect.

Save the App & Close the App
Edit the App again and test.

 

Thanks,

Reza

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built=”1″ fullwidth=”on” _builder_version=”4.7.4″ _module_preset=”default”][/et_pb_section]