Power Automate Flow failing to create Excel report due to DOT in column name

(0) Share

Report

Posted on by a_sherwani

HI All.

Please help me with your expertise as I am stuck for a while.

I have a requirement to create a flow that should generate an excel file dynamically and email it. My report contains a "." in the column name. For e.g., ''Traded.Amount'' but the flow is failing at 'Apply to each' step.

If I remove the "." from the column header, it works.

Please find the attached 'Apply to each' step and the error message.

PBI Version: 2.115.663.0 64 bit (March 2023)

Regards

Ahmad

Categories:

Building flows

error.png

Add-a-row-in-a-ta...

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

grantjenkins 11,063 Moderator on at

Like (2)

Report
Any periods within a Field name will be converted to _x002e_

TradedQuantity.Amount //will be TradedQuantity_x002e_Amount

Was this reply helpful? Yes No
a_sherwani 5 on at

Like (0)

Report

Hi grantjenkins,
you are a genius mate. Thanks, its working now.

Was this reply helpful? Yes No