104
Hi, im a bit new to powerapps.
I have 3 lists called goals, opps and clients. There is a single gallery to search these 3 SharerPoint lists. I have had a bit of a look on how to do this and there is a suggestion to build a collection onstart in the powerapp for this to work. However I have tried this and it hasnt been successful. The page reference is here what im referring too. Does anyone have any tips for this to work? Also an example would be great.
Hi @daniellemaree85 ,
Does the goals, opps and clients List have same data structure?
Do you set up a relationship between your three SP Lists though fields?
Further, do you want to connect a single one Gallery to multiple SP Lists?
Currently, within PowerApps canvas app, a Gallery could only be connected to single one data source. If you want to connect one Gallery to multiple data sources, I afraid that there is no direct way to achieve your needs.
I assume that you have set up relationship between your three SP Lists through fields already, as an alternative solution, you could consider combine your multiple SP Lists into a single one collection based on the relationship field (e.g. LookUp field).
The user Moores35 has faced similar needs with you, please check my response within the following thread:
AddColumns function, ClearCollect function
If above solution is helpful in your scenario, please consider go ahead to click "Accept as Solution" to identify my reply as helpful.
Best regards,
Share
Report
All responses (
Answers (
