Unanswered

Need Help with Power Automate - Customization of email, links and separate email addresses for each individuals

(0) Share

Report

Posted on by andewmilorad

Hello Everyone,

I'm new to Power Automate and would greatly appreciate your assistance with a few questions I have regarding its functionality. I'm hoping someone experienced in this tool can lend me a hand!

I have managed to create automatization based on following help: Re: Send an email to Share Point file owners if th... - Power Platform Community (microsoft.com)

My question are:

Custom Name for SMEs in Email: How can I add a custom name for each Subject Matter Expert (SME) at the beginning of the email?
Custom Date for Review Deadline: Is there a way to add a custom date that is "+14 days" from the current date for when the SMEs have to review the content?

Screenshot 2024-04-18 213555.jpg

Hyperlinking "Item Name" in Email: Is it possible for the email received by the SMEs to display as "Item Name" with a hyperlink directly to the document, creating a short URL?

Screenshot 2024-04-18 224552.png

Error Handling with Multiple SMEs: Additionally, when I have multiple SMEs, it prompts the following error: "Every individual SME should receive only email and document for himself." How can I resolve this issue?

I would highly appreciate detailed instructions or any insights you could provide to help me navigate through these challenges.

Thank you all in advance for your support!

Best regards,

Andrew

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

o2o2 40 on at

Like (0)

Report
Copy link

Link copied!

Hello there!
I'll try to help out with some of your questions.
Custom Name for SMEs in Email
- This should be inside an apply to each. The names should be stored somewhere (SP list for example). Inside the apply to each, you can use the column that stores the SME name. Provide more details if needed 🙂

Custom Date for Review Deadline
Yes, there is! Try out "addDays(DATE VARIABLE,14,'MM-dd-yyyy')". Replace DATE VARIABLE with your variable.
Link for more details - https://www.spguides.com/power-automate-add-days-to-date/
Hyperlinking "Item Name" in Email
For this, my suggestion is to use HTML formatting. If the link as always the same, you could user hyperlink.
Try something like this, go for Code View, and place "<a href="LINKTOITEM CONTENT BOX">View item</a>" Note, when toggled (Code View) it can't be untoggled 🙂

Reference - https://powerusers.microsoft.com/t5/General-Power-Automate/how-to-put-clickable-link-into-email/td-p/561491

Error Handling with Multiple SMEs
How are you placing the email to? Are is the source data? There seems to be a problem in the way the email to is being placed. Provide more details 🙂

Hope it helped!

Was this reply helpful? Yes No
andewmilorad 61 on at

Like (0)

Report
Copy link

Link copied!

Custom Name for SMEs in Email
When I try to add an SME's name at the beginning of an email, it creates a "for each" loop in the flow (see image below), causing the flow to misbehave.

Is there another solution to add the SME's name without incorporating this "apply to each" action in the flow?

Hyperlinking "Item Name" in Email
I cannot edit HTML code in my Flow editor for some reason.
If I use the following:

I get this in email:

I need it to be shortened via HTML a href to something more pleasant to look at. 🙂

I would appreciate any suggestions!

Was this reply helpful? Yes No