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

(1) Share

Report

Posted on by dylandavis09

438

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)

dylandavis09 on at

Like (1)

Report

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

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 438 on at

Like (1)

Report

Hi Nived,

Here's two screenshots:

Was this reply helpful? Yes No
Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

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

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 438 on at

Like (1)

Report

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,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi

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

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (1)

Report

Ahh, when created it item: D_x002d_Tickets

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi

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

Was this reply helpful? Yes No
Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report
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