web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Get value from lookup ...
Power Apps
Answered

Get value from lookup column, based on filter of lookup collum

(0) ShareShare
ReportReport
Posted on by 24

i have 3 SharePoint lists (Processes, Systems & SystemsClassifications)

In list SystemsClassifications i have a lookup collumns for Systems and Processes. 

 

i want to fill a dropdown whit the systems used for that proces.

 

In my application i catch the Proces in a variable from a gallary whit source:

Set(Var_Scr_Proces, Gal_Processes.Selected)

 

I have set a filter on my dropdownlist as Items

Filter('SystemsClassifications',Proces.Value = Var_Scr_Proces.Title)

 

I can see the "Value" properties and the correct records in the filter.

But i can't see the system field in the value property, or if i change the Filter('SystemsClassifications',Proces.Value = Var_Scr_Proces.Title).System.

 

It won't work, problebly cause the values are records. 

How can i get those values of the system field?

 

ps: (its a single value lookup collumn)

 

 

Kind regards,

 

Categories:
I have the same question (0)
  • Verified answer
    RD Profile Picture
    24 on at

    I figgured it out:. Had to create a collection and and collect for all records the system value

     

    Clear(Col_Proces_Systems);

    ForAll(Filter('SystemsClassifications',Proces.Value = Var_Scr_Proces.Title))

    Collect(Col_Proces_Systems,{System: System.Value}));

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard