Skip to main content

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
Labels:

Comments

Post a Comment

Popular posts from this blog

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...
2 comments
Read more

Dataverse Multi Choice Columns in PowerApps

We have been working with PowerApps, PowerApps and Dataverse and now I thought of sharing a few tips to ease your work if you are new to PowerApps + Dataverse as a combination. I will be sharing a few more tips in my upcoming blogs but to get started, Let’s take Multi Choice Columns this time. Unlike SharePoint or any other data source, Dataverse Multi choice columns are different so basically, I cannot go to my PowerApp and directly print selected value in a label. So, this is how you can show multi choice values in label. You need to use concat that allows to concat multiple selection. PowerApps has concat function that takes. Concat function syntax :  Concat (  Table ,  Formula  ) In my case I am trying to render a multi choice column values into a vertical gallery webpart. I have added a label control to a vertical gallery and then added below code.   Concat(ThisItem.ColumnName,Value & "") Hope this helps, Thanks, Keyur
Post a Comment
Read more

SharePoint hosted apps with Angularjs

Wow.. I thought i won't be able to manage to write a blog this month. Hey guys today i am here with a something of that i have been planning since a long time. Some time back i tried to implement Angularjs with SharePoint. To be frank Angularjs is just awesome. You can have flawless feel while working with it. I don't know how will i manage to work with Angularjs in huge projects but i found it really really good to work with single page applications. Let's have a look to the classic definition of Angularjs that you find when you google for Angularjs. Angularjs "AngularJS is a structural framework for dynamic web apps. It lets you use HTML as your template language and lets you extend HTML's syntax to express your application's components clearly and succinctly. Angular's data binding and dependency injection eliminate much of the code you would otherwise have to write." SharePoint Apps SharePoint Apps, I personally found it more developer...
6 comments
Read more