Dataverse single choice column showing values on csv file after export

Question

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()?['[e-mail]']

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

Answer 1

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.