Email data extraction number to sharepoint list ID

(0) Share

Report

Posted on by chris_scott

I have managed to build a flow where it extracts the number from an email. Say ID number.

Is there a way to then get this to relate to the same ID number on a SharePoint list?

The point being that when an email is received with the ID number and a Yes or No answer included, Power Automate extracts the number and the answer for yes or no. Then writes this to the corresponding SharePoint list line that relates to that same ID number.

Flow design so far

Email sent from SharePoint list details > Email includes SharePoint list ID number > Customer returns email saying yes or no to the question > PA extracts the answer and the ID number > PA then writes the answer to the question on the relevant line on the SharePoint list.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

AlexEncodian 4,409 Moderator on at

Like (0)

Report

Sounds very doable. You havent provided enough detail to provide a suggested solution. I would start building it and ask questions if you run into issues.

Was this reply helpful? Yes No
chris_scott 56 on at

Like (0)

Report

@alexencodian

I am writing my flow in bits, learning each stage before I put the whole thing together. I wouldn't know where to start with converting the output from a compose and then converting it to relate to the SharePoint list item ID.

Was this reply helpful? Yes No
Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

To convert a plain text to a number, just wrap it in an int expression. Since you don't show your flow, I can only assume you've figured out how to get this value out of the e-mail since that is what you stated in your post.

Assuming you have figured out how to get the number out of the text in your e-mail, and assuming you store the value in a string value called ListID, you would use this expression to convert it to a number: int(variables('ListID'))

If you haven't figured out how to get the value out of the e-mail, you'll need to show your workflow so we know what you're doing and you'll need to show a sample of the e-mail that is returned.

Was this reply helpful? Yes No