Unanswered

Performing Inner Join on Two Collections

(0) Share

Report

Posted on by Community Power Pla...

Hello all, I am currently following along to Power Apps - Joining Collections - SQL (Inner) Join - YouTube in order to perform an inner join on two collections I have in my PowerApp.

The two collections I am attempting to perform this on are the resourcesColl collection and the orderIds collection. In the resourcesColl collection, there is an "Id" column which matches/maps to the "WorkCenterID" column in the orderIds collection.

Here is my formula/code:

I am getting two errors:

1) The function 'Ungroup' has some invalid arguments

2) A column named 'CreatedBy' already exists (I am pretty sure this one is just being thrown because of the 1st error. I am not actually creating a column called 'CreatedBy' in this code)

Where am I going wrong?

Let me know if you need any further information.

Regards,

Zachary

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (1)

Report
Hi @Anonymous ,

I assume there are two tables:

ClearCollect(resourcesColl,{Id:"1",Column1:"1"},{Id:"2",Column1:"2"}); ClearCollect(orderIds,{WorkCenterID:"2",Column2:"1"},{WorkCenterID:"3",Column2:"2"});

You could use this formula to do the inner join:

ClearCollect(nameWithPoID, ForAll( Filter(resourcesColl,Id in orderIds.WorkCenterID) As TableA, Patch(LookUp(resourcesColl,Id=TableA.Id),LookUp(orderIds,WorkCenterID=TableA.Id)) ) )

Best Regards,
Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Great, that creates a new collection but only populates the "Id" and "WorkCenterID" columns in the nameWithPoID collection. How would I get this to populate two more columns in the collection? The column names I also wish populated are "Name" from resourcesColl and "ProcessOrderID" from orderIds collection

Was this reply helpful? Yes No
akshaykhanna199 2 on at

Like (0)

Report

This does not work at all. It generates wrong results and also does not exceed the rows in the left table

Was this reply helpful? Yes No