Working with Dataverse choice columns in a power app gallery filter

(0) Share

Report

Posted on by rkirk2k

282

I'm using the following code currently to display items in a gallery...

As you can see, I get a delegation warning on the "Text" part of the formula.

TicketStatus is a choice column in a Dataverse table. I've done this in SharePoint withOUT the "Text" function.

I've had great difficulty trying to work with the Dataverse choice columns. Any input, or learning resources that can help would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

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

Like (1)

Report

@rkirk2k , please try this instead:

TicketStatus <> [@TicketStatus].Completed

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

developerAJ 4,643 on at

Like (2)

Report

Global Choice : TicketStatus.Completed [here ticketstatus is globalchoice name example:choicecategories in below pic]
LocalChoice: 'TicketStatus (Tablename)'.Completed

the difference is that sharepoint choice column value is text but when it comes dataverse its an option set.
so in sharepoint it works without text but in dataverse either You need to use text or you need to get optionset value TicketStatus.Completed

Please click Accept as solution and Thumbs Up. 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.
@rkirk2k

Was this reply helpful? Yes No
developerAJ 4,643 on at

Like (0)

Report

Was this reply helpful? Yes No