Unanswered

Items Function of Gallery For Datverse tabel as Dtasource

(1) Share

Report

Posted on by Danny_Dicaprio

HI Everyone,

I have a gallery in my PowerApps, Dataverse table as the DataSource

Filter(

    'Risk Lambard Lists',

    'Risk_ID '.'RISK ID' = VarBootomUpRiskID,

    'Control Type (Risk Lambard Lists)'.Detective = "Detective" && 'Presently In Place' = true

)

it is showing an error in the not equal Part <>

Control Type is a Choice column in my Dataverse Table, I want to filter the gallery based on the control type

if the control type Value is <> Detective and Presently in place is true, only those details should show in Gallery

But is showing an error Incompatible types for comparison. These types can't be compared: OptionSetValue (Control Type (Risk Lambard Lists)), Text.

I tried adding Value and text also , then aslo showing the errror

Could anypne please help me to fix this isssue

Categories:

Connecting to Data

Copilot

AI Builder

Using Apps Using Formulas

General Questions

Connectors

Dataflows

All responses (4)

Answers (0)

Danny_Dicaprio on at

Like (1)

Report
Re: Items Function of Gallery For Datverse tabel as Dtasource

Thanks for the continued support @anandm08

I fixed the issue the items Property , yes Control Type is a Choice column

since my datasource is dataverse tables , the choice values shows in a different way

Filter(
'Risk Lambard Lists',
'Bottumup Risk_ID '.'RISK ID' = VarBootomUpRiskID,
'Control Type' <> 'Control Type (Risk Lambard Lists)'.Detective && 'Presently In Place' = true
)
anandm08 1,936 Super User 2025 Season 1 on at

Like (2)

Report
Re: Items Function of Gallery For Datverse tabel as Dtasource

@Danny_Dicaprio what is this
'Control Type (Risk Lambard Lists)'
is it a column name with data type of choices?
Danny_Dicaprio on at

Like (1)

Report

Re: Items Function of Gallery For Datverse tabel as Dtasource

Hi thanks for the response @anandm08

Still Iam facing the same issue

it is showing Name isn't valid value isn't recognized
anandm08 1,936 Super User 2025 Season 1 on at

Like (2)

Report
Re: Items Function of Gallery For Datverse tabel as Dtasource

hi @Danny_Dicaprio ,
try this:

Filter( 'Risk Lambard Lists', 'Risk_ID '.'RISK ID' = VarBootomUpRiskID, 'Control Type (Risk Lambard Lists)'.Value <> {Value:"Detective"} && 'Presently In Place' = true )

try using this: <> {Value:"Detective"}