web

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

News and Announcements icon

Power Platform CommunityForums Power Apps After selecting distin...

Power Apps

Answered

After selecting distinct value from dropdown box how to do update text value to reflect the ID from the sharepoint list record I am referencing

(0) Share

Report

Report

Posted on by h1970013

11

I have a list of customers and account number for each customer. Through the distinct function I am able to create a dropdown list to select from for all the available options in the SharePoint list. Based on that selection I would like to be able to do 2 things. 1. Populate a DataCardValue for the Customer ID from the SharePoint list as well as Cascade a second DropDown list that only shows the Account numbers that are tied to that Customer.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,714 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @h1970013 ,

The second Combo Box Items would be

Filter( SPList, Customer = FirstCombo.Selected.Value )

The ID

LookUp( SPList, Customer = FirstCombo.Selected.Value ).CustomerID

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
h1970013 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much. I am not quite sure why I wasn't seeing that.

Join the conversation