I've written a simple power app pages. It is a form with one text field. Below the form, I've put a list to show the currently logged in user's data. If I set the table permissions to access type "global" I would see all the records in the database exposing one user's data to anothers. This is bad. Switching the access to type "contact access" changes the list to "No records found." So I set the permissions back to "global" and change the view to "Filter by Owner is current user" This limited data in the list but revealed that the current user is "system" not the actual external user.
What am I missing?
You need to add a Lookup to Contact (and/or another one for Account depending on your requirements) in your Table, and then populate it with the Portal Users' Contact - if the original record is being created from the portal you can populate via configuration settings on the Form or via Form Metadata.
https://learn.microsoft.com/en-us/power-pages/configure/basic-forms#additional-settings
(for both of these the field does not need to be shown on the form)
I'm working in Power Pages. Not Power Apps. Made a typo in my original message. Mea culpa.
Hi @dougmccaughanwo,
can you post your question here: https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1
The forum you posted it in is for power pages.
The users there will be happy to help you with that problem.
Fubar
69
Super User 2025 Season 1
oliver.rodrigues
49
Most Valuable Professional
Jon Unzueta
43