web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Joining Collection

Power Apps

Unanswered

Joining Collection

(0) Share

Report

Report

Posted on by Joyel_Paul

12

I want to achieve basic SQL join to create a collection

Select t.EMPID, t.EmployeeName, M.Skills

from tabcollection t, Merge4collect M

where t.EMPID0=M.field_1

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

VishalJhaveri 1,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
ForAll(RenameColumns(Collection1,"User","User1","dept","dept1"),UpdateIf(Collection2,Title = User1,{dept:dept1}))

This should definitely work.
Taken from Solved: Join two collections - Power Platform Community (microsoft.com)
Please mark my answer as solution if it helps you.

Join the conversation