0

I am trying to edit my app in a way such that the user can only see and edit their own records. I am trying to do this within the app itself and not the list.

As I list I am aware I can restrict permissions. But I am trying to do this in the app.

I need to restrict but user().Email as I use this in a "Created by" field.

How can I restrict my "BrowseScreen" by user id?

my items formula in growse gallery in browse screen:

SortByColumns(Filter([@'Template'], StartsWith('Purpose and objectives', TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

1 Answer 1

1

Try filtering items property of gallery control on "BrowseScreen" to something like:

Filter(DataSource, 'Created By'.Email = User().Email)

Where DataSource is your SharePoint list data source.


Update from comments:

SortByColumns(Filter([@'Template'], 'Created By'.Email = User().Email && StartsWith('Purpose and objectives', TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))
2
  • do I just append this to the previous "Items" formula with a comma? also what is data source, just the name of it?
    – Jonnyboi
    Commented Sep 29, 2021 at 14:52
  • Try formula in updated answer. Commented Sep 29, 2021 at 15:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.