Unanswered

Filter Function not working correctly

(0) Share

Report

Posted on by hari27pn

I'm trying to concat the material description from my Excel Table named "Table1" by filtering the table by Item ID = DataCardValue10.Text and the PO Item selected from the combobox(which you can see in the fig).

= Concat(Filter(Table1, 'PO.Item' in ComboBox.SelectedItems, 'PO.No.' = DataCardValue10.Text), 'Material Description', " & ")

This is the formula I used but it is giving me no data while the data exists in the Excel Sheet.

Please help me with this.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

is it =concat(Filter.... that you use, or was it a typo?

Was this reply helpful? Yes No
hari27pn 18 on at

Like (0)

Report

There's no typo here. Plus, there's no issue in the code I used in application.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @hari27pn,

Could you please check if there is any record returned by your Filter() function?

How you set the Items property of the ComboBox?(Important!)

If 'PO.Item' is a General tex column in your excel table, I have tested on my side and your formula works:

Note that I set the ComboBox Items property as carNumbers.Title directly.

Was this reply helpful? Yes No
hari27pn 18 on at

Like (0)

Report

See your screenshot above shows concatenating items based on one logic statement. I have to use two logic statements in my problem.
If I use one logic statement, I do get the output.
But when I put two conditions, I get no data as output. Which isn't true as the data exists in my Excel sheet.

My Combobox items property
If(IsBlank(DataCardValue10.Text),Blank(),Filter(Table1,PO_No = DataCardValue10.Text).PO_Item)

My material description default property
Concat(Filter(Table1, PO_No = DataCardValue10.Text && PO_Item in ComboBox4.SelectedItems), 'Item Description', " & ")

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @hari27pn,

I just give you a sample function, and surely you need to check if there is any record retunred by your Filter() function.

I think you have write a wrong if statement, Blank() returns different data structure with the one your Filter() function returned, you could try to modify your if statement as below:

If(!IsBlank(DataCardValue10.Text),Filter(Table1,PO_No = DataCardValue10.Text).PO_Item)

Then please try your formula

Was this reply helpful? Yes No