Answered

Need Advice write code in power apps using filter or search or any other function

(0) Share

Report

Posted on by yashgoyal

Please advice me best practice to write code in power in following scenario..

How can write code in power apps using fliter or search functions
Select empid from empmaster where emplocation = varLocation and empid not in ( select empid from employeeOOO )

I tried following code .. It work fine when "NOT" is used.. However , my requirements is to use "NOT"

Filter(empmaster, emplocation = varLocation, Not(empid in employeeOOO.empid)) -- > Zero records
Filter(empmaster, emplocation = varLocation, (empid in employeeOOO.empid)) -- > Records display which matching in employeeOOO table

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @yashgoyal ,

What is your data source type and how many records are in each list ?
yashgoyal 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Greetings @WarrenBelz , Data source is Tables in Powerapps platform. SharePoint list
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@yashgoyal ,

Second question I asked - how many records do you have in each list?
yashgoyal 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Each table around 100 records each
Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @yashgoyal ,

I was trying to establish if Delegation was an issue and if the data source should handle the query - the answer to this is no and yes, so not much progress. Based in what you posted, I will try a variation, but it really is the same thing

With( { _Data: Filter( empmaster, emplocation = varLocation ), _Emp000: employeeOOO }, Filter( _Data, !(empid in _EmpOOO.empid) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps