Answered

Lookup from SharePoint Lists

(0) Share

Report

Posted on by Surajde

I need to get the lookup Domain value from SharePoint list for that respective user ().email

In below table Owners and Escalation Focals have multiple Domains to look for. How to get their respective domains in default selected value of a Combobox when the user is from Owners or Escalation column?

Please help.

Domains	Owners	Escalation Focals
Shared Services	Suraj Devasthali	Suresh Sam
Development	Saji John	Suresh Sam
Production	Deepak Shah	Suresh Sam
BAU Services	Deepak Shah	Suresh Sam
Infra	Gajender Kumar	Sri Ram
Microservices	Suraj Devasthali	Sri Ram
CloudOps	Roman Patra	Sri Ram

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 154,791 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Surajde ,

Something like

Filter( SPListName, 'Escalation Focals' = User().FullName || Owners = User().FullName ).Domains

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
Surajde 99 on at

Like (0)

Report
Copy link

Link copied!

Thanks WarrenBelz for quick response. It is working when user().email has only 1 Domain. If he has Multiple domains then its not appearing in comboxbox.
When added Deepak's email then formula not working. Please help.

Production Deepak Shah Suresh Sam
BAU Services Deepak Shah Suresh Sam

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,791 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Surajde ,

The Filter I provided should show all matching (User's name is in Domains or 'Escalation Focals') in the Items of the Combo Box. DefaultSelectedItems are another matter - you did not tell me the Items of the Combo Box, but on the assumption that the field displayed is Domains, try

ForAll( Filter( SPListName, 'Escalation Focals' = User().FullName || Owners = User().FullName ) As aDom, {Domains: aDom.Domains} )

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
Surajde 99 on at

Like (0)

Report
Copy link

Link copied!

I wonder formula only works for Owners or Escalations Focals who has only 1 domain. But whomsoever has more than 1 domain is not getting selected in defaultselecteditems of ComboBox

Rami has two domains then ComboxBox is not showing any selected values.

Was this reply helpful? Yes No
WarrenBelz 154,791 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Surajde

You are stretching the limits of what a Combo Box will do here - I do not believe you can do many-to-many filters in the DefaultSelectedItems of a Combo Box.

Was this reply helpful? Yes No
Surajde 99 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz This is the original question 😃.
If you can please suggest alternate workaround for this.

Was this reply helpful? Yes No
WarrenBelz 154,791 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Surajde ,

Maybe (I cannot test this) -

{ Domains: ForAll( Filter( SPListName, 'Escalation Focals' = User().FullName || User().FullName in Owners ).Domains, Domains ) }

Was this reply helpful? Yes No