Unanswered

How do I filter a list of attachments by the currently logged in local user?

(0) Share

Report

Posted on by dougmccaughanwo

I have a power pages site. It uses only self managed accounts. That is, a user comes to the site and is prompted to register or login. No Azure AD. The user logs in and is presented with a form that allows them to type in a name and attach one or more files.

After they submit the form, the page should show a list of the filenames they have already uploaded but only theirs.

I have the list working but it currently shows all the attachment filenames.

How would you recommend going about having the user log in and in addition to seeing the form, they see a list of the filenames they have already uploaded?

Thank you.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Fubar 8,338 Super User 2025 Season 2 on at

Like (0)

Report

All users local or AD or other external identity provider etc will have a Contact record created for them in Dataverse.
On the form they submit you will need to configure it to associate the the portal user / contact with that record.
https://learn.microsoft.com/en-us/power-pages/configure/basic-forms#additional-settings

It also sounds like you may have a Table Privileges that are set to Global, in which case ideally create ones that are scoped to the Contact. You don't say what method you are using for attaching the file e.g. Notes, file field etc. so I am assuming its notes, and then Table permission Parent scope (child in the new language) from the record to the Note/annotation.

You can then control access via Web Role table permissions or filtering on the List by the current portal user (additional setting on the List configuration).

Was this reply helpful? Yes No
dougmccaughanwo 29 on at

Like (0)

Report

Thank you!

Was this reply helpful? Yes No
dougmccaughanwo 29 on at

Like (0)

Report

I'm being really dense. Can someone give me the ELI5?

I have a table called "TheUploads"

On the home page, I have a form which has this table selected under "Choose a table". I have turned on Attachments for the form with "Enable attachments, Attachment is required, and allow multiple files" The home page has permissions set to administrators and authenticated users. So users have to register then log in. I am not using AD.

Since the form allows attachments, a related table called Note gets created to hold the uploaded file(s).

I created a list on the home page beneath the form. The list is supposed to show the file names of the files uploaded by the currently logged in user. Instead it shows the filenames of every file uploaded.

I have tried and failed to set permissions to allow the logged in user to only see their own files by creating a table permission with Access type set to "Contact access" I've tried setting the permission on the table "TheUploads" as well as the table "Note" The permission requires a relationship. I've tired a one to many with the Note table to the contact table. I've tried various different relationships.

What am I doing wrong?

Thanks.

Was this reply helpful? Yes No