Conditionnal datasource for a gallery

(0) Share

Report

Posted on by JD-19081230-0

Hello

I'm Julien, new to both this forum, and power Apps.

I'm currently building my first app and my question is the following:

Is there a way to make some kind of "conditionnal datasource" (Sharepoint list in my case) for a gallery?

What I would like is to select on the welcome screen on which project the user is working (each project being associated to a dedicated Sharepoint list to keep reasonnable the size of each list), and to have all the galleries of all the other screens linked to the specific list of the selected project.

I hope my explanations are understandable!

Thank you very much for your help.

Julien

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

markinwaukesha 96 on at

Like
a
(0)

Report
Copy link

Link copied!

I like using collections and based on what datasource you want to use, you can have conditional logic and populate that collection and use it for items on the gallery.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Julien_Delorme,

Do you want to select a project name and navigate users to task screen inlucding a special list gallery?

If so, you need to try as below.

1). Populate the dropdown control with different project name like

["Project1","Project2","Project3"]

2). Try to add a navigate button and set its OnSelect property as

If(dd_project.Selected.Value="Project1",Navigate(ScreenProject1), dd_project.Selected.Value="Project2",Navigate(ScreenProject2), dd_project.Selected.Value="Project3",Navigate(ScreenProject3) )

Was this reply helpful? Yes No
JD-19081230-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Qi and Markinwaukesha,

Thanks for you answers
In fact what I would like is to avoid to have to add a new screen to the app everytime we start a project with a new customer (roughly every 3 months).
What i imagine is:
1 list with the projects names, allowing the selection of the project with a dropdown on the welcome screen
1 list per projects with all data specific to this project
1 single screen displaying with a gallery the data of the project selected on the welcome screen
So the question is really: can one single gallery, on one single screen, display data from different lists according a condition defined somewhere else? (the condition being the list associated to the selected project on the welcome screen).

Hope it's more clear now.
Thanks for your help
Julien

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Julien_Delorme,

Not sure how you configure other lists with project name, I think I have mentioned the solution in my previous reply, you need to hard code this.

The solution is just like the way I mentioned, you just need to populate the dropdown with the column you store the project names, like

list_name.ProjectName

Then, write an if statement in your Gallery:

If(dd_project.Selected.Value="Project1",list_Project1, dd_project.Selected.Value="Project2",list_Project2, dd_project.Selected.Value="Project3",list_Project3 )

Was this reply helpful? Yes No
JD-19081230-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Thanks for your answer.
The thing is, with that approach, i will have to modify the IF() formula everytime a new project is starting since i don't know the project name in advance: this is what i wanted to avoid.

Any other idea to avoid it?

Thank you

Julien

Was this reply helpful? Yes No