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!
Solved! Go to Solution.
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.
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.
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!