ComboBox Field to show only Users of a specific country which obtain data from SharePoint column

(0) Share

Report

Posted on by tanst_844288

Hi,

I am new to PowerApp & I have a field that obtained data from the SharePoint column with “Choose from: All Users”.

How do I apply a filter to the ComboBox so that it only shows users from a specific country? Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (0)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

In your SharePoint list is there a column that defines the country the employees are in?

Was this reply helpful? Yes No
tanst_844288 86 on at

Like (0)

Report
Copy link

Link copied!

No, my SharePoint only has the column for
- Visitor Name
- Visitor Email & phone number
- Employee (the employees the visitor wanted to visit) which obtain data from All Users

I know that the All Users has information for Name, Email, Department & etc but unsure if it has Country also or if I can add this info into the record.
Sorry, if I sound ignorant about the All Users because most information I found online is very sketchy regarding this part- it only mentions that it fetches from the active directory (whatever it means).

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

Like (0)

Report
Copy link

Link copied!
Hi @tanst_844288 ,

Unfortunately, the answer is no. The person column doesn't have a Country property.

But you could use Office365Users connector to get their countries.

AddColumns(LIST214,"Test_Country",Office365Users.SearchUser({searchTerm:ThisRecord.Test_Person.Email}).Country)

//LIST214 is the name of my list. Test_Person is the person column .

In other words, you could get the country by using the unique email .

Then you could use Distinct function to get unique countries array.

But before that, you should make sure to set each user's country information.

Their information is stored in azure AD.

Best Regards,

Wearsky

Was this reply helpful? Yes No
tanst_844288 86 on at

Like (0)

Report
Copy link

Link copied!

Hi Wearsky, I think of using your first suggestion. But where & how do I put in the formula for the first method you suggested? Thanks

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

Like (0)

Report
Copy link

Link copied!

Hi @tanst_844288 ,

It can be used in many places, such as the items property of gallery.

Best Regards,

Wearsky

Was this reply helpful? Yes No
tanst_844288 86 on at

Like (0)

Report
Copy link

Link copied!

I don't have a gallery for the employee, so I added the formula to the dropdown ComboBox under property "Items". But I have 2 errors when putting in the formula, is there other things I have to fix before the formula works?
I guess I need to put in another formula to filter the country that I wanted

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

Like (0)

Report
Copy link

Link copied!

Hi @tanst_844288 ,

OK，I didn't notice that your person column allows multiple selection.

I'm a little confused. What the scope do you want to filter users by country?

In other words, if you want to filter users in the US, is the scope the users of the entire organization (tenants) or the users that exist in the sharepoint list person column?

Best Regards,

Wearsky

Was this reply helpful? Yes No
tanst_844288 86 on at

Like (0)

Report
Copy link

Link copied!

I worked in a multinational organization, the All Users has employees in many different countries but I just want to filter the employees to the country I reside

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

Like (0)

Report
Copy link

Link copied!

Hi @tanst_844288 ,

Office365Users connector will return Country field.

https://docs.microsoft.com/zh-cn/connectors/office365users/#search-for-users-(v2)

Best Regards,

Wearsky

Was this reply helpful? Yes No
tanst_844288 86 on at

Like (0)

Report
Copy link

Link copied!

Hi Wearsky, Thanks, actually I am trying to use the formula you given which I have errors currently.
I am trying to elaborate the outcome that I am looking for below - I don't know if this is possible.

Was this reply helpful? Yes No