Issue with "One or more fields provided is of type 'Null', a different type is expected."

(1) Share

Report

Posted on by dylandavis09

442

I am struggling with some input. Although it should be correct, it ends up being invalid. How can I solve the issue with the message 'One or more fields provided is of type 'Null'; a different type is expected'? Please help me out.

I created 'Condition 1' to check if the category is 'School' when an item is created in SharePoint. If the category is 'Dorm', it should go to the 'false' section and process both 'PBiS Send To Users Dorm' and 'PBiS Submitted Users Dorm' in parallel branches at the same time. It seems like the 'Update item 5' section failed, while all the others are working with no issues.

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

Sort by

dylandavis09 on at

Like (1)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi

Could you share what details you have passed to update item action ?

Thanks & Regards,
Nived N

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No
dylandavis09 442 on at

Like (1)

Report
Copy link

Link copied!

Hi Nived,

Here's two screenshots:

Was this reply helpful? Yes No
Suggested answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @dylandavis09

Could you check what is second parameter you have provided in add expression ?

The error occurs because that second parameter in add function is null.

Thanks & Regards,
Nived N

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No
Bavenraj 12 on at

Like (1)

Report
Copy link

Link copied!

The issue is in your add() function you used in the "Update Item 5" section. Check whether the values you are trying to add is not null. This might solve the issue.

Was this reply helpful? Yes No
dylandavis09 442 on at

Like (1)

Report
Copy link

Link copied!

I using for add function:

add(body('PBiS_Send_To_Users_Dorm')?['Value']?[0]?['DormD_x002d_Tickets'],triggerOutputs()?['body/DormD_x002d_Tickets'])

DormD_x002d_Tickets:

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi

Is the value is empty for the DormD_x002d_Tickets when the item is created ?

Was this reply helpful? Yes No
dylandavis09 442 on at

Like (1)

Report
Copy link

Link copied!

Ahh, when created it item: D_x002d_Tickets

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi

did not get what you said- could you please elaborate ?

Was this reply helpful? Yes No
Suggested answer

David_MA 14,614 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Based on the error message, the field you are using for the condition does not contain a value when the flow runs (it is null). You can do one of two things:

Make the field used in the condition required in your SharePoint site so that it cannot be submitted without a value.

Add an and condition to your conditions with an expression to that the field is not equal to null (type the word null, and do not select it from the expression builder. However, this is going to force it down the no side of the condition when the value is empty, so I would make it a required field.

Was this reply helpful? Yes No