I wonder what to make of the 'ItemInternalId', but I have also no idea how to obtain that.
I've tried something like: body('Get_rows')['ItemInternalId'] but it either returns nothing or flow whines it doesn't exist.
Can anyone explain how to use these connectors if one doesn't know the Row ID's, because for now I don't believe there is. To me it seems the trick with the Row ID renders these SQL connection actions completely useless.
Meanwhile I find this and I'm trying to make sense of it but I fail again.
If I understand the limitations correctly, the table requires to have a primary key, so the RowID would be the Sales Document since this is the primary key.
I'm re-running my failed flows,... and today it all works. Completely flabbergasted!
So the bottom line, the RowID is in fact the primary key defined on your table.
Sorry for my previous rant but I now just keep my fingers crossed that it continues to work. 🙂
Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-yamao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!
Thank you for being an active member of the Flow Community!