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?

All responses (4)

Answers (0)

jtaylor0572 on at

Like (0)

Report

Re: Updating Dataverse Lookup Field

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
v-bofeng-msft on at

Like (0)

Report

Re: Updating Dataverse Lookup Field

Hi @vxmine1 ,

1\Add the '/' and try again

2\Check the table's logic name

Best Regards,

Bof
jtaylor0572 on at

Like (0)

Report

Re: Updating Dataverse Lookup Field

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.
v-bofeng-msft on at

Like (0)

Report
Re: Updating Dataverse Lookup Field

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