Keyword Identification in SQL query while using power automate desktop

Like (0) Share

Report

Posted on 25 Jun 2024 22:37:16 by Amritesh

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.

Can someone help ?

@PowerAutomate

Categories:

Process Advisor

All responses (1)

Answers (1)

Verified answer

VishnuReddy1997 2,524 Super User 2025 Season 2 on 26 Jun 2024 at 04:43:25

Like (0)

Report
Re: Keyword Identification in SQL query while using power automate desktop

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