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

All responses (9)

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Filter('Fixed Assets', !('fixed assets number' in ShowColumns(Opname, "Fixed assets"))
calvinck00 43 on at

Like
a
(0)

Report
Copy link

Link copied!

It still doesnt work for me :(.

Here's my coloumn in Opname Table:

And here is my coloumns in Fixed Assets Table:
calvinck00 43 on at

Like
a
(0)

Report
Copy link

Link copied!

It still doesnt work for me :(.

Here's my coloumn in Opname Table:

And here is my coloumns in Fixed Assets Table:
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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)?
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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)) )
calvinck00 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks its finally worked. Thank you for your help, i really appreciate it! 👍
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@calvinck00 Glad to help!
calvinck00 43 on at

Like
a
(0)

Report
Copy link

Link copied!

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