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
