Filter SharePoint based on condition

(0) Share

Report

Posted on by dylandavis09

438

Screenshot 2023-12-11 at 3.33.10 PM.png

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (0)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @dylandavis09 ,

I think this is what you are after, but not entirely clear.

With( { _Sponsor: LookUp( 'Class of 20XX (Officers)', 'Head Sponsor' = User().FullName ) }, Sort( Filter( 'DHS Student Users', 'L-Grade' = _Sponsor.'L-Grade' ), 'Student Name' ) )

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

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

Where it is come from "_Sponsor:"?

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
@dylandavis09 ,

Assuming 'Head Sponsor' is a Person field. you may also have an issue if 'Student Name' is also one of these (requires .DisplayName after it). Also I assume 'L-Grade' is a Choice column.

With( { _Sponsor: LookUp( 'Class of 20XX (Officers)', 'Head Sponsor'.DisplayName = User().FullName ) }, Sort( Filter( 'DHS Student Users', 'L-Grade'.Value = _Sponsor.'L-Grade'.Value ), 'Student Name' ) )

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

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

Hi @WarrenBelz. Okay, the 'Head Sponsor' is a text field, not a person field. Additionally, 'L-Grade' is a choice column.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @dylandavis09 ,

So out of that, what have you tried using the code I provided ?

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

Let me show you screenshot. 🙂

But I'm wondering, where does the term '_Sponsor' come from?

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
@dylandavis09 ,

I was hoping you would work out what to change from my comments - it is simply about field types

With( { _Sponsor: LookUp( 'Class of 20XX (Officers)', 'Head Sponsor' = User().FullName ) }, Sort( Filter( 'DHS Student Users', 'L-Grade'.Value = _Sponsor.'L-Grade'.Value ), 'Student Name' ) )

_Sponsor is simply a Variable - you can call it whatever you want. I am assuming in the code above that 'L-Grade' is a single choice column in both lists and 'Head Sponsor' is a Text field matching the user's name.

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

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

Ok I got it! You correct that L-Grade is a single choice choice column, and Head Sponsor is a text field. It's still something error in red box. Otherwise, green box is worked. 🙂

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@dylandavis09 ,

There is somehting wrong with one of your references as the structure is correct. There is a line under 'DHS Student Users', so maybe that is not the correct name.

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

@WarrenBelz, I found the solution. I just added it to 'DHS Students Users' Now it's better, and no errors are displayed; we still have a warning message, though.

Was this reply helpful? Yes No