web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Is there a way to "que...

Power Apps

Answered

Is there a way to "query" all the data sources name in Power Apps and put them into a collection?

(0) Share

Report

Report

Posted on by medjasu

27

Hi Everyone,

My question is the subject itself.

Kind of like when you "show databases" in SQL and it would display all your databases.

My app is using multiple sharepoint lists. I want to be able to change the data source of my gallery by selecting a list from a dropdown then save that into a variable so that I won't have to manually change the data source name in the code itself.

Like for example, right now I am using

Filter('mySharepointList', ....)

and I want it to be

Filter(mySharepointVariableName, ...)

and when I select a list from the dropdown, I'll click a button to set that list into my variable like this

Set(mySharepointVariableName, dropdown.selected)

Is there a way to achieve this? Would appreciate any help. Thank you so much!

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @medjasu ,

It sounds like you want to use dynamic data sources in your app.

Here is a link for your reference.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Dynamically-changing-Gallery-source/m-p/116662

In addition, here is an idea that maybe you could vote on:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Dynamic-Data-Source/idi-p/178095#M7015

Best Regards,

Charlie Choi

Join the conversation