Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

csv data usage

Posted on by
Hello,

I'm working to create a flow, that downloads data from a homepage in csv format and adds this information into an existing Excel file.

When I do this manually, I can open the downloaded csv file in Excel and the format is as expected and I can use the data (date and numbers) as it is.

Doing the same with Power Automate using the function "start Excel", the data of the csv file shows up differently and I cannot use this data as there is a difference how the numbers are shown. About ignoring the comma and showing some numbers as text.

Maybe it is important to know, that my language settings are "German" for Microsoft365. And the big difference is that "German" uses "," as decimal sign instead of "."
Somehow, I have the feeling, that this might be the issue. It seems, Power Automate ignores the "German" settings and uses "English" ones during the opening of the csv file brings up the issue.


The other issue might come from the csv file itself. Zeros in the decimal places are cut off, so there are 0 to 3 decimal places.

I already tried to change the csv file to a txt file and open this, but this makes things worse.

Maybe I have overseen something. But I would be great, if someone could help me.
Attached you will find an example for the csv file.

Thank you
Andreas
 

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >