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 / Keyword Identification...
Power Automate
Answered

Keyword Identification in SQL query while using power automate desktop

(0) ShareShare
ReportReport
Posted on by 10

Hi All, 

 

I am trying to write back some data back to excel based on certain conditions using SQL queries. However the column Phone Number is being read as a keyword 

Please refer to the screenshot. 

 

image.png

 



Can someone help ?

@PowerAutomate

I have the same question (0)
  • Verified answer
    VishnuReddy1997 Profile Picture
    2,666 Super User 2026 Season 1 on at

    Hi @Amritesh ,

     

    The issue is with the column name "Phone Number" is a reserved keyword in SQL. When you use reserved keywords without escaping them, they can conflict with the intended functionality in your SQL query.

     

    You Can try this and let me know.

     

    UPDATE [Sheet1$]
    SET
    "Phone Number" = '%PhoneNumber%',
    [Company Address] = '%CompanyAddress%'
    WHERE
    [Accounting ID] = 'POI'


    (Note:- if you got your solution you can mark as solution and gives kudos)


    Thanks & Regards

    Vishnu Reddy

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 276 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 169

#3
Haque Profile Picture

Haque 154

Last 30 days Overall leaderboard