Answered

Logic to Update a Lookup Field Only When the Provided GUID is NOT Null

(0) Share

Report

Posted on by CAC-93

I am trying to update rows with Lookup fields in Dataverse by passing a table of GUIDs in JSON format to power automate. Issue is, the GUID is not always provided:

If I patch a null to a lookup field using the /entitysetname(key) format in the 'Update a Row' action I get an error returned:

This is because it is null.

My question is, is there a way to add coalesce() or if( isnull(Basis GUID) ) so that power automate can just skip this row?

I tried this, but power apps gives me a "Fix invalid expression(s)" error

I just want to pass nothing to this field if items('Apply_to_each')['Basis GUID'] is null.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

MJain 2,450 on at

Like (0)

Report

Hi @CAC-93 ,

Try using the below expression :

if(empty(items('Apply_to_each')['Basis GUID'], ‘ ‘,
concat(‘eomb_gt_bases(‘, items('Apply_to_each')['Basis GUID'],’)’))

Thanks

Was this reply helpful? Yes No
CAC-93 82 on at

Like (0)

Report
Hello and thank you, this worked just as planned. The code ultimately ended up being:
if( empty(items('Apply_to_each')['Basis GUID']), null, concat('/eomb_gt_bases(', items('Apply_to_each')['Basis GUID'],')') )
But that is simply because I wanted null there rather than ' '.
Additionally, you needed a '/' character before the EntitySetName "eomb_gt_bases" to complete the /EntitySetName(key) method to patch lookups.

Thank you for the suggestion!

Was this reply helpful? Yes No