12-08-2021 07:15 AM - last edited 12-08-2021 07:18 AM
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 |
Text | No | NA |
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 |
Import App zip file in Power Apps.
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.
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 |
Import Survey Template excel file to OneDrive
Import App zip file in Power Apps.
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 Dorrani, MVP
YouTube
Twitter
watch?v=wQqetH2QLyk