web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Dropdown which shows 3...

Power Apps

Answered

Dropdown which shows 3 connected Lookup Columns

(0) Share

Report

Report

Posted on by Sven4

211

Hi guys,

i have a SharePoint List with one Lookup Column and 3 Columns they are related to the one lookup column.

For example:

The lookup column: Customer_ID

The related column: Customer_ID: Firstname

The related column: Customer_ID: Lastname

I now would like a dropdown to show both columns.

For example: 1 - Hans Zimmer

How can I reach this?

Thanks

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Sven4 - one method:

AddColumns( Choices([@'Your List'].LookupStage), Combined, With( { _get_record: LookUp( 'Your Lookup List', ID = Id ) }, Id & " - " & _get_record.Firstname & " " & _get_record.Lastname ) )

Note that the AddColumns function is not delegable.
Sven4 211 on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik Thanks for your help. And thanks for the information about delegability. Unfortunately, I need that.
So I will do it differently and set up a gallery for it.
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Sven4 - I should have caveated that you will be fine here. I doubt you will have more than 2000 options (the max delegation limit) in that Choice field.

Join the conversation