web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Dataverse Table...

Power Apps

Answered

Filter Dataverse Table by Choices Column without Delegation Warning

(0) Share

Report

Report

Posted on by DasLukas112

In the Teams Power App, I'm using the User Dataverse Table and have added a new column with a datatype of choices to manage multiple roles for each user. Now, I'm trying to filter users by a specific role, and I want the results to display in a dropdown menu. My current formula, which is causing a delegation warning, is as follows:

Filter(Choices([@Tickets].Agent), Not(IsBlank(LookUp(Roles, 'Agent' in Value))))

Is there a way to filter users by a multi-choice column without triggering a delegation warning?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@DasLukas112 - not the answer you will be looking for, but the In function is delegable only with Single Line Text in Dataverse (although in the near-future Choice fields will be supported).

Was this reply helpful? Yes No
DasLukas112 on at

Like (0)

Report
Copy link

Link copied!

Thank you @Amik for your response. I had thought there was a workaround for this, but unfortunately, there doesn't seem to be one. Currently, it seems that no more than 500 users will be listed in the Dataverse table anyway, so there won't be much of a problem with delegation. It would have just been nice to have a cleanly designed app from the start.

Was this reply helpful? Yes No

Join the conversation