Dataverse Choices Columns in PowerApps

Since a few months I am working for a client who is trying to do miracles using Power Platform. I am fortunate enough that he picked me as a developer lead for this project.

We have been working with PowerApps, Power Automate and Dataverse and now I thought of sharing a few tips to ease your work if you are new to Power Automate + Dataverse as a combination.

I will be sharing a few more tips in my upcoming blogs but to get started, Lets take choices columns.

Unlike SharePoint or any other data source, Dataverse choices are different so basically I cannot go to my powerapp and check Department = "SharePoint" in dataverse. You will keep on getting error.

Dataverse assigns a ID to each choice that we add to a dataverse column. Something like below.

How do I know what is the ID of my choice?

You need to go to the table that you are using in Dataverse, click on column. From panel on right select "Edit Choices" and then Click on Eclipses besides choice and click on "View More". You can see the choice value in there.

How to check this in conditions?

If you are trying to apply any filter then condition would be something like 'Department' = 'Department'."SharePoint" rather than Department = "SharePoint".

Hope this helps.

Thanks,
Keyur Pandya

Comments

Business Data Connectivity

I came to a requirement wherein I was supposed to get data from an 3 rd party portal using API’s and then bring them to SharePoint server. The first approach that I finalized was just to make BDC solution that will get data from 3 rd party portal and will deploy it to SharePoint. How to Create BDC solution in SharePoint? I found below link that is having really great description about hot to create and deploy the BDC solution to SharePoint. http://www.c-sharpcorner.com/uploadfile/hung123/creating-business-data-connectivity-service-using-visual-studio-2010/ After creating an POC I came to know that BDC model cannot be deployed on Multi tenant farm. So what can be done next? After some amount of googling I came to know that we can create BDC solution using WCF services also. So I created a WCF service solution that acted as a wrapper that used to fetch data from the portal. We can them publish that service to IIS or Server and use the servic...

Identity client runtime library (IDCRL) did not get a response from the login server.

Recently I was doing some testing with a background PowerShell and encountered a weird error. “Identity client runtime library (IDCRL) did not get a response from the login server”. The error that you might encounter while working with PowerShell. This error is very misleading when it comes to identifying what could go wrong. After doing quite a good amount of research below are the probable causes for the error. Invalid Credentials MFA (Multi-Factor Authentication) Manage security defaults. Solutions Invalid Credentials Check if your credentials are wrong. Especially if you are using variables. MFA (Multi-Factor Authentication) Check if MFA is enabled on the account which you are using. These only affect you badly if you are developing PowerShell for a background Job. Go to Microsoft 365 admin center Users -> Active users -> Select the user -> Manage multifactor authentication -> Select the user -> Disable multi-factor authentication. M...

OneDrive Sharing Report: A Comprehensive Guide

OneDrive Sharing Report Managing and monitoring the sharing permissions of files stored in OneDrive can be a critical task for organizations. This guide provides a step-by-step walkthrough of how to create an Azure AD application with specific permissions, generate a client secret, and use a PowerShell script to retrieve and report the sharing permissions of OneDrive files. By following these steps, you will be able to audit and control file sharing across your organization, ensuring security and compliance. Step 1: Creating an Azure AD Application To get started, you'll need to create an Azure AD application that will allow you to interact with the Microsoft Graph API and retrieve information about users' OneDrive files and sharing settings. Specifically, you need to set the following permissions: Directory.Read.All Directory.ReadWrite.All Files.Read.All ...

Learning SharePoint

Search This Blog