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

Like (0) Share

Report

Posted on 6 Sep 2022 13:26:09 by Community Power Pla...

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

All responses (3)

Answers (0)

Community Power Pla... on 08 Sep 2022 at 06:36:28

Like (0)

Report

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

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.
Community Power Pla... on 08 Sep 2022 at 05:56:10

Like (0)

Report

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

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.
AS-06081019-0 1,736 Super User 2024 Season 1 on 06 Sep 2022 at 18:58:05

Like (0)

Report

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

@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/