Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Issue getting related Dynamics records

(0) ShareShare
ReportReport
Posted on by 4

I'm trying to get information out of an entity related to the one that triggers my flow. The related entity is called "Client" - and there is definitely a value. So I tried to chain a "Get record" step in order to get this related entity, and I put the "Client" dynamic field in the "Item Identifier" field for the Get record step.

 

However, when I run the flow, I can't access data out of the result of the Get Record step. I have the ability to add the dynamic content from that step, but no data is returned. When I look at a specific run, I can see that the output of the Get Record step has multiple records in the result, but there should only be one.

 

Thanks in advance

 

 

 

  • Carter Musick Profile Picture
    Carter Musick 4 on at
    Re: Issue getting related Dynamics records

    Does anyone have any ideas after the additional information provided?

  • Carter Musick Profile Picture
    Carter Musick 4 on at
    Re: Issue getting related Dynamics records

    In  our dynamics solution, we have 2 entities - client and enrollment period. Client and Enrollment Period have a 1:N realtionship (enrollment has a lookup field called "client"). We are using the "When a record is selected" step for dynamics on the enrollment period form. Based on the enrollment period, I want to get the email address field from the related client record. So I added a "Get record" step to get the client based on the lookup field. 

     

    flow1.PNGflow2.PNG

     

    I've added the 3 test fields you can see to the email. "Client" is the lookup field on the Enrollment Period entity that points to client, Email address is on the client entity, and Authorization Date Start is on the Enrollment Period entity. Both Client and Email Address do not have a value in the email, but Authorization Date Start does. 

     

    Also, the output from the "Get record" step when I download it has multiple client records. I'm not going to do a screenshot there because of sensitive data, but you'll have to take my word for it.

     

    Here is the Enrollment Period record that I ran against, showing a value in the Client lookup:

    flow3.PNG

     

    Here are the results of the run:

     

    flow4.PNGflow5.PNGflow6.PNG

     

     

  • v-yuazh-msft Profile Picture
    v-yuazh-msft on at
    Re: Issue getting related Dynamics records

    Hi @CarterMusick,

     

    Could you please explain more details about your requirement?

    Could you please share a screenshot of the configuration of your flow?

    Could you please share a screenshot of the flow run history?

     

    Please share more details so we would try to provide a proper workaround for you.

     

    Best regards,

    Alice

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,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics