Fill a ComboBox according to a value

(0) Share

Report

Posted on by Axel49

Hello !

I work on an application linked with a SharePoint list.

I have a Label, which is pre-filled by an ID I send from another screen:

LookUp('Maintenance DI',ID_Demande = lblIdDemandePass.Text, ID_Demande)

This return the value of ID_Demande corresponding to lblIdDemandePass.

My problem is that I want to do the same in a comboBox, but it doesn't work:

I want to do this in a comboBox because the user can choose between some choices.

But I also need to pre-fill the field if there is already a value corresponding to my ID_Demande.

How can I do to put value by default according to an ID in a comboBox?

Thanks in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Axel49 ,

Two things here - the code you posted does not need the lookup as you are simply returning the same value as the Label (so why bother?). Also you did not post the Items of the Combo Box, but you need the DefaultSelectedItems to refer to the Table field displayed, so whatever ComboBox.Selected.xxxx is, you need

{xxxx: lblIdDemandePass.Text}

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

Was this reply helpful? Yes No
Axel49 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your answer.
The Items of my comboBox is "Service".

But I need to show in my comboBox the value of "Service", when lblIdDemandePass.Text is equal to my ID_Demande.
For exemple, if my ID_Demande is 7, in my SharePoint list the "Service" corresponding to this ID is ABC.
So the comboBox need to display ABC.

I don't know if it's enought clear for you 🙂

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Axel49 ,

Yes, but you have not provided the Items of the Combo Box, so I will use xxxx again for the DefaultSelectedItems

{ xxxx: LookUp( 'Maintenance DI', ID_Demande = lblIdDemandePass.Text ).Service }

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

Was this reply helpful? Yes No
Axel49 26 on at

Like
a
(0)

Report
Copy link

Link copied!
I don't understand why did you mean by Items, this?
And so for the DefaultSelectedItems I do this:
{ Service: LookUp( 'Maintenance DI', ID_Demande = lblIdDemandePass.Text ).Service }
But it doesn't seem to work sorry.

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Axel49 ,

You simply need to replace xxxx with the field name that is displayed in the Combo Box - is Service a data source or field name ?

Was this reply helpful? Yes No
Axel49 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Service is a data source, it's the name of my SharePoint list.
The name of the comboBox is cmbService.

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Axel49 ,

OK I will try asking the question in a different way - what is the field name displayed in your Combo Box so that when you refer to it (ComboBox.Selected.xxxx) it is xxxx (if Service is the name of your Data Source, what is the field name in it you are displaying). Quite simply that needs to be xxxx in the formula and yyyy is the field you are querying in your lookup in 'Maintenance DI'

{ xxxx: LookUp( 'Maintenance DI', ID_Demande = lblIdDemandePass.Text ).yyyy }

Was this reply helpful? Yes No
Axel49 26 on at

Like
a
(0)

Report
Copy link

Link copied!
Okay I got it, the fact is that is the same name for both:

cmbService.Selected.Service

This is what I use when I want to refer to my comboBox.
And also the name of my field in my list is Service. So it look like this:
{ Service: LookUp( 'Maintenance DI', ID_Demande = lblIdDemandePass.Text ).Service }

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Axel49 ,

See if it works, but there is potential for Ambiguity doing what you have - you may have to rename one of them - you will need to delete and add a new one as Power Apps remembers the original name.

Was this reply helpful? Yes No