web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dynamic Document Grab ...
Power Automate
Answered

Dynamic Document Grab from SharePoint

(0) ShareShare
ReportReport
Posted on by 10

Hey all - 

I hope that i am able to explain this well enough. I am creating an automation around the on-boarding of users based on the IT Team they're on, along with capturing their role. Someone would enter a form, which is pushed to a list. This list starts an automation that eventually sends a "final email" to the new user. Everything works great, outside of the dynamic document grab. Based on the IT Team they are on, they will have a specific "role" and i would like to do a "compare" of the value that is submitted through the initial form, along with the value of a document library on SharePoint. This document would house specific information that is based on the role. I would like to do this rather then send a static document with links - I would prefer to be able to compare the initial role name capture to the "role name" in the document properties. 

Categories:
  • Verified answer
    ChristianAbata Profile Picture
    8,953 Most Valuable Professional on at

    hi @OTboom  I asume that you need to compare the value sended from your user from Forms with a value in sharepoint if is yes you can do this.

    header.PNG

  • OTboom Profile Picture
    10 on at

    Hey @ChristianAbata - Thanks for the reply! Sorry for the delay, we had a large natural disaster the past few days where i live. All is good. Let me give this a try. And if i have issues, i'll share a couple of screenshots so you can tell me what im doing wrong.. 🙂

  • ChristianAbata Profile Picture
    8,953 Most Valuable Professional on at

    Shure @OTboom please share me an screanhot about the error and your flow.

  • OTboom Profile Picture
    10 on at

    @ChristianAbata - This worked great! I do have a question. At the end, I do want to send an email within the condition "If yes". Is there a way i can use HTML to format the link to have a title instead of a URL? 

     

    So for example, here is what it would look like without HTML

     

    "Welcome, here is your document

    Document 1: https://sharepointlocation.microsoft.com/location/filetesting.docx

     

    Thank you!"

     

    And with HTML:

    "Welcome, your document is located "here (this would be a hyperlink)"

     

    Thank you!"

     

     

    I've tried the a couple of different ways but i cannot get it to work.

  • Verified answer
    ChristianAbata Profile Picture
    8,953 Most Valuable Professional on at

    Shure my friend @OTboom  see

     

    htmlemail.PNG

     

    clic on the icon in yellow and then inside add your html that could be

     

    here is your link <a href='Yourkink'>YOUR TEXT TO CLICK</a>

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 330

#2
11manish Profile Picture

11manish 282 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 123

Last 30 days Overall leaderboard