Answered

Operator Column in SharePoint List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I have operator column in SharePoint list which contains(<, >, != etc.). I want to compare my value using an operator from SharePoint list.

Like for example:

Amount Operator

10 <

20 >

//DataCardValue16.Text = 15

//Amount = 10

Filter(SP_List, DataCardValue16.Text > Amount ) // here I want to use dynamic operator

Is possible to use this scenario as i want to dynamically select the operator against value in SharePoint list?

Regards,

Ahmad.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,384 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

HI @Anonymous ,

The Short answer is no - you cannot refer to anything (controls, fields, operators) dynamically in Power Apps. You could do it with If() statements using each value and then the statement that applies to it.

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.

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

Like
a
(0)

Report
Copy link

Link copied!

Thanks WarrenBelz.

Solved my problem but I am facing a delegation issue in filter and I don't know how to get rid of this

here you can the code:
==========
Filter(
SP_List,
If(
operatorLabel.Text = ">" ,DataCardValue16.Text > Amount,
operatorLabel.Text = "<" ,DataCardValue16.Text < Amount,
operatorLabel.Text = "!=" ,DataCardValue16.Text <> Amount,
operatorLabel.Text = ">=" ,DataCardValue16.Text >= Amount,
operatorLabel.Text = "<=" ,DataCardValue16.Text <= Amount
)
=======
Regards
Ahmad.

Was this reply helpful? Yes No
WarrenBelz 156,384 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

One reason for the Delegation warning is the <> (does not equal) operator. Also I assume that the Amount is a numeric value, so try try this

With( {wValue:Value(DataCardValue16.Text)}, Filter( SP_List, Switch( operatorLabel.Text, ">", wValue > Amount, "<", wValue < Amount, "!=", Abs(wValue-Amount)>0, ">=", wValue >= Amount, "<=", wValue <= Amount ) ) )

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.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz actually <> is delegable for numeric, but I had to chime in because I LOVE the use of Abs for the not equal operation!!!

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

Like
a
(0)

Report
Copy link

Link copied!

Thanks again.

I am still getting a delegation problem in this code. Is it because i am using switch in filter ?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,384 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

No - Switch is nothing more than a "shorthand" If() statement. It seems two things - the conditional filter does not like Delegation and also not the Abs() - though I have used it before. The below is Delegable

With( {wValue: Value(DataCardValue16.Text)}, Switch( operatorLabel.Text, ">", Filter( SP_List, wValue > Amount ), "<", Filter( SP_List, wValue < Amount ), "!=", Filter( SP_List, wValue <> Amount ), ">=", Filter( SP_List, wValue >= Amount ), "<=", Filter( SP_List, wValue <= Amount ) ) )

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.

Was this reply helpful? Yes No