Unanswered

Search multiple datasources in one gallery

(0) Share

Report

Posted on by DanielMellingen

Hi there.

I'm using the Office365 connector in an app.
We have a main search page, where we can search the employees, but the Office365Users.SearchUserV2 method doesnt give employeeId in result. I would like to add this field via a custom connector that I have made.

The thing that I want to accomplish is to being able to search for all the office365 results, but ALSO the employeeId, in the same searchfield.

Is there a way to add column "employeeId" on the office365 results from my custom connector, with using email as a LookUp maybe? This field exists in both the office365 connector and my custom connector.

OR

Is there a clever way to search for labels/content in the gallery that i dynamically add? Without creating a circular reference error...
There is no problem for me adding a label to each of the gallery records and doing an API-call to provide the correct employeeId in the gallery (for each of the employees). Would be nice if I could search all of the actual content of the gallery.

Regards,
Daniel

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @DanielMellingen ,

You can save the table with email column and employeeId column which comes from a custom connector into a collection.

Then use addcolumns function.

Sample:

AddColumns(Office365Users.SearchUserV2({isSearchTermRequired:false}).value As temp,"employeeId",LookUp(Col,Email=temp.UserPrincipalName).employeeId)

Best Regards,

Wearsky

Was this reply helpful? Yes No
DanielMellingen 2 on at

Like (0)

Report
Copy link

Link copied!
Thank you for your suggestion.

This solved part of my solution.
I did it right on the custom connector itself tho, but much in the same way.

Search( (Filter( AddColumns(Office365Users.SearchUserV2({isSearchTermRequired:false, top: 1000}).value As temp,"employeeId", Text(LookUp('MY-CONNECTION-NAME'.GetEmployees(),Upper(email)=Upper(temp.Mail)).employeeId)), AccountEnabled = true, !IsBlank(CompanyName), !IsBlank(JobTitle) )), TextInput1_1.Text, "DisplayName", "employeeId")

But I want to search both office365 AND employeeId at the same time with the same field.

Given the size of content in our Office365 connector this seems to give me a problem. As far as I can read on the Office365 connector documentation 1000 rows is the limit (with no searchTerm it seemingly justs snags the 1000 first rows in alphabetical order).

As of now, everything works for all persons going from A-C(somewhere), but thats it. And I can search for their employeeId. But the initial dataset is to small to cover my search.

If I on the other hand provide a searchTerm to make the initial dataset from Office365 connector smaller, I can't use employeeId as a term, since it doesn't exist in that connector.

Any suggestions would be much appreciated. 🙂

Regards,
Daniel

Was this reply helpful? Yes No