Convert 'Choice' column to text values within AddColumns function

[sdedic]

Hi all,

I can't find the way to convert data from choice column into a text inside AddColumns function when the datasource is Dataverse. I am able to do this when using SharePoint, but the same formula doesn't seem to work with Dataverse.

Since I want to GroupBy my Gallery Items using a choice column, I have to convert that same column into text values using AddColumns function and then use it to group with GroupBy.

The choice column is named 'Stage'. However, I can't take the values from that column using expression 'Stage.Value'.

Here is the formula I am trying to utilize:

Screenshot 1

 

Screenshot 2

As you can see, it finds the 'Stage' column inside 'Opportunities' data source (screenshot 1), but can't evaluate the data for the 'Stage' column (screenshot 2). When I try to retrieve its data with .Value option, I am getting an error (screenshot 3):

Screenshot 3:

Here are the errors for the above formula:

FYI: the third error "Name isn't valid. 'Value' isn't recognized." refers to 'Stage.Value' expression.

Any help is more than appreciated.

Ty.

[v-xiaochen-msft]

Hi @sdedic ,

Please try to add a text() function in your formula.

AddColumns(...,"MyStage",Text(Stage))

Best Regards,

Wearsky

[sdedic · Accepted solution]

Thank you for the suggestion @v-xiaochen-msft. Eventually, what worked is the formula from screenshot 1. So, when the datasource is Dataverse, it is enough just to name the choice column within AddColumns function.

For instance:

AddColumns(Source, "MyNewColumn", MyChoiceColumn)