Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 61

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?

    andewmilorad_0-1713475052463.png

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

  • andewmilorad Profile Picture
    andewmilorad 61 on at
    Re: Need Help with Power Automate - Customization of email, links and separate email addresses for each individuals

    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?


    andewmilorad_0-1717145564321.png

     

     

     

     

     

     

     

     

     

    Hyperlinking "Item Name" in Email

    I cannot edit HTML code in my Flow editor for some reason.

    If I use the following:

     

    andewmilorad_1-1717146519112.png

     

    I get this in email:

    andewmilorad_2-1717146594420.png

     

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

     

    I would appreciate any suggestions!

     

  • o2o2 Profile Picture
    o2o2 40 on at
    Re: Need Help with Power Automate - Customization of email, links and separate email addresses for each individuals

    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. 

    o2o2_0-1713517186615.png

    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!

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard