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.
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
Thank you
Andreas
Categories: