cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
snitika
Regular Visitor

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

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)

 

snitika_0-1663885361895.png

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User
Dual Super User

@snitika 

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

Mira_Ghaly_0-1663887556579.png

 

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.

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

4 REPLIES 4
SudeepGhatakNZ
Solution Sage
Solution Sage

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

If my suggestion helped you, please give it a Thumbs up and mark it as a Solution so that it can benefit others in the community.
Mira_Ghaly
Dual Super User
Dual Super User

@snitika 

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

Mira_Ghaly_0-1663887556579.png

 

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.

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

For example -

Column - status reason

and it has label and values as below. 

snitika_0-1663937766322.png

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

 

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... 

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,650)