Add function not behaving properly

(0) Share

Report

Posted on by Rai Onkar

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. Error ErrorOverview of the flow Formula FormulaThe update item block in which the formula is used.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yamao-msft on at

Like (1)

Report
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.

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

Was this reply helpful? Yes No
GabrielStJohn on at

Like (0)

Report

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

Was this reply helpful? Yes No