Hi everybody -
I would be grateful for help on the following issue:
I am trying to fill in an excel sheet with info out of weekly emails.
Unfortunately, the emails don't have the same structure everytime (the topics change, headlines change, etc.).
The only things the is always the same is the font style. Meaning: The main topics are always in bold and green and the subitems are always bulletpoints.
For example:
"Hi team - this weeks topics are:
Power Automate - a great tool
I created an excel file with columns like Date, Sender, Subject, Topic, Subitems.
The columns Date, Sender, Subject are no problem and the columns are filled in perfectly.
But I can't find a way to fill the Topic-column with the bold-green-email-text and the Subitems-column with the bulletpoint-email-text.
I already looked into this thread and followed it through: Solved: Extract text from body of an email and create new ... - Power Platform Community (microsoft.com)
What I am hoping for is help with the function:
trim(first(skip(split(first(split(body('Html_to_text'), XXX"BOLD TEXT??"XXX ))),1)))
If there is any info missing, I am happy to provide it.
Cheers mates and thank you in advance!
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional