Default value for dropdown

(0) Share

Report

Posted on by Sri

559

Hi all,

I have a column called Reviewer role(Choice type) in gallery which loads values from SharePoint list(Gate tracker). There is another list called Gate Phase where Phase, Work Product and Reviewer role column will be selected and saved to Gate Phase list . When the user comes to this tracker gallery and when design and work product is selected the reviewer role should display automatically in the dropdown which will be collected from the Gate Phase list. The user must also be able to select other values from the dropdown and save to list. Both default and other value selection must be possible.

The items of the dropdown: Choices([@GatereviewPlan_tracker].'Reviewer Role')

Default value of the dropdown is : ThisItem.'Reviewer Role'.Value

I tried used lookup but I got error stating "expected text value."

Any help/suggestion on this.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Uthhra,

You have a ComboBox to displat reviewer role, so you need to set the DefaultSelectedItems property.

And what's more, the formula should be

ThisItem.'Reviewer Role'

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@v-qiaqi-msft
But When Phase is selected it must auto populate the respective reviewer role from another list. I have 2 list Gate tracker and gate phase.(For eg. for design the reviewer role value saved in Gate phase list is CS team) .When design is selected in gallery it must auto populate the CS team value in reviewer role dropdown and when user selects some other value in dropdown it must save the value and show the saved value also.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Uthhra,

Do you wat to populate CS team from Gate phase list when design is selected from phase dropdown?

Is this Phase the sharing column between both two lists?

How you set the Items proeprty of the phase drodpown?

Just based on your decription, modify your formula as below:

If(Phasedd.Selected.Value="Design",LookUp('Gate phase',Phase.Value=Phasedd.Selected.Value,'CS Team'),ThisItem.'Reviewer Role')

A little tip for you, sometimes we could only provide a direction based on limitted info we got from the topic, we could not imagine the scenario on your side, most of the time we need to study alone.

In a word, more details and more investigation.

Thanks for your cooperation.

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@v-qiaqi-msft ,
I have written the code in this way.
If(
phasedropdown.Selected.Result in Gate_Review_Phase.Phase,
LookUp(
Gate_Review_Phase,
Phase = phasedropdown.Selected.Result && 'Project Name' = prjnamesphs.Selected.ProjectName && 'Work Product/Process' = wrkprdpro_1.Selected.Result,
'Reviewer Role'
),
ThisItem.'Reviewer Role'
)
I selected the other value called Architect and it gets saved to the list but it is not displaying the saved value even though I gave ThisItem.'Reviewer Role'

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

HI @Uthhra,

Result from the Distinct() function in Power Apps has already been Deprecated for a long time, we use Value instead.

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@v-qiaqi-msft
Both Value and Result works fine for me. Now only the save value from list is not displaying. Even though it is getting saved in gallery it changes back to the lookup value and not the saved value.

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

so just to get it right in my head:

you want to choose Value A in a dropdown and it should automatically populate New York (example) in another dropdown. If thats the case i guess there are multiple selections in first dropdown and therefor multiple outputs in the second one?

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

@mmbr1606
For eg: List 1: Phase(column) - Design (Value) and Role(column) - CS team(Value) saved in Gate Phase list.
List 2: There is a gallery where when Phase is selected as Design that respective role( CS team) should auto populate in defaultselecteditems based on lookup from List1. If the user selects another role as architect it must save in List 2 and displayed the saved value. Bothe are single selections only.
I hope you get an idea now,

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

if i get u right (sorry if not) you want to build cascading dropdowns, right?

do you have a list where u oppose the values?

so lets say a list where u basically have 2 columns, 1 is title (there u store Architect for example) in column 2 you store the value that u want to show in dropdown (or field 2) such as a name or anything else.

doing it that way is the easiest you can do.

Create a dependent drop-down list in a canvas app - Power Apps | Microsoft Learn

maybe that article helps solving your issue

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No