Answered

Update a row woes

(1) Share

Report

Posted on by menes

Consider the following scenario, I want to update an entity (eg work order) on a value that is a reference, that is conditionally mandatory.

Eg, I have a custom field name change status reason that is conditionally mandatory based on the value of msdyn_systemstatus.

Since is a reference, the value is of the form dot_workorderstatusreasons(%GUID%) where GUID is a variable.

If I want to clear the value, I simple pass the function null instead of dot_workorderstatusreasons(%GUID%)

Where is the catch? If I set a character variable to NULL and pass it on the value of the field then it doesn't work!!!! WHY?

Ok, there is a work around to check if I had a guid and depending on this do either a update a row passing dot_workorderstatusreasons(%GUID%) or update a row passing the function null, however this is frankly moronic, since supposedly passing a string variable set to function null should be the same!!!!!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Michael E. Gernaey 53,960 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

Let's start at the beginning. You do a fairly good, not great, job of explaining what is wrong.

However, what you don't have is the actual Flow with the actions etc so we can see them. Nor do you have the action to do the update with the Raw Inputs to validate that 1) you didn't accidentally TYPE null into the variable, versus using the expression.

So right now I got nothing since I don't see anything. Now adays this is super common to talk about flows but not actually show them :-) not sure why but hey, provide the info and happy to help

Was this reply helpful? Yes No
menes 44 on at

Like (0)

Report
Copy link

Link copied!

It is really simple.

This works:

This doesn't:

The problem is that a null string is passed as '' and not as null, and these two are not the same, null is no value where '' is empty value

Was this reply helpful? Yes No
Verified answer

menes 44 on at

Like (0)

Report
Copy link

Link copied!

Treating it as object didn't work either, because though it allowed passed NULL object, it didn't allow passing a string value.

What did the trick is using the following:

if(equals(triggerBody()?['StatusReason'],''),null,variables('Status Reason'))

where Status Reason is defined as string with value dot_workorderstatusreasons(triggerBody()?['StatusReason'])

Was this reply helpful? Yes No