Hi,
We have a clunky IT approval system that involves clicking a link in an email that generates a new email that basically says Approved and ref: xxxxxxx
Can anyone help me extract that info from the initial link so I can build an approval flow and approve these things on my phone on the go?
This is the data from the link: The data I need is highlighted
mailto:dummy@domain.com?subject=%5BRITM0177771%5D&body=Enter%20comments%20below%3A%0A%0A%0A%0A%0A%5BApproved%5D%0A%0APlease%20do%20not%20modify%20the%20subject%20of%20the%20email%20or%20reference%20number%0A%0ARef%3AMSG6562322%20
This is how the link in the email looks like:
Kind regards,
Frank
Solved! Go to Solution.
Hi @Anonymous,
First of all, I am not sure what kind of mail you are going to extract from.
Or I don't know what your email contains, and I don't understand what it means from your description.
You could create such a Flow first, configure When a new email arrives as a trigger, then use Html to text to get the contents of the email body, and then provide a screenshot of the Html to text outputs so that I can know what to do with the content.
Like:
I tested it on my side according to my understanding and received an email with a hyperlink. The address of the hyperlink is the data you provided. Like:
Then I extracted the body of this email and extracted the data from your highlight.
Email:
last(split(first(split(body('Html_to_text'),'?')),'['))
Ref:
concat('Ref',replace(last(split(body('Html_to_text'),'Ref')),']',''))
Result:
Best Regards,
Barry
Hi @Anonymous,
First of all, I am not sure what kind of mail you are going to extract from.
Or I don't know what your email contains, and I don't understand what it means from your description.
You could create such a Flow first, configure When a new email arrives as a trigger, then use Html to text to get the contents of the email body, and then provide a screenshot of the Html to text outputs so that I can know what to do with the content.
Like:
I tested it on my side according to my understanding and received an email with a hyperlink. The address of the hyperlink is the data you provided. Like:
Then I extracted the body of this email and extracted the data from your highlight.
Email:
last(split(first(split(body('Html_to_text'),'?')),'['))
Ref:
concat('Ref',replace(last(split(body('Html_to_text'),'Ref')),']',''))
Result:
Best Regards,
Barry
Hi Bary,
Great help how can I extract the subject the same way?
What would be the expression?
I'm completely new to the Power Automate trying to learn which is the best place to learn to understand what expression does what?
Thanks for your help
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
42 | |
36 | |
36 | |
23 |
User | Count |
---|---|
41 | |
31 | |
29 | |
28 | |
26 |