Export data in excel file from Dataverse and then save to FTP

[Anonymous]

I am a business case where I would like to pull data from a dataverse table 

The column in table are with different datatypes (date, text, option set etct)

I am able to pull the data in a txt file but its not correct 

- option set values are in txt file instead of name

- date format is not correct (but I guess I can write a step in b/w to convert the date format)

here is what i get in txt file --------------

Ref,StatusReason,Outcome,RiskAssessmentReason,DateReceived
CV10323,810340004,,140120000,2021-08-08T00:21:24Z
CV10203,810340005,,140120007,2020-03-25T13:26:09Z
RA10053,810340000,,140120005,2020-02-21T08:01:06Z
CV10253,810340004,,140120011,2020-11-05T00:00:27Z
CV10256,810340004,,140120012,2020-11-09T00:00:40Z

[SudeepGhatakNZ]

Does this help?

How to export data in Power Automate to an Excel File (tachytelic.net)

I do not follow what you mean by

- option set values are in txt file instead of name

[Mira_Ghaly · Accepted solution]

@Anonymous 

You need to use the below expression as below:

item()?['mg_columna@OData.Community.Display.V1.FormattedValue']

you need to replace mg_columna above with your column name

For date formatting you need to use below expression as well:

formatDateTime(item()?['createdon'],'dd/MM/yyyy')

Replace createdon with your date column name and use the format you need in the second parameter of formatDateTime.

[Anonymous]

For example -

Column - status reason

and it has label and values as below. 

I want to pull out the label instead of value in the excel file

[Anonymous]

Thankyou it worked.

I have one more related question.. sorry i am super new to Power automate.

How can i fetch related tables field value...