web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Join two collections b...

Power Apps

Unanswered

Join two collections by backdating values of one of them

(0) Share

Report

Report

Posted on by PabloAxon

9

Good morning. I can't find the formula for the following.

I have a collection with several lines (Coll_Questions).

Another collection with other information, and it has only 1 line (Coll_request).

I want to join these 2 collections, but apply to each line of "Coll_Questions" the only line that has the collection "Coll_request".

I have tried several options with addColumns, using "Forall" etc... and the only progress is to create one more line in "Coll_Question".

I have also tried to create a 3rd Collection joining the 2 with no result.

Any idea?

Thanks

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

theapurva 970 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,
Create 3rd collection and as you have only one record in second collection, please use formula as below:

With({ChildRecord:First(Coll_request)},ClearCollect(MergedCollection,AddColumns(Coll_Questions,"Division",ChildRecord.Division,"Project",ChildRecord.Project)))

Join the conversation