Answered

How to filter a table on the screen based in another field of same screen

(0) Share

Report

Posted on by MIA27

On one of my screen having display - FormViewer and connected to sharepoint list - working fine.
on the same screen I have inserted table and trying to filter based on the one of the field of formViewer

when I am applying filter based on the primary field of the list, it is working fine
Filter(TblBreakDown,SubRecoNo=DataCardValue24.Text)

BUT when I am applying filter based on another field, it is not working, no result appears
Filter(TblBreakDown,FormNo=DataCardValue24.Text)

For testing purpose I put the numeric same value in the SubRecoNo and FormNo - like 1,2, 3 etc

Please advise, in both situation if numeric or text, how to apply filter on table based on the value of a field in the display viewer.

Below image for fast reference :

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@MIA27

Is your column defined as text or number?

If numeric, consider the following instead:

Filter(TblBreakDown, FormNo = Value(DataCardValue24.Text))

PowerApps will typically convert text to number and the other way around as needed, but sometimes this does not yield what you expect.

I hope this is helpful for you.

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Sorry, I tried, no error, no result.
The field in the list "FormNo" is numeric but as it is a lookup field, generally it get converted to Text when exported, This is the practical experienced I had and did correspondence for this strange change in community of sharepoint.

For the current screen situation, lets consider the FormNo as a text, then please advise what changes to be done to obtain the result

Was this reply helpful? Yes No
MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report
When you put
Value(DataCardValue24.Text)
into a label are you getting the value you expect?

If no, this is where your issue is, if yes then try this:
Filter(TblBreakDown, FormNo = {Value: DataCardValue24.Text})
I am suggesting that because you said it is a lookup field.

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Thank you for your advise,
I tried below on the label and it brings the perfect result

Value(DataCardValue24.Text)

Filter(TblBreakDown, FormNo=Value(DataCardValue24.Text))
No result found and no error.

Then tried your next tips
Filter(TblBreakDown, FormNo = {Value: DataCardValue24.Text})
This brings no record and no error.

Please advise

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report
Hi @MIA27 ,

Please try and find the Item property of the Form, copy it into the Filter:

Filter(TblBreakDown, FormNo = FormItem.FormNo) //FormItem refer to the formula within Form's Item property

Best regards,

Was this reply helpful? Yes No
Verified answer

MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report
In that case @MIA27 , try the following:

Filter(TblBreakDown, FormNo = FormItem.FormNo)
Replacing FormItem with you item you are trying to filter on, not DataCardValue24 but the name of that Item.

Was this reply helpful? Yes No
MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

@v-jefferni Sorry, I did not realise we had the same suggestion!

Was this reply helpful? Yes No