Over the past few months, I’ve had the privilege of leading a project where we are achieving remarkable results with the Power Platform. In this journey, I've gathered valuable insights, and today I want to share some tips that will help you if you are new to using Power Automate with Dataverse.
In this article, we’ll focus on working with Choices Columns in Dataverse, which differ significantly from other data sources like SharePoint.
Understanding Choices columns in Dataverse
Unlike SharePoint or other data sources, Dataverse Choices Columns operate differently. In Dataverse, each choice you add to a column is assigned a unique ID. This means you cannot directly use text values like "SharePoint" in your PowerApps conditions or filters. Instead, you will encounter errors if you attempt to use these values directly.
How to find the Choice ID?
To work with Choices Columns effectively, you need to know the ID associated with each choice. Here’s how you can find it:
- Go to the table you are using in Dataverse.
- Click on the column you are interested in.
- From the panel on the right, select "Edit Choices".
- Click on the ellipsis (three dots) beside the choice and select "View More".
- You will see the choice value and its associated ID.
Applying Conditions with Choices columns
When applying filters or conditions in Power Automate or PowerApps, you need to use the choice ID rather than the text value. For example,
'Department' = 'Department'."SharePoint"
Rather than using a condition like Department = "SharePoint", use the format above to ensure your filters and conditions work correctly.
![SharePoint]()
Hope these tips help you streamline your work with Choices Columns in Dataverse!
For more updates, connect with me on LinkedIn