Answered

Sharepoint permissons and Powerapp Data Source Permission

(0) Share

Report

Posted on by kylechow

I would like to ask can user add some item to the sharepoint list such that other user can't see it except the user with owner right?

For example, A,B is normal user and C is the owner of the sharepoint list. What I want is that user A can only see his own created items and can't see any items created by B. And C can see all the items from all user.

Secondly, I want to ask can Powerapp Data Source come from different user? Because now if you create the powerapp using the account with sharepoint owner list. Different user can see all the items in the sharepoint list. What I want is that the connection to sharepoint is based who use the powerapp.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

vecerpa 786 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kylechow,

In SharePoint list there is in default hidden column that is called "Created By" this column is default one.

So if you are displaying items in powerapps to user, you can simply add Filter function to Items in gallery that filter it by name of user that is currently running PowerApp like this and compare it to "Author.Email" -
Author.Email = User().Email
Whole function with search and sorting:
SortByColumns(Filter(ApproveDemo;Author.Email = User().Email Or StartsWith(ComplianceAssetId; TextSearchBox1.Text)); "ComplianceAssetId"; If(SortDescending1; Descending; Ascending))
I just slightly changed function that is created when you use "Create PowerApp" on you SharePoint list.

So the final result is in App:

Hope this helps you.
P.

Was this reply helpful? Yes No
kylechow 10 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried your option an I see this message in my console. And I try to lanuch the powerapp, everything is disappeared.

Was this reply helpful? Yes No
Verified answer

vecerpa 786 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kylechow,

There is need to make some slight changes in your function, for me it is like this:

SortByColumns(Filter(ApproveDemo;Author.Email = User().Email And StartsWith(Title; TextSearchBox1.Text)); "Created"; If(SortDescending1; Descending; Ascending))

ApproveDemo: Name of my Data Source (SharePoint list)
StartsWith: There is textinput field in mz case named "TextSearchBox1" that is used for filtering by insertind text.
Title: This is column in my SharePoint (default created when new list added) and I'm looking for text in "TextSearchBox1" in it.
And statement: Better to use this.
SortByColumns: In my case it is sorting by column "Created"
If part: There is image used to switch between ascending and descending sorting called "SortDescending1"

So you have to change this function, but the important part is:

Filter(ApproveDemo;Author.Email = User().Email)

P.

Was this reply helpful? Yes No