Hello everyone.
I'm having an error with "Execute SQL Statement" in Power Automate Desktop and I'm looking for a solution.
Does anyone know of a solution?
Error details:
The second "Execute SQL statement" always results in an error.
license:
Free
access point:
ć»SharePoint list A ex. 62bd0e3c-ab50-449e-b9ac-32ba73a95713
and
SharePoint list B ex. 62c30e3c-ac15-451e-b9cc-32an23a92933
flow:
[pattern 1]
1. Set up a connection for SharePoint list A in "Open SQL connection"
2. In "Execute SQL Statement", "SELECT * FROM [62bd0e3c-ab50-449e-b9ac-32ba73a95713]" on SharePoint List A
3. Close the connection for SharePoint list A with "Close SQL connection"
4. Set the connection for SharePoint list B in "Open SQL connection"
5. In "Execute SQL Statement", "SELECT * FROM [62c30e3c-ac15-451e-b9cc-32an23a92933]" on SharePoint List B --> Error!!
6. Close the connection for SharePoint list B with "Close SQL connection"
[Pattern 2]
1. Set up a connection for SharePoint list B using "Open SQL connection"
2. In "Execute SQL Statement", "SELECT * FROM [62c30e3c-ac15-451e-b9cc-32an23a92933]" on SharePoint List B
3. Close the connection for SharePoint list B with "Close SQL connection"
4. Set the connection for SharePoint list A in "Open SQL connection"
5. In "Execute SQL Statement", "SELECT * FROM [62bd0e3c-ab50-449e-b9ac-32ba73a95713]" on SharePoint List A --> Error!!
6. Close the connection for SharePoint list A with "Close SQL connection"
