Power Platform Community Forum Thread Details

Hi Everyone,

Good day!

I have a gallery getting direct data from SharePoint but I'm using switch in items gallery to change data source.

However, it doesn't get all columns from that specific data source.

e.g. Datasource 1 has field1-field14, However it only returns field1-7

/** code in gallery items based on dropdown selected value **/

Switch(Dropdown.Selected.Value, 1, Datasource1, 2, Datasource2)

any suggestions on this?

Thank you for your response

Categories:

General Questions

Mobile App

Hi @Houji,

Your issue is that Power Apps will not accept (properly anyway) the possibility of two different data sources in a Table control (gallery, drop-down etc) Items. It is a bit frustrating that it does not return an error, however my experience is that it rarely returns the expected output. You may have to rethink your model and have two galleries, one visible on each of the possible drop-down choices.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee