Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Gallery Lookup across 2 SharePoint Lists - Lookup error on blank rows

I have a gallery in place that was originally just looking at 1 SharePoint list how ever i want to expand what it is showing slightly with some data coming from a 2nd SharePoint list so have changed the Items property of the gallery to something like this


AddColumns(List1, "IssuedUser", Lookup(List2, 'field_1' = IssuedClockNo).'field_2' & " " & Lookup(List2, 'field_1' = IssuedClockNo).'field_3'


All my old columns are populated OK, the new column "IssuedUser" populates fully for all rows with an IssuedClockNo,

If a stamp is not in use IssuedClockNo is empty


I am seeing 'The requested operation is invalid, server response list2 failed fetching items failed, possible invalid string in filter query ....'


I assume i need to carry out a check if IssuedClockNo is empty before doing the lookup ?

What would be the best way of doing this? 



Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,454)