web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to use filter with...

Power Apps

Answered

How to use filter with lookup column in SPO

(0) Share

Report

Report

Posted on by pegdown

5

hello.

My canvas has two dropdowns("Dep" dropdown1 and "DepDetail" dropdown2).

I hope "DepDetail" is filtered by "Dep" value.

So I have two SPO lists "Dep" list and "DepDetail" list."DepDetail" list contains "Depdetail" column as titile and "Dep" column as lookup column which refers "Dep" column of "Dep" list.

I wrote a code in ITEMS that
Filter(DepDetail,dep.Valu=DropDown1.SelectedText.Value.

but it doesn't work,and occurrs an errors "dep column doesnt exit in SPO List or deleted."

but "dep" column exists in SPO LIST.

What's wrong?

Please help.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @pegdown

Please try:

Filter(DepDetail,Dep.Value=Dropdown1.Selected.Dep).Depdetail

Best Regards,

Levi
pegdown 5 on at

Like
a
(0)

Report
Copy link

Link copied!

I got it.
Very Thanks.

When I make SPO lists with English column name,there are no probrems.
When I make SPO lists with Japanese KANJI column name ,Apps says " not exist column"
One month or two month ago , There were no probrem by using KANJI column.
Has MS chaneged Specification of "KANJI columns"?

NG
OK
SPO List

Join the conversation