Answered

combox selection does not change

(0) Share

Report

Posted on by StuCundy

377

Hi There
I have a customized sharepoint list form with a combobox selecting SchoolTitle. Combox name is SchoolTitleComboBox

DefaultSelectedItems:{Title: ThisItem.SchoolTitle}

SelectMultiple : false
Card Update: SchoolTitleComboBox.Selected.Title

When the initial selection is made it saves to the list. When I go to change the selection is reverts back to the first choice and does not allow me to make a change. Anythoughts?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StuCundy ,
They look OK - what are the Items of the ComboBox?

Was this reply helpful? Yes No
StuCundy 377 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz

Thanks for your reply.
If( //This is for All and All SchoolTypeDD.Selected.Result="Select School Type",SCHOOLS, //This is for selected School Types SchoolTypeDD.Selected.Result<>"Select School Type", Filter(SCHOOLS, SchoolType.Value = SchoolTypeDD.Selected.Result) )
The items are filtered with a dropdown as I needed to split a large list but essentially the data source "Schools"

Was this reply helpful? Yes No
WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @StuCundy ,
I am not sure this is the issue, but try this
If( SchoolTypeDD.Selected.Result="Select School Type", SCHOOLS.Title, Filter( SCHOOLS, SchoolType.Value = SchoolTypeDD.Selected.Result ).Title )
This will produce a list with a single field Title in each case, which matches your DataCard Update.

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.

Was this reply helpful? Yes No
StuCundy 377 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
That made no change. I wonder if it is because I'm suing Title, maybe just SchoolName maybe better as it is one of my columns?

Was this reply helpful? Yes No
WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks @StuCundy ,
The Update of the DataCard has to match the value that is contained in the drop-down. What is the field name from the DataSource of the DataCard and what type of field is it?
If you type in the Items of the Combo Box
SchoolTitleComboBox.Selected.
what values come up underneath as valid choices? Put each one in (it there are more than one) and see if the list is the same as in your data field.

Was this reply helpful? Yes No
StuCundy 377 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
I have changed the search and displayfield to be SchoolName. Also Changed update to SchoolTitleComboBox.Selected.SchoolName
I did stop at the . and only the SchoolName was an option.

I cant think of anything else....

Was this reply helpful? Yes No
WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@StuCundy ,
So if the Items were
If( SchoolTypeDD.Selected.Result="Select School Type", SCHOOLS.SchoolName, Filter( SCHOOLS, SchoolType.Value = SchoolTypeDD.Selected.Result ).SchoolName )
and the Update
SchoolTitleComboBox.Selected.SchoolName
You still did not say what type of field was linked to the DataCard

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.

Was this reply helpful? Yes No
StuCundy 377 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
Just Single line of text

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
OK @StuCundy ,
Now we have all the bases covered, this really should not be difficult save for one Power Apps glitch I have struck befiore.
If you put this in the Items
Filter( SCHOOLS, SchoolType.Value = SchoolTypeDD.Selected.Result ).SchoolName
and this in the Update of the card
SchoolTitleComboBox.Selected.SchoolName
and the DefaultSelectedItems
{SchoolName: ThisItem.SchoolTitle}
does the field update?

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.

Was this reply helpful? Yes No
StuCundy 377 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz
Thank you. It is working and updating now. I closed things and reopened and things just came right but I did use your most recent suggestions too although my filter for Items worked fine.

If( SchoolTypeDD.Selected.Result="Select School Type", SCHOOLS.SchoolName, Filter( SCHOOLS, SchoolType.Value = SchoolTypeDD.Selected.Result ).SchoolName )

Was this reply helpful? Yes No