web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Changing Data Sources

Power Apps

Unanswered

Changing Data Sources

(0) Share

Report

Report

Posted on by madlyons

4

My intent is to have data sources dependent on what part number I select. My question is if this is possible and if so, is there a limit to how many data sources I can upload?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You will have to add all the possible datasources to your app. Then say if you want to show a gallery of items based on the part number, you can have multiple galleries for each data source and then hide/show thembased on the part number.

Let me know if you have any questions.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @madlyons ,

Do you want to change the data source within your app dynamically based on some condition?

Based on the needs that you mentioned, I think the If function could achieve your needs. Please consider take a try with the following formula:

If( PartNumberDropdown.Selected.Value = "xxxx", "DataSource1", PartNumberDropdown.Selected.Value = "xxxx1", "DataSource2", ... ... )

In addition, there is a limit on the amount of the data sources you could upload into an app -- Don’t connect to more than 30 data sources from the same app. Please check the following article for more details:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/performance-tips#limit-data-connections

The more data sources you uploaded in your app, the more CPU resources, memory, and network bandwidth resource you would consume.

For your app's performance, please do not upload more than 30 data sources into your app.

Best regards,

Was this reply helpful? Yes No

Join the conversation