Unanswered

Course catalog registration

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am building an app where users can browse, view and register for classes. I want to have a different attendance list for each class.

So I have my catalog with all my classes in a gallery, then you select a class, and from there I want the user to fill out a form that is linked a specific list ( sharepoint preferably, but if there is another solution, I'll take it) based off the class that was selected.

If all the classes follow a template for their own empty sharepoint class roster list, is there a way to use one form on the app, that directs the information to different lists based off the selected class?

I tried to just put the link of the class roster on the list of classes but then users would either be able to edit/remove other attendees or they would be limited by their permissions.

The easy answer is to just put all registrants into one sharepoint list and filter that based on class but I feel like there is a way to better automate that so the different instructors wouldn't have to deal with irrelevant information. But at this point I am not even sure if it is possible in powerapps.

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about your scenario?

Do you want to connect a single one Edit form to different SP Lists? Do these SharePoint lists have same data structure?

If these SP Lists that you mentioned have same data structure (including Data type and Column Name), I think single one Edit form could achieve your needs.

On your side, please consider take a try with the following workaround:

Set the DataSource property of Edit form to following:

If( Gallery1.Selected.ClassName = "Class1", 'SP List 1', Gallery1.Selected.ClassName = "Class2", 'SP List 2', Gallery1.Selected.ClassName = "Class3", 'SP List 3', ... )

Set the OnSelect property of Gallery to following (click Gallery Item to navigate to Edit screen to fill out form):

Navigate(EditScreen);NewForm(EditForm1)

If these SP Lists that you mentioned do not have same data structure, I afraid that single one Edit form could not achieve your needs. As an alternative solution, you need to create one Edit form in separated screen within your app for each SP List. Then set the OnSelect property of Gallery to following:

If( Gallery1.Selected.ClassName = "Class1", Navigate(EditScreen1);NewForm(EditForm1), Gallery1.Selected.ClassName = "Class2", Navigate(EditScreen2);NewForm(EditForm2), Gallery1.Selected.ClassName = "Class3", Navigate(EditScreen3);NewForm(EditForm3), ... ... )

Please consider take a try with above solution, check if the issue is solved.

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
This was the exact solution I was looking for!!

"
I think single one Edit form could achieve your needs.
On your side, please consider take a try with the following workaround:
Set the DataSource property of Edit form to following:
If( Gallery1.Selected.ClassName = "Class1", 'SP List 1', Gallery1.Selected.ClassName = "Class2", 'SP List 2', Gallery1.Selected.ClassName = "Class3", 'SP List 3', ... )

Set the OnSelect property of Gallery to following (click Gallery Item to navigate to Edit screen to fill out form):
Navigate(EditScreen);NewForm(EditForm1)
"
Here was my formula that put into the DataSource of an EditForm
The only problem is my "Fields" list says there are not fields. I double checked that my lists were formatted exactly the same way with exactly the same column titles. But still notta
Here is my
.

Any suggestions?