[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]