web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Fetch Content from Mai...
Power Automate
Answered

Fetch Content from Mail/subject and spilt to excel

(0) ShareShare
ReportReport
Posted on by 27

Hello,

I receive notifications for approval for various changes/requests as per ITIL Standards. 
I wish delegate change/requests to my subordinates for review.

Once they review, I can proceed for approval.

How I am planning to achieve is upon arrival of notification - I can split using the subjectline the Change/Request no. and add rows to a shared excel document. This is expected to be refreshed once mail arrive which I can share this excel to my subordinates.

Problem is I am unable to add the subjectline to variable and split to meaningful to that I can add to rows on the excel.

Subjectline format - Approval required for Request ID :<Request ID> : <Request Title> Technician:<Requestor>

Once I am able to add<request ID>, <Title>, <Technician> and place them as row in table of my excel - my delegates will be able to review.

Currently I am unable to split the subjectline of the mail notification. I am aware of placing the content to excel, but not spliting.

Appreciate if someone can guide.

Categories:
I have the same question (0)
  • Verified answer
    Monkeyman Profile Picture
    325 on at

    Hi,

     

    I think this article will help you - Split and Empty functions (jondoesflow.com)

     

    Please accept this solution if this does what you need.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard