Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Working on my first flow to parse htm table from email to excel

(0) ShareShare
ReportReport
Posted on by

Hi All,

 

Greetings for the day!

 

This is my first post on this community, I have been trying to build an email snapper using power automate, the objective is to store the price, index name and asof date as a row in excel. we receive 100s of emails from different banks having index prices with dates. can anyone pls tell me how to use the split function to parse the data from the below email type. i will use it for future references as well.

 

Hello,
Please find bellow the level of ABC Index as of 12-05-2022

 

BBG Level

2022-05-12

114.2854

 

 

Output :

ABC Index      114.2854     2022-05-12

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow