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

Notifications

Announcements

Community site session details

Community site session details

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard