Updating Null through Power Automate Expression

[Garry030424]

I have successfully updated a number field using Null in Update Item Action 

However when i use null within an expression in an action , it fails.

Expression is something like below in HTTP request wherein i am updating a column:

"Sharepoint Field": If(equals('something','something'), null,'something')

"Sharepoint Field" is a number field

Error shows something like below:

Cannot convert a primitive value to the expected type 'Edm.Double'. See the inner exception for more details.

[FLMike]

HI @Garry030424 

Is this a SharePoint HTTP request I take it?

You can try to use Blank or Empty, as I am not sure what action for what platform 100% or see the code etc, thats what I would recommend.

Also, is that Column Required? because if it is then you cannot do what you are trying to do, lastly the HTTP calls can have different requirements than Update Item, so the schema itself can be blocking you.

So you might just have to do if not equals so you set a real value and do nothing (don't put null or empty etc) when it does match.

Lastly, just curious why use an HTTP call instead of Update Item?

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Garry030424]

@FLMike ,Used HTTP request, because we can skip required ones through HTTP request.

Instead of null in the above example if i pass 0, then, it updates successfully.

Why then null is not allowed.

Even more confusing is that i used null with String values earlier in the similar action and it worked ! 

[FLMike]

Hi @Garry030424 

As mentioned, Update Item and Http request are not the same even remotely. So one allowing it, it depends on the Schema being used for the HTTP request.

That's why I was saying do not put a value in if whatever you are doing is null or you want null, don't try to force null just only set it if you want a value.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Garry030424]

@FLMike : If(equals('something','something'), null,'something')

If the first condition is met, i want to set Null / Nothing.

I understand that you have mentioned that there is schema differences however how can i meet this requirement of setting null/nothing (via some other logic/workaround) when first condition is met ?

[FLMike · Accepted solution]

What I keep saying is do this

if(Not(equals(1,2)),'fa')

Change yours from equals, which forces your true side to pass null, instead use Not, and only pass in the true, which would be a value, otherwise its literally nothing

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey