We have been working extensively with PowerApps and Dataverse, and I thought it would be helpful to share a few tips to ease your work if you are new to using PowerApps and Dataverse together.
I will be sharing more tips in my upcoming blogs, but to get started, let's focus on MultiChoice Columns this time.
Handling Multi-Choice Columns in Dataverse
Unlike SharePoint or other data sources, Dataverse Multi Choice Columns work differently. Essentially, you cannot directly print the selected value in a label within your PowerApp.
To display multi-choice values in a label, you need to use the Concat function. This function allows you to concatenate multiple selections. The syntax for the Concat function is.
Concat(Table, Formula)
In my case, I needed to render multi choice column values into a vertical gallery webpart. Here's how I did it.
- I added a label control to a vertical gallery.
- I used the following code in the label control.
Concat(ThisItem.ColumnName, Value & "")
Hope this helps!
For more tips and updates, feel free to connect with me on LinkedIn.