cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
babylyn
Frequent Visitor

Cannot update sql row

Dear,

 

Anyone who can help me please? I want to update a sql row, i just designed a basic flow just to prove the concept. But it seems to be not working.

 

Here is the structure of my AX table where I have assigned the RECID as the primary key and column ID.

AX.png

 

 

Here is my flow design.

Flow Config.png

 

 

this is the error.

 

Error.png

 

I have tried also to just use RecID as the key by deleting the Index1 in the AX table, but getting the below error.

 

2021-10-22_18-47-40.png

 

Any suggestion is really helpful.

 

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions

Dear @gabibalaban 

 

Thank you for replying. I just 1 by 1 tried to mix the dynamic values to form the composite keys and the flow ran successfully when the combination is DATAAREAID and RECID

 

babylyn_0-1634922093725.png

 

Regards,

 

View solution in original post

2 REPLIES 2
gabibalaban
Super User
Super User

@babylyn ,

Use only ID for row id ... it should work !

 

Dear @gabibalaban 

 

Thank you for replying. I just 1 by 1 tried to mix the dynamic values to form the composite keys and the flow ran successfully when the combination is DATAAREAID and RECID

 

babylyn_0-1634922093725.png

 

Regards,

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,435)