web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Combining Collections ...

Power Apps

Answered

Combining Collections conditionally URGENT!!!

(0) Share

Report

Report

Posted on by vish3027

438

Hello All,

I have 2 collections as below:

Collection1 : App1,App2,App3,App4,App5,App6,App7,App8,App10,App11 - these are columns , will have one row only

Collection2 : App9,App10,App11 -these are columns, will have one row only

Here App10 and App11 common columns

what i want is 3rd collection with single row based on below:

Collection3 : App1,App2,App3,App4,App5,App6,App7,App8,App9,App10,App11

but for App10 and App11 condition is

If (App10 is blank in Collection1, take app10 values from Collection2, else Take app10 value from collection1)

If (App11 is blank in Collection1, take app11 values from Collection2, else Take app11 value from collection1)

Resulted collection will have one row only.

How i can achieve it.

@RandyHayes please help

Thanks in Advance

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
@vish3027

This should give you the result that you're after.

AddColumns( DropColumns(Collection1, "App10", "App11"), "App9", First(Collection2).App9, "App10", Coalesce(First(Collection1).App10,First(Collection2).App10), "App11", Coalesce(First(Collection1).App11,First(Collection2).App11) )

Join the conversation