cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CallMeT
New Member

Create Power App from one SharePoint list with 7 views

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.

1 ACCEPTED SOLUTION

Accepted Solutions

@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."

View solution in original post

7 REPLIES 7
mdevaney
Super User
Super User

@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."

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. 

You may create 7 formviews with different type filtering.

then put 7 buttons to set the form display or hide.

Or you may filter the type field.

Do you want to show different fields on different form or show different types?

 

Regards

Steven

@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."

I want to show different fields on different forms.

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,257)