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 / How i can get account ...
Power Automate
Unanswered

How i can get account names from list of contacts with flow ?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi i have a list of accounts, at first i search emails in them if i can't find no one i should to find email in related contacts, 

the question is - how i can return accounts names from these contacts ?

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,868 Most Valuable Professional on at

    Hi @Anonymous,

     

    Can you share a bit more details? In what system are these accounts and contacts stored. Are they by any chance stored in Dynamics 365 Customer Engagement?

     

    And do you already have a flow setup. If so, can you share a couple of screenshots.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Yes they stored in Dynamics 365

  • Expiscornovus Profile Picture
    33,868 Most Valuable Professional on at

    Hi @Anonymous,

     

    On the contacts table there should be a property called '_parentcustomerid_value@OData.Community.Display.V1.FormattedValue'. That property stores the name of the related account of the contact.

     

    Below is an example where I am list all the account names for the contacts which are found in the list rows action. It is using this expression in the compose action.

     

    items('Apply_to_each')?['_parentcustomerid_value@OData.Community.Display.V1.FormattedValue']

     

     

    parentcustomername.png

     

     
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi.for some reason I don't get output data at these steps Снимок.PNG

  • Expiscornovus Profile Picture
    33,868 Most Valuable Professional on at

    Hi @Anonymous,

     

    You renamed your apply to each action. In that case you also need to rename it in the expression. 

     

    Can you try and use this instead:

    items('set_message2')?['_parentcustomerid_value@OData.Community.Display.V1.FormattedValue']

     

    Let me know if that works.

     

    If it does not it might be worth checking the raw outputs List contacts action.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    yes i have changed the expression according flow steps

  • Expiscornovus Profile Picture
    33,868 Most Valuable Professional on at

    Hi @Anonymous,

     

    Can you check the outputs (by clicking on the Show raw outputs link) of your списка строк 2 action?

     

    Do you see the parentcustomerid fields over there. And does one of those fields have the customer name in them?

     

    values_check.png

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    they are empty (

    Безымянный.png

  • Expiscornovus Profile Picture
    33,868 Most Valuable Professional on at

    Hi @Anonymous,

     

    Can you check in Dynamics 365 CE if the contacts you are trying to retrieve actually have an Account Name assigned to them? If not, the solution approach I proposed earlier is not going to work.

     

    accountname_empty.png

     

    And if that is the case, can you also tell me were you are storing the related account name/number against the contact record?

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 March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 711

#2
Vish WR Profile Picture

Vish WR 691

#3
Haque Profile Picture

Haque 525

Last 30 days Overall leaderboard