cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leonardbd
Helper III
Helper III

PowerApps lookup from two SharePoint list

Hello everyone,

 

I have 2 SharePoint list

1. 'ExitCL02-Approvers' : Has all Approvers name in the filed Name (field type: Person)

2. 'Exit Clearance V02': Has all requests data with filed Supervisor (field type: Person)

that I want to Lookup Logged-In user Email matched with 1st list's Name.Email filed OR 2nd List's Supervisor's Email. The command is giving  error right after OR statement. Not sure how to accomplish this.

 

 

With(
    {
     wApprover:
     !IsBlank(
       LookUp(
         'ExitCL02-Approvers',
          User().Email = Name.Email Or 'Exit Clearance V02',User().Email = Supervisor.Email
              ))
    }
)

 

 

 @WarrenBelz 

1 ACCEPTED SOLUTION

Accepted Solutions
BCBuizer
Super User
Super User

Hi @leonardbd ,

 

Since you have two different data sources, you have to perform two LookUps:

 

With(
    {
     wApprover:
     !IsBlank(
       LookUp(
         'ExitCL02-Approvers',
          User().Email = Name.Email 
	   )
	 )
	 Or 
	 !IsBlank(
       LookUp(
         'Exit Clearance V02',
          User().Email = Supervisor.Email 
	   )
	 )
    }
)

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

View solution in original post

2 REPLIES 2
BCBuizer
Super User
Super User

Hi @leonardbd ,

 

Since you have two different data sources, you have to perform two LookUps:

 

With(
    {
     wApprover:
     !IsBlank(
       LookUp(
         'ExitCL02-Approvers',
          User().Email = Name.Email 
	   )
	 )
	 Or 
	 !IsBlank(
       LookUp(
         'Exit Clearance V02',
          User().Email = Supervisor.Email 
	   )
	 )
    }
)

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Dear BC,

Thanks. it was simple 🙂

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,950)