Unanswered

Trying to get all users for a dropdown with company name

(0) Share

Report

Posted on by soc-sp

I'm trying to get all the users for a dropdown that have a certain company name. I've tried in Items:

Filter(Office365Users.SearchUserV2({searchTerm: "", isSearchTermRequired:"No"}).value,CompanyName = "CRE")

but it's not returning all the users. I'm out of ideas.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Jeff_VS 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi soc-sp
Please check out Shane Young's video. Apparently, there are certain limitations or contrainsts which I believe is why you are not able to see all results.

Was this reply helpful? Yes No
soc-sp 16 on at

Like
a
(0)

Report
Copy link

Link copied!
I got it to work, but now when I try to get the value of the drop down it's saying it's blank
Distinct(Contractors,displayName)
is my Items on the dropdown.
This is on visible on my screen:
ForAll( Filter(Office365Users.SearchUserV2({searchTerm:DataCardValue40.SearchText, isSearchTermRequired:"No", top:999}).value, CompanyName = "CRE"), Collect(Contractors, { displayName: DisplayName, email: Mail, dept: Department, jobTitle: JobTitle }) )
So why is
DataCardValue40.Selected.Value
Blank?

Was this reply helpful? Yes No
Jeff_VS 18 on at

Like
a
(0)

Report
Copy link

Link copied!
Not sure if this is what you are looking for?

Here is an example of a manual collection created with dummy names. Collection results are added to a Gallery, same results are added to the Dropdown object and finally the last label value changes dynamically when name is selected in the dropdown.

Button: On Select -->
ClearCollect(collectNames, {Name:"John"},{Name:"Marie"},{Name:"Steven"},{Name:"Max"},{Name:"Rachel"})
Gallery: Items -->
collectNames
Dropdown: Items -->
collectNames
Label: Text -->
Dropdown1.SelectedText.Value

Was this reply helpful? Yes No
soc-sp 16 on at

Like
a
(0)

Report
Copy link

Link copied!
SelectedText isn't an option. I'm combining two different data sources. App OnStart:
ForAll( With({Items: Ungroup(ForAll(ITRequestOtherUsers,Person),"Value"), DistinctEmail:Distinct(Ungroup(ForAll(ITRequestOtherUsers,Person),"Value"),Email)}, Sort( ForAll(DistinctEmail,First(Filter(Items,Email=Value))), DisplayName ) ), Collect(Contractors, { displayName: DisplayName, email: Email, dept: Department, jobTitle: JobTitle }) );
And OnVisible on screen:
ForAll( Filter(Office365Users.SearchUserV2({searchTerm:DataCardValue40.SearchText, isSearchTermRequired:"No", top:999}).value, CompanyName = "CRE"), Collect(Contractors, { displayName: DisplayName, email: Mail, dept: Department, jobTitle: JobTitle }) );
I'm trying to get the dept for the department field and job title, etc.

Was this reply helpful? Yes No
soc-sp 16 on at

Like
a
(0)

Report
Copy link

Link copied!
SelectedText isn't an option. I'm combining two different data sources. App OnStart:
ForAll( With({Items: Ungroup(ForAll(ITRequestOtherUsers,Person),"Value"), DistinctEmail:Distinct(Ungroup(ForAll(ITRequestOtherUsers,Person),"Value"),Email)}, Sort( ForAll(DistinctEmail,First(Filter(Items,Email=Value))), DisplayName ) ), Collect(Contractors, { displayName: DisplayName, email: Email, dept: Department, jobTitle: JobTitle }) );
And OnVisible on screen:
ForAll( Filter(Office365Users.SearchUserV2({searchTerm:DataCardValue40.SearchText, isSearchTermRequired:"No", top:999}).value, CompanyName = "CRE"), Collect(Contractors, { displayName: DisplayName, email: Mail, dept: Department, jobTitle: JobTitle }) );
I'm trying to get the dept for the department field and job title, etc.

Was this reply helpful? Yes No
Jeff_VS 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you go into Variables and check whether collection "Contractors" has any data? It should populate data when you open your app since you have the code OnStart app.

Was this reply helpful? Yes No
soc-sp 16 on at

Like
a
(0)

Report
Copy link

Link copied!

I got it to work. But when I try to use distinct then it loses my dept, jobtitle etc. How do I make a distinct list, but retain all the columns?

Was this reply helpful? Yes No
soc-sp 16 on at

Like
a
(0)

Report
Copy link

Link copied!
I was able to use GroupBy to make it distinct choices, but for some reason the code below to add to my collection is only returning 26 records even though there are like 300 employees.
Filter(Office365Users.SearchUserV2({searchTerm:DataCardValue40.SearchText, isSearchTermRequired:"No", top:999}).value, CompanyName = "CRE")

Was this reply helpful? Yes No