Answered

Workarround Show Image in Gallery Delegation

(0) Share

Report

Posted on by QuinceKa

Hi!

We have a PowerApp where we use a gallery with data from a Dataverse table. In this Gallery we try to show an image stored in sharepoint if the Name of the image is in the name of the dataverse item -> LookUp(Documents,ThisItem.new_site in Name, Thumbnail.Large)

This was perfectly working with a small dataset but now we are running into a delegation issue and do not know how to solute this problem.

Any help would be highly apprechiated.

Cheers, Quince

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @QuinceKa ,

The "in" operator in your statement is causing the delegation issue. Is is possible to replace this with "="?

LookUp(Documents,ThisItem.new_site = Name, Thumbnail.Large)
QuinceKa 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi BC,

thanks for the quick reply.
Name is not delegable to Sharepoint, neither...
BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @QuinceKa ,

What are the datatypes of Name and new_site?
QuinceKa 16 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @BCBuizer ,
Sorry for the late reply, been on vacation for a week.
Datatypes are Single line of text.
Verified answer

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @QuinceKa ,

In that case StartsWith() may help as it is delegable for SharePoint:

LookUp(Documents, StartsWith(Name, ThisItem.new_site), Thumbnail.Large)

https://docs.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint
QuinceKa 16 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer Thx a lot for the help. Really appreciated!