
Announcements
I am working on a flow - where i want to add total adults and total kids to give me the total number combined.
the data is coming from a Microsoft form and being inputted into an excel table. So i have added another column but the flow wont recognize that column as it isn't part of the original form.
I have used initialize variable to make the number turn into a number but when i try the add expression it wont recognize my formula.
can anyone assist please.
thanks
Hi @AliciaDG
Are ‘total adults’ and ‘total kids’ a Text type problem in the Form?
Do you want to add the outputs of the two responses?
You can try to convert the string to a number with Int function and then add the two number with Add function.
Expression:
When a new response is submitted, I will receive an email like below:
Hope the content above may help you.
Best Regards
If my reply helps, then please consider Accept it as the solution to help the other members find it more quickly.