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 / Flow for Dynamics acti...
Power Automate
Answered

Flow for Dynamics activities

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Trying to make a flow sending an email with a digest of all current Dynamics activities. Most of data is OK, but some of the parameters are of a strange data format (looks like some addresses).

For example:

CreatedBy: 2a0b6db1-1db2-e611-8120-3863bb34ed70

Owner: 0c964b72-40d7-e611-812b-3863bb35cf68

How to translate it in a normal view? 

Categories:
I have the same question (0)
  • Ed Gonzales Profile Picture
    4,531 Most Valuable Professional on at

    @Anonymous 

    Hi there!  Welcome.

    So those are GUID's...unique identifiers assigned to most unique record types.  It's not always apparent, but this is typically what is presented/requested rather than the "Display Name" that people are used to seeing.

     

    I think if you add a step "Get Record" with the Entity Name "Users", and set the Item Identifier as the ID (either Created by or Owner), then you should be able to select the Full Name from the user record.

     

    Depending on how the rest of your Flow looks, it may automatically create an "Apply to Each" loop, which won't be terrible.

     

    Try that out and let us know how it goes.

     

    Thanks!

    -Ed-

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @edgonzales 

     

    Thanks for your comments. I have added such a step. It works for some minutes. But I still don`t understand, how to use this data in a output table.

     

     

  • Ed Gonzales Profile Picture
    4,531 Most Valuable Professional on at

    @Anonymous wrote:

    @edgonzales 

     

    Thanks for your comments. I have added such a step. It works for some minutes. But I still don`t understand, how to use this data in a output table.

     

     


    You want to show a screenshot of your Flow so far and we can take a look?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @edgonzales 

    Here it is


    3.png

    31.png

    32.png

    33.png

     

    Result:

    34.png

  • Ed Gonzales Profile Picture
    4,531 Most Valuable Professional on at

    Ok, You're very close.

     

    In your Create HTML table, under Owner, you want to clear that one out and grab the Full Name field from the "Get Record" step and that will get you the correct field...but...

     

    How stuck are you on the HTML table (can it be Excel, for example?) and how averse to 'code' are you?  Here's why I ask:

    I think the rows need to be updated with the Full Name one by one inside the Apply to Each window.  Which means you'll need to either create a table or array-like variable in the beginning and then append to it as your Flow updates the GUID with the more-readable Full Name.  You can't append to an HTML table, but if you're comfortable with a mild level of code, we can initialize an array in the beginning, and then append to that inside the Apply to Each.

    If you're code-averse like me, we can probably update a table inside Excel, then dump that thing into an HTML table to email out, and then clear it so it's ready for the next run of the Flow.  Let me know if that makes sense and/or what your preference is.

    -Ed-

  • Verified answer
    v-bacao-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    It seems that the methods I provide in this similar thread fit your needs.

    Please check it and see if it helps:

    https://powerusers.microsoft.com/t5/Building-Flows/Logical-Names/m-p/272640#M27804

     

    Best Regards,

  • v-bacao-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Any updates?

     

    Best Regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Just truing to make flow based om templetate with minimal changes

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @v-bacao-msft I`ve done it. Thank you

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 632

#2
Haque Profile Picture

Haque 458

#3
Valantis Profile Picture

Valantis 357

Last 30 days Overall leaderboard