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
Solved! Go to Solution.
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
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
Works great, thanks!
User | Count |
---|---|
18 | |
9 | |
8 | |
5 | |
5 |
User | Count |
---|---|
31 | |
29 | |
18 | |
15 | |
4 |