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 :

All responses (7)

Answers (2)

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

Like (0)

Report

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

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

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

Like (0)

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

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.
Verified answer

v-jefferni on at

Like (1)

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

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,
MIA27 on at

Like (0)

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

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
MVP-Phipps 3,447 Super User 2024 Season 1 on at

Like (0)

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

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
MIA27 on at

Like (0)

Report

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

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
RandyHayes 76,287 Super User 2024 Season 1 on at

Like (0)

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

@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.