I'm building a Power Automate flow, with goal of updating specified rows in my MySql database. The issue is, that table I'm trying to update has a composite key of three values: id_product, id_lang, id_shop.
I've built a following update row logic:
Name, link_rewrite are columns of my ps_product_lang table, but I'm not changing them (adding only as they were required by Automate).
Description is another column, that I'm trying to update with value of some HTTP request logic I'm processing for each row of the database.
I've tried following options for Row id:
passing id_product as Row Id, but obviously it wasn't enough as it expects 3 values for my composite key instead of one
passing all three key fields as Row Id, but it is incapable of parsing it and returns error
passing entire Current Item as Row Id, but it errors since it consists of more fields than just 3 key fields
limiting rows that I get from database by setting Select Query to only 3 ID columns and then adding Current Item, but it still errors since it adds 2 extra fields to the item
So basically I couldn't find a way to create an item with only 3 IDs, nor find a way to pass three IDs in separate items.
