Gallery collection - two data sources

(0) Share

Report

Posted on by Coopedup

355

Hi,

I have two separate SP lists and though they are used for the same function within my company they have slightly different formats (problem of two different processes now being combined).

I have a gallery that I'd like to display both sets of data, but using clearCollect(colName, 'SPList_1'); Collect(colName, 'SPList_2') it throws an error as some fields types are different (named the same but different formats, i.e. choices vs text).

Is there a way to have a gallery reference two different sources directly and not go via a combined collection?

Thanks

Neil

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Coopedup
Nope, you cannot do this directly. It must be a combined function. Your best strategy will be to make sure both tables have exactly the same columns and datatypes.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Coopedup 355 on at

Like
a
(0)

Report
Copy link

Link copied!

This is the answer I'd found myself...but just hoped there may be something I was missing. A little bit of thinking needed.
Thank you
berofeev 65 on at

Like
a
(0)

Report
Copy link

Link copied!

I was about to dive into a project where I was planning on using the clearcollect/collect method with intentionally different fields in each sp list, but also a set of fields that did overlap in name and data type.

I was planning on using ShowColumns or DropColumns https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-shaping

Do you think it would be possible to do this?