cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

update context and restrict the records that appear based on user

Hi,

 

I am a HRBP and I would love to create an app to help us with the automation of our processes especially wrt the people we partner. Would like to know how to create a function that only let's people matched to a certain HRBP show on the list.

 

E.g we have an excel sheet with a long list of name and on another column have the names of 3 HRBPs matched to all those names. Let's say the HRBPs are Jane, Joe and Ada . I want a situation whereby when Jan signs into the app, she only sees the names that she has been assigned and same for other HRBPs. How do I go about this?

 

Cheers,

 

6 REPLIES 6
Meneghino
Community Champion
Community Champion

You can use the User() function to identify the current user and then filter the list by using the Filter function.
Anonymous
Not applicable

Hi thank you for your reply. please where do I put this function? on the screen that generates the list of employees or on the additional screen I create for signing into the app? or since it's powerapps is there any need to have an additional sign in thing? it's all confusing. Thank you.

 

Cheers,

Meneghino
Community Champion
Community Champion

It is confusing at the beginning.  Let's take it step by step.

Do you have a gallery that shows the list of employees on the "screen that generates the list of employees"?

If so, what is currently the gallery's Items property?

v-yamao-msft
Community Support
Community Support

Hi Aj01,

 

>You could create separate sheets for each HRBP in Excel. Then format the sheets as table.
>Create a connection to the tables, add three screens for each HRBP, set the data source to each table.
>On Screen1, add a Button, set its OnSelect property as:
If(User().FullName="Jane",Navigate(Screen2,ScreenTransition.Fade),User().FullName="Joe",Navigate(Screen3,ScreenTransition.Fade),User().FullName="Ada",Navigate(Screen4,ScreenTransition.Fade)

 

If you don’t know the correct user name, please add a Text box control, and set its Text property as: User().FullName to get it.

 

Please feel free reply if you need more help.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
leyburn19
Memorable Member
Memorable Member

I found a way based on login name or email. When you open the app rhe galley selects only the records based on your filter. Eg filter(table, email1=user().email)

Wher email1 is a column in your table. You can do the same for user name.name=user().fullname
leyburn19
Memorable Member
Memorable Member

I should add this is in the items property to the gallery

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,820)