Auto Populate Fields on selection of Customer Name

(1) Share

Report

Posted on by Prem4253

697

Hi,

See below table for reference.

I'm looking to auto populate the Code fields into the form as per customer name selection. We'll be naming all the fields with the code names mentioned in "Code" column into SharePoint which will act as Cascading dropdowns.

Customer Name	Code
Apple	WB0017
Apple	WB0018
Apple	WB0019
Apple	WB0020
Apple	WB0021
Apple	WB0023
Apple	WB0022
Apple	WB0024
BlackBerry	WB0025
BlackBerry	WB0026
BlackBerry	WB0027

For Instance: when we select Apple from Customer Name field, than WB0017 to WB0024 fields should get visible and than allow users to enter values only for this fields.

Similarly when BlackBerry is selected, WB0025 to WB0027 fields should get visible and than allow users to enter values for this fields.

Any ideas how we can achieve this. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hey

this vodeo should answer all questions:

Cascading Dropdowns in Power Apps from SharePoint list or Excel - YouTube

if it worked please mark as verified

thanks

Was this reply helpful? Yes No
nleuck_101 462 on at

Like (1)

Report
Copy link

Link copied!

This is what I use. Hope it helps. The sort is only if you want to sort your Code column and the Distinct is if you have duplicate values. If you don't need them you should be fine with just the Filter part.

Sort(
Distinct(

Filter(
SharePoint List name,

'Customer Name'.Value = ComboBox.Selected.Value (or it could be a dropdown)
),
Code

),
Value

)

Was this reply helpful? Yes No
Verified answer

cfoenki 100 on at

Like (0)

Report
Copy link

Link copied!

Hi, if I summerize, you have a list of correspondance between custom names and field codes and another list with field codes as column names.

I just tried and here is the result

If it is what you need, in your form you need to add the following code in the "Visible" property of each field with a code:

LookUp(AppleBlackBerry,Code=Self.DisplayName).Title=First(DataCardValue12.SelectedItems).Value

In my example my correspondance list is AppleBlackBery and I lookup inside the column code and verify if the return value for Customer Name (in my example column Title) is equal to the Customer Name filled in the app.

It only works if a field code is assigned to only one Customer Name.

If not, you need to add another formula:

!IsBlank(LookUp(Filter(AppleBlackBerry,Code=Self.DisplayName),Title=First(DataCardValue12.SelectedItems).Value))

Was this reply helpful? Yes No
Prem4253 697 on at

Like (0)

Report
Copy link

Link copied!

@cfoenki

Your post fulfills my end, but when I'm adding the code to my form, it is giving the error and I'm also not able to select last syntax of the formula.

My Supplier Name field shows Distinct Names (have used the below code in Items property)

Sort( Distinct('SupplierDetails',Title),Value) ------- SupplierDetails is the SharePoint list name

Cold Rolled Steel is a text column added from a SharePoint list (named as Commodities)

Can you please advise. Thanks!

Was this reply helpful? Yes No
Prem4253 697 on at

Like (0)

Report
Copy link

Link copied!

@cfoenki

Please if you can advise further. I'm still not able to fix this.

Below is my SharePoint list (used for LookUp)

I've added a field (DataCardValue26) into my form.

Was this reply helpful? Yes No
cfoenki 100 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Sorry for late reply, I forgot to activate the notification of replies ...

Can you share the full sharepoint architecture and your application form architecture and your formula? Espescially where you have a red mark on the formula.

The screenshot you provided is truncated.

Was this reply helpful? Yes No