Unanswered

Compare Two Tables

(0) Share

Report

Posted on by mbandurski18

Hello,

I have collections with data. One column is lookup which contains multiple selections. How Can I add column to collection with title of selections lookup field?

Collections

ClearCollect(test,ShowColumns(DataSource,"title","cities");

ClearCollect(userscities,Filter(DataSource2,user = "abc@abc.pl");

My tried code

Filter(test, userscities.cites in cities[@Value])

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @mbandurski18,

Do you want to collect only value of the LookUp column?

Could you please tell me that if the Title is the column existing in another data source where your LookUp column retrieving values from?

If so, please check the formula as below:

ClearCollect(coll,AddColumns(DataSource,"lookup_value",Concat(LookUpField,Value,",")))//Note that this datasource is the one inlcuidng LookUp field

Was this reply helpful? Yes No
mbandurski18 6 on at

Like (0)

Report
Copy link

Link copied!

I'll explain it to you more. I have records in DataSource 1 and I need to filter out all the records that in the Cities column have values from another table called "UserBelongs" (it's a table because a user can belong to multiple cities).
I need to do this in Combox code
Filter (DataSource 1, <code>)

Was this reply helpful? Yes No
mbandurski18 6 on at

Like (0)

Report
Copy link

Link copied!

@v-qiaqi-msft I anwsered

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @mbandurski18，

You want to filter records in DataSource1 based on "abc@abc.pl" user, right?

Modify your filter as below:

Filter( DataSource1, CountRows( Filter( ForAll( Cities, If( Value in Filter( DataSource2, User = "abc@abc.pl" ). Title, {t: 1}, {t: 0} ) ), t = 1 ) )>0 )

Was this reply helpful? Yes No
mbandurski18 6 on at

Like (0)

Report
Copy link

Link copied!
You are awsome, that's works.

Could you explain me what mean this part of code?

{t: 1}, {t: 0}

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @mbandurski18,

Just a temporary variable used to define if the lookup up value exists in the Title column from DataSource2.

Was this reply helpful? Yes No