web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Different functionalit...

Power Apps

Answered

Different functionality for same excel document on Sharepoint and Local Upload

(0) Share

Report

Report

Posted on by dodzikojo

9

Hi all,

this is an interesting one for me.

I have a combined search and filter function applied to gallery items.

Search(Filter(Table1, ProductTypeID='Product Type Gallery'.Selected.'Type ID'), Searchbox.Text,"ProductNumber","ProductName")

The code above works perfectly when the Excel data source is uploaded as static data (Image label 2), but it does not work using the same file from SharePoint (Image label 1).

Is this expected behaviour? If not, what may be causing this issue?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

dodzikojo 9 on at

Like (0)

Report
Copy link

Link copied!
Resolved using the below instead.

With( { MyData: Filter( Table1, ProductTypeID = 'Product Type Gallery'.Selected.'Type ID' ) }, Search( MyData, Searchbox.Text, "ProductNumber", "ProductName" ) )

Was this reply helpful? Yes No

Join the conversation