Unanswered

Power automate desktop using SQL to filter Excel with SQL query and update data

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

PAD to open SQL connection and execute SQL Statement to filter PO# columns and update certain information to the corresponding columns. Power automate desktop query-1.PNG

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Venkatganesh Refer this: https://docs.microsoft.com/en-us/power-automate/desktop-flows/how-to/sql-queries-excel

https://www.matthewdevaney.com/power-automate-desktop-read-filter-excel-with-sql-query/

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have not used SQL connections for Excel yet, but the strings in your SQL statement are with double quotes ("), they should be single quotes (').
Also, I am not sure if you can use use select and update statements in one block. You might want to split that too.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have solve this issue with below SQL code to filler and update variables.

update [Receipt$] RPT
set [Match_location]='JK'
where [REV_DOC_NUMBER]= 'M29826738';

however another scenario of copy data from specific column and update above things.

Was this reply helpful? Yes No