cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lifelongjourney
Kudo Kingpin
Kudo Kingpin

Office 365 Outlook - String functions on email body

Hi all, Flow newbie here.

 

I have a Flow that, when a new email is received, creates a SharePoint list item and assigns parts of the email to columns. I then use SharePoint calculated columns to extract substrings from the subject. I want to do this for the body as well, but SharePoint calculated columns don't support multiline text, and the emails are longer than 255 characters so can't be used with a single line text column.

 

Since I can't solve this inside SharePoint, I wondered if I could run the substring functions inside Flow instead.

 

Is it possible to do this with Flow, now or planned for the future? Or, can anyone suggest an alternative way of solving the problem, such as

- an O365 Outlook addin?

- a SharePoint workflow?

- something else?

1 ACCEPTED SOLUTION

Accepted Solutions
v-yamao-msft
Community Support
Community Support

Hi lifelongjourney,

 

Run the substring functions inside Flow is currently not supported yet, may I suggest you submit an idea at Flow Ideas Forum so it might be considered for future release?
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

About using an alternative way of solving this problem, you could also submit a new thread on each Community Forum to see if you could get a solution.

 

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

1 REPLY 1
v-yamao-msft
Community Support
Community Support

Hi lifelongjourney,

 

Run the substring functions inside Flow is currently not supported yet, may I suggest you submit an idea at Flow Ideas Forum so it might be considered for future release?
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

About using an alternative way of solving this problem, you could also submit a new thread on each Community Forum to see if you could get a solution.

 

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

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

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,058)