Answered

Create Power App from one SharePoint list with 7 views

(0) Share

Report

Posted on by CallMeT

I am fairly new to Power Apps and I need help asap. I want to create an app from a SharePoint list. In the SharePoint list I have 7 views for each form. Is there a way that when a button is selected, a form can now be visible? I want 7 buttons for each form. A different form view for each form. I have 7 different forms and when users submit a Request, I want it to be tracked on one SharePoint list. We want to be able to filter the requests by type. Basically, in Power Apps I want to create a separate button for each request. For example,

Request A

Request B

Request C

Request D

Request E

Request F

Request G

i.e. when a user selects Request A - View 1

if a user selects Request B - View 2

if a user selects Request C - View 3

and so on...

We want a different view on each Request. Then when the user selects Save - it will go to one SharePoint list. We want to be able to track all Requests on one list and filter by request type when needed. It will be similar to a help desk but in SharePoint. Thank you for any help you can provide.

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@CallMeT
Are you asking "How can I filter a gallery by pressing buttons"?

Put code like this in the OnSelect property of each button.

Set(varButtonPressed, "A")
Set(varButtonPressed, "B")
Set(varButtonPressed, "C")

Then use code like this in the Items property of the Gallery to display only records for the current button clicked.

Switch( varButtonPressed, "A", Filter(your_datasource_name, RequestType: "A"), "B", Filter(your_datasource_name, RequestType: "B"), "C", Filter(your_datasource_name, RequestType: "C"), "D", Filter(your_datasource_name, RequestType: "D"), "E", Filter(your_datasource_name, RequestType: "E"), "F", Filter(your_datasource_name, RequestType: "F"), "G", Filter(your_datasource_name, RequestType: "G") )

I've given a general solution since you only provided general information. If you need a more specific information please provide anything I would need to re-create the problem.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
CallMeT 7 on at

Like
a
(0)

Report
Copy link

Link copied!

No, I am asking how can I create buttons that will direct users to different forms? I want to create an app with 7 buttons. Each button will go to a different form OnSelect. Each button will be a separate request.
For example,
Request A - FormView1
Request B - FormView2
Request C - FormView3
Request D - FormView4
Request E - FormView5
Request F - FormView6
Request G - FormView7
i.e. when a user selects Request A, they will see FormView1 which will be a list of fields they need to complete, then click "Submit" button.
if a user selects Request B - FormView2
if a user selects Request C - FormView3
and so on...
We want a different view for each button. Then when the user selects "Submit" - it will go to one SharePoint list. We want to be able to track all Requests on one list. I want a field that autopopulates with the request type or should I can create a choice column and have the user select the request type? It will be similar to a help desk but in SharePoint.
StevenZhang 155 on at

Like
a
(0)

Report
Copy link

Link copied!

You may create 7 formviews with different type filtering.
then put 7 buttons to set the form display or hide.
StevenZhang 155 on at

Like
a
(0)

Report
Copy link

Link copied!

Or you may filter the type field.
Do you want to show different fields on different form or show different types?

Regards
Steven
Verified answer

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@CallMeT
You could create 7 different forms, each on a different screen, all having the same SharePoint list as their datasource.

Navigate('Screen FormView 1')
Navigate('Screen FormView 2')
Navigate('Screen FormView 3')

There's several questions within your last post but it's best to solve one-at-time creating a new post for each.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
CallMeT 7 on at

Like
a
(0)

Report
Copy link

Link copied!

I want to show different fields on different forms.
CallMeT 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for this! This is going in the right direction. @mdevaney