Updating Null through Power Automate Expression

(1) Share

Report

Posted on by Garry030424

100

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.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Michael E. Gernaey 53,968 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Garry030424 100 on at

Like
a
(1)

Report
Copy link

Link copied!

@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 !

Was this reply helpful? Yes No
Michael E. Gernaey 53,968 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Garry030424 100 on at

Like
a
(1)

Report
Copy link

Link copied!

@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 ?

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,968 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No