Error in Filter data with using collection in Dataverse

(0) Share

Report

Posted on by Jawaharprem

249

Hi Team,

i using filter in collection, in dataverse there is choice column in that users select "Assigned" that "assigned" data should not display in the screen, so i worked with some codes but getting error's in .Value and .Selected pls help on same.

error shown in "= & <>"
ClearCollect(colGridData, Filter(CMD_NA_Trackers, Assign_To_Person = Text(assigntoper.Selected.Value <>"Assigned")))

Error shown in Text & .Selected.Value

ClearCollect(colGridData, Filter(CMD_NA_Trackers, Text(Assign_To_Person.Selected.Value) <> "Assigned"))

Error shown in "<>"

ClearCollect(colGridData, First(CMD_NA_Trackers).Assign_To_Person <> "Assigned")

Thanks

Jawahar Prem

Categories:

Dataflows

Microsoft Dataverse

I have the same question (0)

All responses (5)

Answers (0)

Fardy_MADI_2 332 Super User 2024 Season 1 on at

Like (1)

Report

Error in Filter data with using collection in Dataverse

Hi,

If you are using a choice column in Dataverse, you have created the possible options in synchronization (or not) with a global choice as shown in my screenshot below.

If you selected Yes then it's a global choice, you need to use this formula YourChoiceName.Assigned

If it's a local choice then use this 'YourColumName (YourTableName)'.Assigned

Was this reply helpful? Yes No
Jawaharprem 249 on at

Like (0)

Report

Error in Filter data with using collection in Dataverse

Hi Fardy, thanks for your time,

still getting errors

ClearCollect(colGridData, Filter(CMD_NA_Trackers, Assign_To_Person."Assigned"))

Was this reply helpful? Yes No
Jawaharprem 249 on at

Like (0)

Report

Error in Filter data with using collection in Dataverse

Hi,

"ClearCollect(colGridData, Filter(CMD_NA_Trackers, Text(Assign_To_Person) <> "Assigned"))"

the above code works perfect, but getting some delegation warnings.

Delegation warning. The "Text" part of this formula might not work correctly on large data sets.
Delegation warning. The "Filter" part of this formula might not work correctly on large data sets.

Was this reply helpful? Yes No
Mark Nanneman 989 Super User 2025 Season 2 on at

Like (1)

Report

Error in Filter data with using collection in Dataverse

@Fardy_MADI was saying you need to reference the choices when filtering. You shouldn't convert it to text or anything like that.

The correct filter would look something like this, where "Assigned_To_Choices" is the name of your choice option set for "Assigned_To_Person"

Filter('Choice Column Demos', Assigned_To_Person <> Assigned_To_Choices.Assigned)

Was this reply helpful? Yes No
Suggested answer

Inogic 1,122 Super User 2025 Season 2 on at

Like (0)

Report

Error in Filter data with using collection in Dataverse

Hi,

If your Assign_To_Person field in Dataverse is a choice column and stores numerical values (e.g., 1 for "Assigned," 2 for "Not Assigned"), the filter should target these underlying numerical values instead of the displayed text labels.

ClearCollect(colGridData, Filter(CMD_NA_Trackers, Assign_To_Person.Value <> 1))

If the numerical value approach doesn’t work, then use below formula

ClearCollect(colGridData, Filter(CMD_NA_Trackers, Text(Assign_To_Person) <> "Assigned"))

I hope one of these solutions will address the issue.

Hope this helps.

Thanks!

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

Was this reply helpful? Yes No