web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dot(s) inside Excel co...
Power Automate
Answered

Dot(s) inside Excel column header makes PowerAutomate desktop not able to read the column values

(0) ShareShare
ReportReport
Posted on by 49

I found a bug where Excel columns that has dots in them is not read properly when using action read from Excel. 

The column values with that column header containing a dot (.) will not be part of the result.

This happens everytime with all Excel files.

I have the same question (0)
  • ApoxiomeN Profile Picture
    32 on at

    It was the same case when it was Softomotiv.
    I would suggest changing column names manually or using a VBScript to do it automatically if the column names are dynamically generated.

  • Mibsk Profile Picture
    49 on at

    Okay, well. 

    Ive been working with ProcessRobot for years, and this have never been a problem. 
    In fact i have migrated a process to power automate desktop that worked perfectly fine in processrobot with dots in headers but now in PowerAutomate is not working anymore.

  • ApoxiomeN Profile Picture
    32 on at

    Really?
    I remember having the same issue with ProcessRobot as well. That's why I always removed dots ahead of developing the robot.

  • Mibsk Profile Picture
    49 on at

    Yes i have never had that problem. 
    Now i already do what you suggested in another flow that i build directly in PAD. 
    But since this specific process was working perfectly in ProcessRobot i had to post it here. 

  • Mibsk Profile Picture
    49 on at

    I still think they should fix it no matter what. 

    Just my opinion. 

  • Verified answer
    VJR Profile Picture
    7,635 on at

     

    Do you mean Excel column headers with dot like these?

    They are showing up in the Datatable.

    I am using v2.20

     

    VJR_0-1653470397567.png

     

  • Mibsk Profile Picture
    49 on at

    Ty
    It has been fixed with the newest release then.
    Just tested with the document that failed before and now it works!

Under review

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

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 180

#3
Haque Profile Picture

Haque 159

Last 30 days Overall leaderboard