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))

Improve this question

1 Answer 1

Reset to default
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))
Improve this answer
2
  • do I just append this to the previous "Items" formula with a comma? also what is data source, just the name of it? Commented Sep 29, 2021 at 14:52
  • Try formula in updated answer. Commented Sep 29, 2021 at 15:47

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.