web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery is not display...

Power Apps

Answered

Gallery is not displaying all items

(0) Share

Report

Report

Posted on by JB0007

308

Hi Power Apps community,

I have an app for searching data of a person. The Data is saved in an Excel Workbook on OneDrive for Business. I don't see any delegation warning but when I search on some names, they will not appear in the gallery. When I check the file, I can see those names clearly.

Search(ExcelTable, TextInput1.Text,"Secondname" ,"Id","Entry_ID")

I have also create a variable in a button:

Set(filterData, Filter(ExcelTable, TextInput1.Text = Secondname))

and set the Gallery Items to filterData, but the same names are not showing either.

Can someone help me?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Do those names (that do not show on searching) show in the gallery without searching?
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JB0007 ,

That is because the data source(Excel on OneDrive for Business) is not delegable for PowerApps, so you won't receive any delegation error.

The workaround is to import the excel data to another data source which is delegable, e.g. SharePoint list.

Here is a reference about how to import Excel to SharePoint:https://www.kalmstrom.com/Tips/SharePoint-Online-Course/Import-Excel-Spreadsheet.htm

Hope this helps.

Sik

Join the conversation