User lookup from SP list or Office365 connector

(0) Share

Report

Posted on by da1vea

185

Hi all,

I am looking at issues for an app I didn't build. The issue reported is that the results are limited to a handful of users. The app has a combo box and is referencing a column in the SharePoint list (the column is a "person or group" type).

SP list name: TYP

Columns name: Nominee

In the app the combo box property is set to "Choices([@TYP].Nominee)" and is part of a form submission.

How would I fix the issue of only returning some user results? I tried:

Office365Users.SearchUser({searchTerm: "", top: 1000})
Office365Users.SearchUser()

If I go direct to the SP list and try create an entry, I can search all available users. Is it a delegation issue I'm facing?

Also worth mentioning these settings

Thanks,
David

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @da1vea ,

The difference here is that

Choices([@TYP].Nominee)

only looks in the SP list existing records for values already stored (it does not utilise Office365Users). If you do this

Office365Users.SearchUser({searchTerm: Self.SearchText})

you can use the actual search text to find users - note it will only action in a StartsWith like search on either Given or Surname. The DefaultSelectedItems would be

RenameColumns( ThisItem.TYP, "Email", "Mail" )

and the Data Card Update

ForAll( DataCardValue8.SelectedItems As _Sel, { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Lower(_Sel.Mail), Department: _Sel.Department, DisplayName: _Sel.DisplayName, Email: _Sel.Mail, JobTitle: _Sel.JobTitle } )

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

Was this reply helpful? Yes No
da1vea 185 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks @WarrenBelz ,

Interestingly depending on the user I tested with the combo box would display different results. However your expression:
Office365Users.SearchUser({searchTerm: Self.SearchText}
is exactly what I was after. Thank you!

Was this reply helpful? Yes No