Flows: Update a dataverse table without knowing the ID

[TokeJacobsen]

Hi guys,

I am in the middle of creating a flow that copies data from one dataverse to another and I am experiencing an issue, for which I FEEL like there should be an easy solution to, but I somehow can't wrap my head around.

As stated, I have a table (T1) , where I want to transfer data to another table (T2).

 T1 has a column called Name, which holds a text value (which is also a GUID), that I use as a reference to T2 - let's call that row T1_Name. 

When traversing T1 I want to update the corralating row in T2. In SQL I would do something like:

Update T2 ColA, ColB, ColC, VALUES (A,B,C) Where T1.Name = T2.T1_Name. 

As far as I can see, the Update A Row-activity REQUIRES me to know the unique Row ID, which I don't dynamical. 

Search Row-activity doesn't specify which table (and is also only in preview) which seems very inintuitive to me. 

Looking forward to hear from you! 

Thanks!

[Mira_Ghaly · Accepted solution]

@TokeJacobsen 

What you need here is to get the row from Table 2 using List Rows and add a filter query like.

ReferenceColumn eq referencecolumnvaluefromtable2 ,

Then you can update the row returned from List Rows , let me know if this makes sense.

[TokeJacobsen]

Hi Mira,

This makes alot of sense! I will give it a try and as soon as it works, I will Accept as Solution.

Thanks!