Filter Gallery data which not in another table

(0) Share

Report

Posted on by calvinck00

Hi, i have created 2 tables in dataverse

First Table is "Fixed Assets", Second Table is "Opname".

I want to display fixed assets data (from the first table) that did not in the second table.

Additional information is:

Table Fixed Assets coloumns:

Name, fixed assets number (primary)

Table Opname coloumns:

Fixed assets (lookup), ID_Opname (primary)

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@calvinck00 Try this (change column names as needed),

Filter('Fixed Assets', !('fixed assets number' in ShowColumns(Opname, "Fixed assets"))

Was this reply helpful? Yes No
calvinck00 43 on at

Like (0)

Report

It still doesnt work for me :(.

Here's my coloumn in Opname Table:

And here is my coloumns in Fixed Assets Table:

Was this reply helpful? Yes No
calvinck00 43 on at

Like (0)

Report

It still doesnt work for me :(.

Here's my coloumn in Opname Table:

And here is my coloumns in Fixed Assets Table:

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@calvinck00 "Fixed assets" must be within double quotes as I have shown you earlier.

Was this reply helpful? Yes No
calvinck00 43 on at

Like (0)

Report

It still did not work 😞
I dont know why, but is it because the "Fixed Assets" column in the Opname Table is a lookup field (not just a text column)?

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
@calvinck00 Lookups work a bit differently. Try this (replace cr000 as seen in your column),

With({x: 'Fixed Assets', y:Concat(ForAll(ShowColumns(Opnames, "cr000_Fixedassets"), ThisRecord.cr000_Fixedassets.'Fixed Assets Number'), ThisRecord.Value, "; ") }, Filter(x, !('Fixed Assets Number' in y)) )

Was this reply helpful? Yes No
calvinck00 43 on at

Like (0)

Report

Thanks its finally worked. Thank you for your help, i really appreciate it! 👍

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@calvinck00 Glad to help!

Was this reply helpful? Yes No
calvinck00 43 on at

Like (0)

Report

Hi, i have another question that i posted in this link:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Search-function-for-Lookup-Column/m-p/1328014

Here's the question:
I have created 3 tables in Dataverse.
First table is "Location". (columns: IDLocation, Name)
Second table is "Fixed Assets" that has lookup column to the first table (Location Table). (columns: FixedAssetsNumber, Location)
Third table is "Opname" that has lookup column to the second table (Fixed Assets Table). (columns: IDOpname, Fixed Assets)

How can i use search function if i want to filter a gallery that use Opname Table as the datasource by value of TextInput1 that contains Location Name?

Thankyou! @CNT

Was this reply helpful? Yes No