Dataverse single choice column showing values on csv file after export

Uwak Peter

I am trying to export data from powerapps gallery to a CSV file on a button click event, but I found out that all the single choice columns are showing values but not the labels, I tried getting the label texts using the code below in create a CSV table, and Select power automate actions :

item()?['[email protected]']

It returns null values for all of them! I would appreciate assistance from anyone.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manikandan Murugesan2y ago
You can use the Choices function within PowerApps to get the label for a single-choice column.
```
LookUp(Choices('YourSPListName'.'YourSingleChoiceColumnName'), Value = YourSingleChoiceColumn)
```
Replace 'YourSPListName' and 'YourSingleChoiceColumnName' with the actual names in your PowerApps. This should give you the label for the single-choice column.