Unanswered

Parse email body to SharePoint list number columns

(0) Share

Report

Posted on by Amanda123

Good morning,

I have successfully created a flow in which the body of an email is split and then auto populates the connected SharePoint list. The problem is my email contains currency amounts. The flow will not work unless I have those columns set to single text however I need them to be number or currency columns so that I can create a flow that will generate a monthly report with the sum of those columns (which I can't do currently b/c they are text columns not number, I can manually convert them within excel but it is very time consuming and I can not create a flow from this). My question is; can I parse numbers or currency from an email body to number or currency columns in the list? I have attached my current flow. thank you for any advice or suggestions!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Amanda123

You can use float() (for decimal) or int() function to parse number from email body and save in the SharePoint numeric or currency column.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Amanda123 12 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your response. Would you change the split to int or float? I tried that but it is giving me error messages.

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Amanda123

Could you pls share the split expression?

Was this reply helpful? Yes No
Amanda123 12 on at

Like (0)

Report
Copy link

Link copied!

Hello!
Yes here is the expression; split(outputs('Html_to_text')?['body'], ':')[9]
and a screenshot, the green highlighted are currently only working when they are connected to a single text column but since I need to get a sum of the columns to create a monthly report I would really love to figure out how those can connect to a number column. I have been trying to work on a automate that would get the sum for me with a manual tigger however I am having similar problems. Thank you for any help!

Was this reply helpful? Yes No