Problem to export data through PA with data with many decimals

[boullen]

Hi,

I have created an table in Power BI, connected to an Power Automate button that's create an excel-table on sharepoint.

The majority of the data exports correctly, but the number values seems to differ betwen the rows, and it seems to be the ones with many decimals. 

I have tried to change all the data to correct format (currency), but it doesent help. Do you guys have an idea of the problem?

Desktop:

Power Automate flow:

Sorry for the Swedish naming in the flow. If you need the english translation please say 🙂

[boullen]

Hi @Anonymous  and thanks for answer.

The weird part of this is that some rows is correct, and some dont. Se the imput data och exported data below:

Input:

You can se it even changes the format to text in some rows 😮

[Anonymous]

Hi @boullen ,

During my investigation I have found users in the past who have had similar experiences to you .
The solution given by other forum users was:This may be caused by the regional settings you use, in which the decimal operator is most probably the comma, as opposed to the dot character.

For original post, you may refer to:Solved: Importing decimal numbers on Excel - Power Platform Community (microsoft.com)

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.