I would like to do a query with "Execute query" but I saw it's not working with on-premise gateway...so...I use Update row.
I get all the line I want with a view (a view who get all the line in every db I use) and I do a Each For for each line I get. And for each line, I get the "Structure" which is the name of the database where the line I wanna update is.
On the "Update row" I put "Stucture" on the name of the DB but I don't get the name of the field...so I can't put the value I wanna update.
Here is my flow (I don't know how to post a picture...) :
Get line (connection on my db/view)
Update row (connection on the embedded db)
Send a mail to the creator
Hi @Bapt_69 ,
You could only get the fields when you choose the table of the database in the drop down list.
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think you didn't understand (I wasn't clear enough I guess)
In my "Update Row" action, I don't have any field. I have to notice 1 database and 1 table. Here, I put a variable in the field "Database" and the name of the table in the field "Table". So, I have "ID" and "item" and not all the field from the Table.
If I fill 1 database and 1 table, I see all the field! If I do it like that, I have to create 12 connexion and 12 flows (note I have 12 databases). And I would have only one flow (cause only one flow to modify if needed).
NB : Notice I get the line from a view (which get lines from many databases) and I update the line on the Table of each database
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.