Unanswered

Filter with three logical tests

(0) Share

Report

Posted on by ilimeli Microsoft Employee

Hi all,

I am trying to print the rating of a solution based on the Solution Version and Solution Name selected. I have a table that includes columns for the Solution Version, Solution Name, and Solution Rating.

I am trying to do something like this

First(Sort(Filter('Solution Ratings', 'Rated By'=Office365Users.MyProfileV2().mail && Solution.Name = 'Solution Ratings'.'Solution Name' && Solution.'Solution Version' = 'Solution Ratings'.'Solution Version'),'Created On',Descending))

but I am receiving an error and delegation warning

My label inside my gallery looks like this

If(
Office365Users.MyProfileV2().mail in 'Solution Ratings'.'Rated By',
"Previous Rating: " & ThisItem.'Solution Rating',
"Submit your first rating for this solution"
)

Is there a way to print out the users previous ratings based on the Solution and Version selected in the previous screen?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @ilimeli ,

First() is not Delegable and your profile may also cause issues, so try this

With( {wMail:Office365Users.MyProfileV2().mail}, Sort( LookUp( 'Solution Ratings', 'Rated By'= wMail && 'Solution Name' = Solution.Name && 'Solution Version' = Solution.'Solution Version' ), 'Created On', Descending ) )

If you still get a warning, what type of field is Solution?

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
ilimeli Microsoft Employee on at

Like (0)

Report

Hi @WarrenBelz , Solution is a variable created for the gallery item selected in the previous screen.
I did get an error related to the sort function

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

Like (0)

Report

@ilimeli

What type of field is 'Created On' - if it is a date field, it should not error.

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

Like (0)

Report

HI @ilimeli ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No