cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StUK
New Member

User Relationships - Get User 'Created By'

Hi,

 

I'm experimenting with my first Power App and Power Automate flows and am having trouble in the flow obtaining user information for a user who created a record in another table.

 

I have created a table 'Reminders' which is populated using a small Power App. When I insert a record I can see the Created By column is assigned a User GUID. This Guid seems to have a FK (Relationship) with the User column in the Users table.

 

When I create a Power Automate Flow and try and 'Get a record' (action) passing in the Guid I just get 'systemuser' as a response rather than a record. Looking at the Keys in the table, the only one listed is the AAD Guid column which is the Guid as assigned in AAD. 

 

My question is, how can I get the user record from 'Created By' field of another table.

 

My end goal is to then use Push Notifications to send a reminder to the Power Apps mobile app, so for I have only managed to do this via an email address, hence trying to get the user record.

 

Thanks

 

Stuart

1 ACCEPTED SOLUTION

Accepted Solutions
rohentz
Microsoft
Microsoft

Hi @StUK how are you?

 

@StUK , at Power Automate to retrieve information from a record and attributes on the related record you can use the expand query property.

 

Please take a look on this post about this subject Using Expand Query in Power Automate with CDS - Power Platform Community (microsoft.com)

 

Please let me know if this information helped on your question.

 

Regards.

Rodrigo Hentz

Microsoft Support Engineer

View solution in original post

2 REPLIES 2
rohentz
Microsoft
Microsoft

Hi @StUK how are you?

 

@StUK , at Power Automate to retrieve information from a record and attributes on the related record you can use the expand query property.

 

Please take a look on this post about this subject Using Expand Query in Power Automate with CDS - Power Platform Community (microsoft.com)

 

Please let me know if this information helped on your question.

 

Regards.

Rodrigo Hentz

Microsoft Support Engineer

View solution in original post

Works great, thanks!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (2,469)