Answered

Power Apps: Filter on Dropdown list results based on value in another list

(0) Share

Report

Posted on by delisa024

I keep getting a delegation Warning error on HasStock ="Yes", this is a calculated field in my SharePoint list. How can I rewrite this function to address that delegation warning?

This function is used to filter a dropdown list based on the values returned in another once the criteria of HasStock is met. The first result is based on a comma separated email list.

Filter(
Split(
LookUp(
'Matrix',
_myProfile.Mail = Email,
ReportingLine
),
","
), Result exactin Filter(SM, HasStock = "Yes").EmpEmail
)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

TheRobRush 11,128 Moderator on at

Like (0)

Report

You cannot delegate based on a calculated column, I would recommend doing the calculation it's doing in your filter on powerapps side instead.

Was this reply helpful? Yes No
delisa024 7 on at

Like (0)

Report

Completing the calculation in the filter on powerapps gives the error
Result exactin Filter(SM, Issued<=Cards).EmpEmail

On sharepoint Cards and Issued are both number columns

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

what sort of column is EmpEmail & have you tried your split in a label to make sure the result it is giving you is the correct string youd like to search for?

Was this reply helpful? Yes No
delisa024 7 on at

Like (0)

Report

It returns email & Yes, the function in the original post gives me the correct result. Just wanted to know how to remove the delegation warning. as of now the function works.

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (1)

Report

You can't remove the delegation warning, without removing the calculated column from the equation. If you will never have your list go over the delegation limit you dont have to worry abaout it as your users cant see it, only appears in edit mode

Was this reply helpful? Yes No