Answered

Power Pages data Owner column is the system not the currently logged in user

(0) Share

Report

Posted on by dougmccaughanwo

I've written a Power Page that is a public facing site but only authenticated users may see the pages. This gives the users the ability to self-register a local account so that we do not have to maintain them in AD. There is a dataverse table with the default "Owner" column. When a user logs in, they fill out a form and upon submitting it the data is put in this table. However, the Owner column is aways the system "# Portals-The App Name" so when I try to create a filter with "Owner Equals current user" no data is ever shown because the current user will never be "# Portals-The App Name" This same system owner is populated in "Created By" and "Modified By"

I tried creating a column called Username and it does get the username of the current user but when I try to create a filter in the view on "username" I do not get an option for "Equals current user" so I am left unable to filter by the currently logged in user.

How do I get the Owner column to reflect the user who is logged in at the time they submitted the form?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

domliu37 314 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @dougmccaughanwo ,

To answer your question regarding: 'How do I get the Owner column to reflect the user who is logged in at the time they submitted the form?'

Owner field is a lookup field of User table. The logged in portal user is from Contact table, so its not possiable to set the Logged in portal user (Contact) on the Owner (User) field.

----------------------
If you enjoy this post, click the thumbs-up button. If it helped you, mark it as a solution so others can find it easily.

Cheers,
Dom

Was this reply helpful? Yes No
Verified answer

dougmccaughanwo 29 on at

Like (0)

Report
Copy link

Link copied!

My problem was in trying to limit data on the screen to those of the currently logged in user. I was barking up the wrong tree with Owner. It was the contact field that was blank. Because it was blank, I could should all the data or none of the data to the currently logged in user. The solution was to open the Portal Managment app (if someone is wondering 'where is that?' one way to get to it is to edit a form, click data, and you'll see a link to 'Open Portal Management app' and another is to click the ellipsis below setup in the left hand navigation then select Portal Managment.). Within Portal Management choose 'Basic Forms' from the left hand menu. Then select 'Additional Settings' and scroll down until you see a box labeled 'Associate User on Insert' I cannot reproduce it but I swear this box didn't show up until I click +sSubmit in the Actions of 'Action Button Configuration' but the truth is I probably never scrolled down far enough because of all the extra white space on that page. Next check the checkbox beside 'Associate Current Portal User' Finally, select the Portal User Lookup Column as the 'contact' That will give you what you need to add a list to your page that shows only the current user's data.

Was this reply helpful? Yes No