Power Platform Community Forum Thread Details

Setting Variables

I have a Choice column in a Dataverse table.

The column has 4 different options:
Active
On Hold
Complete
Unresponsive

In PowerApps, In the OnSelect property of a button, I want the below YAML

Set(
varMOLDVStatusFL,
LookUp(
Choices('Master Ops List DVTS'.'APPLICATION STATUS'),
Value = "Active"
)
);
Navigate(MOLDVTableScreen, ScreenTransition.Fade);

The problem is that PowerApps says

Incompatible types for comparison. These types can't be compared: OptionSetValue, Text.

I've tried using

Set(
varMOLDVStatusFL,
LookUp(
Choices([@'Master Ops List DVTS'].'APPLICATION STATUS'),
@Value = "Active"
)
);
Navigate(MOLDVTableScreen, ScreenTransition.Fade);

and tried

Set(
varMOLDVStatusFL,
LookUp(
Choices([@'Master Ops List DVTS'].[APPLICATION STATUS]),
Value = "Active"
)
);
Navigate(MOLDVTableScreen, ScreenTransition.Fade);

Set(
varMOLDVStatusFL,
LookUp(
Choices('Master Ops List DVTS'.'APPLICATION STATUS'),
Value(Value) = "Active"
)
);
Navigate(MOLDVTableScreen, ScreenTransition.Fade);

Different warnings.

I want to be able to call this variable in the Items property of a table on another screen.

Why is this happening?
What else can I do?

Please help! 😣

Categories:

Power Apps component framework

Application Lifecycle Management (ALM)

Power Platform Build Tools

Quick Links