Unanswered

Created CSV file - text columns opening in excel with Scientific Notation

(1) Share

Report

Posted on by rowan_preston

I have two columns in my dataverse table - they are TEXT columns. They are account numbers, and unfortunately some accounts begin with 61E eg 61E010. I've created a flow to export the data to a csv file, but when the csv file opens in excel, these accounts come through as scientific notation eg 6.10E+09. The import drops all account reference and only contains the numbers eg 61000000000 when the column is expanded.

Is there a way of formatting these account numbers so they don't convert to scientific on opening the file?

* Not all accounts begin with 61E, we have 61V, 61Q, 61N etc and these accounts come through fine. It's about 250 odd accounts that begin with 61E that's messing it all up.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Can you provide a screen shot of your flow please.

Was this reply helpful? Yes No
rowan_preston on at

Like
a
(0)

Report
Copy link

Link copied!

Please see below: It's the ShipToAccount and InvToAccount that are causing the problem.

Was this reply helpful? Yes No
365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Why do you need to create a CSV to be opened in Excel?

If you need to put the data in Excel then I suggest 2 other options (rather than adding to CSV).

1 - Use the Flow to add the rows to a Table in Excel or.

2 - Avoid Power Automate altogether and create a Power Query in Excel that directly reads from the Dataverse Table.

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw

Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
rowan_preston on at

Like
a
(0)

Report
Copy link

Link copied!

It's a data export from our App - available to all users so they can get a report of all active customers in the App. There's about 35 users.....

Was this reply helpful? Yes No
365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah I would then suggest you use PowerQuery in Excel (Raher than Power Automate). You don't need to export data as it Reads directly from the Dataverse table.

Here is a video I found that will help you set it up. https://www.youtube.com/watch?v=RfxKSksC4WA

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw

Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No