Answered

Viewing contents related to a particular user

(0) Share

Report

Posted on by freshyshreya

675

Hi,I have created a form using power apps.In the form,the contents get displayed according to the names selected.One name can be selected at a time as shown in the below pic.

I want to view the contents according to the username sign in.

For example:If Neel signs in to SharePoint he is able to see content related only to him and not others.

Kindly provide solution for this!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

Moreshwar 135 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

You need to apply filter on Items property. It can be something like Filter(SharePointList, UserName = User().DisplayName)

Where User() function refers to O365 logged in user.

Was this reply helpful? Yes No
freshyshreya 675 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, when I am using the formula its throwing error as shown in the above pic.

Kindly provide help!

Was this reply helpful? Yes No
Verified answer

Moreshwar 135 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this: Filter('work assignment', Fixer_Column3.Value = User().DisplayName) or
Filter('work assignment', Fixer_Column3.DisplayName = User().DisplayName)
depending upon what is your Fixer_Column3 datatype

Was this reply helpful? Yes No
freshyshreya 675 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, when I am using the formula provided in the below comment its throwing error as shown in the above pic.

Kindly provide in resolving the error!

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @freshyshreya ,

@Moreshwar is almost correct, but you still need to pay attention to the details. Like we should use "User().FullName" instead of User().DisplayName.

Besides, from your information, I think Fixer is the name of your SharePoint column. So if this is a People column, try formula like this:

Note: directly use the column name in your formula, don't use column name like "XXX.Column1" which are generated from Table.

Filter('work assignment', Fixer.DisplayName= User().FullName)

Best regards,

Allen

Was this reply helpful? Yes No