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?
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,
User | Count |
---|---|
212 | |
94 | |
85 | |
49 | |
38 |
User | Count |
---|---|
271 | |
103 | |
102 | |
60 | |
59 |