cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Champion
Community Champion

Re: update context and restrict the records that appear based on user

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

Re: update context and restrict the records that appear based on user

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,

Highlighted
Community Champion
Community Champion

Re: update context and restrict the records that appear based on user

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?

Highlighted
Community Support
Community Support

Re: update context and restrict the records that appear based on user

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.
Highlighted
Super User
Super User

Re: update context and restrict the records that appear based on user

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
Highlighted
Super User
Super User

Re: update context and restrict the records that appear based on user

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

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (4,468)