Unanswered

Updating Dataverse Lookup Field

(0) Share

Report

Posted on by jtaylor0572

Hi all,

I'm trying to update an Invoiced Product field (Units) in Dynamics Field Service. However, the standard logic I used to update lookup fields isn't working. I get the following error:

Here is my current step:

I have verified the guid is correct and that the Units(uom) entity has that record. I know I'm hitting the proper update record because if I remove that "Unit" code and just use the Invoice Product guid, the flow completes successfully.

Thoughts?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @vxmine1 ,

If you want to update a Lookup column in a flow , please try:

/<tableName>(<guid>)

In addition , table name should be logic name instead of display name.

I think this link will help you a lot:
How to update Dataverse lookup column with Power Automate

Best Regards,
Bof

Was this reply helpful? Yes No
jtaylor0572 on at

Like (0)

Report
Copy link

Link copied!

Yes, I am using the table name (logical name for this table is uom) and the guid. In this case I'm using /uoms(guid) for the row in the Units table.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @vxmine1 ,

1\Add the '/' and try again

2\Check the table's logic name

Best Regards,

Bof

Was this reply helpful? Yes No
jtaylor0572 on at

Like (0)

Report
Copy link

Link copied!

I tried with both of those options. I've used PA and Lookup fields before, but this particular entity doesn't seem to be working.

I tried /uoms - the is the logical name for the Units entity
/uomids - this is the logical on the Invoice Products forms

Was this reply helpful? Yes No