Filter gallery items based on user group

[Fahd]

Hello,

I have an application on Power apps connected to a SharePoint list named Assets with the below columns:

-              Serial number: text column

-              Bar code: text column

-              Model number: text column

-              Manufacturer: text column

-              Custodian: person column

-              Country: choices column (Canada, USA, Australia, China)

I have also created 4 other groups (Canada, USA, Australia, China).

My purpose in power apps is to filter the gallery so that people can only see the items where the choice column value (Country) equals to their respective country.

For instance, a person who is in Canada group can only see the assets where Country=Canada.

Any idea how I can manage it?

Thanks

[WarrenBelz]

Hi @Fahd ,

The Filter would be

Filter(
   Assets,
   Country.Value = YourDropDownName.Selected.Value
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Fahd]

Hi @WarrenBelz , if I do like this, it means that anyone can see the items of the differents groups depending on the value that he choses from the dropdown. I do not want that. For instance if I am in canada group , I should only see the assets where the dropdown value = Canada. But when I select USA I can't see nothing because I am not authorized.

Thanks

[WarrenBelz]

@Fahd ,

You need to remove anything not authorised from the first drop-down. You would need to identify the user's country and only offer that as a choice.

[Fahd]

Hi @WarrenBelz ,

this is my challenge. How can I identify the country of the connected user on the start of the app? I also have created a list named "configuration" with the below columns

AssetFocalPoint (person column)

Country (Choice column: Canada, China, USA, Australia). In this list, I have entered the persons with their respective country.

Now on Power apps level, how can I get the user country in a variable on the run start so that I can apply the filter based on the country value.
Thanks

[Rajkumar_404]

Hi 

To identify the country of the connected user on the start of the app in PowerApps, you can use the User() function and the Office365Users connection. Here's an example formula that you can use to get the country of the current user:

Office365Users.UserProfile(User().Email).Country

In this formula, User() returns the current user, Office365Users is the name of the connection to the Office 365 Users data source, and UserProfile returns the profile of the current user. The Country property returns the country of the current user. Once you have the country of the current user, you can use it to filter the data in your app. For example, you can use the Filter function to filter a SharePoint list based on the country of the current user. Here's an example formula that you can use:

Filter( 'Configuration',
 AssetFocalPoint.Email = User().Email && 
Country.Selected.Value = Office365Users.UserProfile(User().Email).Country )

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

[WarrenBelz · Accepted solution]

@Fahd ,

Try

Set(
   gblCouhtry,
   LookUp(
      Configuration,
      AssetFocalPoint.Email = User().Email
   ).Country.Value
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Fahd]

@WarrenBelz  and @Rajkumar_404 , thank you very much. It now works, I have also found the below link that helped me.

https://devoworx.net/powerapps-lookup-function-examples-complete-tutorial/