Filter in gallery with Excel data does not work

(0) Share

Report

Posted on by ME-29071948-0

Filtered values from an Excel table are not output or displayed.
 
Function: Filter(Table1;'Device No.'=DataCardValue39.Text) 
Copilot: This expression filters Table1 for rows in which the device no. matches the text value of DataCardValue39. 
As long as both arguments are converted to text, it works, but then it causes the delegation problem. 
If the source is a SharePoint list with the same column, the function works.

Where could the problem be?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 53,493 Super User 2025 Season 2 on at

Like (1)

Report

Question,

Is Device No a number?

And if I understand correctly, if you do, Text('Device NO.') it works?

To me that tells me excel thinks its a Number and if so, then you need to use the Value of DataCardValue39.Text

And to make sure you dont delegation

Do this

With(

{ConvertToNumber: Value(DataCardValue39.Text) },

Filter(Table1, 'Device No.' = ConvertToNumber)

)

Was this reply helpful? Yes No
ME-29071948-0 6 on at

Like (0)

Report

You understand correctly. I've already tried converting it as a number.
Unfortunately without success, as an error message
then appears stating that different formats are being compared with each other.

Filter(Table1;'Device No.' = Value(DataCardValue39.Text)

The Device No. column is a number column from a Shapoint collection,
which was transferred to Excel using Power Automate. The column format in Excel is default.

I have the feeling that the values from Excel are unconverted, neither numbers nor texts.

Was this reply helpful? Yes No
ME-29071948-0 6 on at

Like (0)

Report
By trying it again I can confirm my suspicion! I have now added a new column to the Excel table and prefixed the number with the text “DeviceNo.-”. Now the column from Excel is also recognized as a text format in Power Apps. Additionally, I formatted the value from the datacard as text. Filter(Table1;'DeviceNo.Excel'="DeviceNo." & "-" & Text(DataCardValue39.Text;"#"))

Was this reply helpful? Yes No