cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
raionkar
Frequent Visitor

Add function not behaving properly

Hello,

I have designed a flow in which I am using microsoft form as trigger.

I need to add two number to update a sharepoint list. One is from micrsoft form and other is from a sharepoint list. 

But, add expression is giving me an error saying one of the numbers is null, where as thats not true. 

Please find attached the screenshots of the  error, formula, basic flow. ErrorErrorOverview of the flowOverview of the flowFormulaFormulaThe update item block in which the formula is used.The update item block in which the formula is used.

1 ACCEPTED SOLUTION

Accepted Solutions
v-yamao-msft
Community Support
Community Support

Hi @raionkar,

 

According to your description, I made a simple flow for testing on my side. If the Number of days less or equals Number, use add function to update Total in the list. All of the three columns are type of number.

 

The add function is configured as:

add(items('Apply_to_each')?['Number_x0020_of_x0020_days'], items('Apply_to_each')?['f8il'])

 

The total will be updated without error.

1.PNG

 

What’s the column type of Get response details? Please make sure there is a value in the field of Leaves Takes. I assume that whenever this field is blank, it will return the error says that the provided value is of type Null.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yamao-msft
Community Support
Community Support

Hi @raionkar,

 

According to your description, I made a simple flow for testing on my side. If the Number of days less or equals Number, use add function to update Total in the list. All of the three columns are type of number.

 

The add function is configured as:

add(items('Apply_to_each')?['Number_x0020_of_x0020_days'], items('Apply_to_each')?['f8il'])

 

The total will be updated without error.

1.PNG

 

What’s the column type of Get response details? Please make sure there is a value in the field of Leaves Takes. I assume that whenever this field is blank, it will return the error says that the provided value is of type Null.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

GabrielStJohn
Microsoft
Microsoft

Hello,  @raionkar!

Have you had an opportunity to apply @v-yamao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!


Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (30,131)