web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter SharePoint 2 co...

Power Apps

Unanswered

Filter SharePoint 2 columns in the list and retrieve the value of 3rd column to powerapps label

(0) Share

Report

Report

Posted on by SudhaLearner

I have 3 columns in SharePoint

Example A, B,C values are

1 2 3

4 5 6

I have to filter only A and B and that should retrieve value of C to the text property of label

Filter(mylist, Column A = dcValue1.selected, Column B = dcValue2.selected).ColumnC

Need help in syntax

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

v-mengmli-msft on at

Like (0)

Report
Hi @SudhaLearner ,

Where do you put the formula on?

Filter(mylist, Column A = dcValue1.selected, Column B = dcValue2.selected).ColumnC

Filter function returns a table. So, the formula should be on properties which expects table, such as Items.

If you want to show all values of a column in Text of label, please try this:

Concat(Filter(mylist, Column A = dcValue1.selected, Column B = dcValue2.selected),ColumnC,";")

Best regards,

Rimmon

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
hey @SudhaLearner

you can also try this approach if the one suggested above does not work:

LookUp(mylist, 'Column A' = dcValue1.Selected.Value && 'Column B' = dcValue2.Selected.Value, ColumnC)

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No

Join the conversation