default combo box value not recognized by SubmitForm

(0) Share

Report

Posted on by lumberjacklurch

455

Hey all,

I've got a form that is fed by a gallery. I have it set up so when you click on a button, a pop-up with the form in it is pre-populated by the selected gallery item's properties. I was even able to get the default value to work for the combo box in the form. But now I have another problem. The default value is not recognized by SubmitForm because the value was not "selected", it was put there by default. If you were to click on the combo box and select the same value as the default, then it recogizes it (because it was selected). How can I get SubmitForm to recognize the Default value or the selected value in the Update parameter of the form?

Thanks!

Categories:

Building Power Apps

All responses (13)

Answers (1)

Sort by

lumberjacklurch 455 on at

Like
a
(0)

Report
Copy link

Link copied!

Just to clarify, this has to do with the DefaultSelectedItems property, not the Default property of the combo box
Rebetcha 645 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lumberjacklurch ,
Can you include some screen shots and the formulas you use in your scenario?
The DefaultSelectedItem property is the correct property. Based on just your description it is hard to figure out the issue.
lumberjacklurch 455 on at

Like
a
(0)

Report
Copy link

Link copied!

Sure. Attached is a screenshot of the form, and below is the DefaultSelectedItems code.

{Value: RequestReviewGallery.Selected.'Training Subject'}

This is the Item value for the combo box:

col_CurrentUserSubjs.Title
- defined by: ClearCollect(col_TrainingSubjects, SortByColumns(Subjects, "ID", Ascending));
ClearCollect(col_CurrentUserSubjs, Filter(col_TrainingSubjects, var_CurrentUserEmail in Approver.Email))

The datasource is the same as the gallery, a SPO list named Requests.

The Update property for the combo box's datacard is combo_ApprTrainingSubjectValue.Selected.Title

Let me know if you need more.
Rebetcha 645 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lumberjacklurch ,

I think you should be able to use RequestReviewGallery.Selected in the DefaultSelectedItems based on your statement the root data source of both the gallery and the collections used for the combobox items are the same SPO List.
You can use the DisplayFields property of the ComboBox to display the correct field of the selected record.
lumberjacklurch 455 on at

Like
a
(0)

Report
Copy link

Link copied!

Rebetcha,
Thank you for the reply.
I'm sorry, I'm still new to powerapps, so I don't fully understand what you said.
I AM using the RequestReviewGallery.Selected.X in my Default SelectedItems property:
{Value: RequestReviewGallery.Selected.'Drexel Subject'}
Currently, my DisplayFields property for the combo box is ["Title"]. I'm not sure if that helps me.

My main issue is the combo box's DefaultSelectedItems value is not recognized by SubmitForm. I don't see how that helps the issue, but [like I said] I'm new to this.
Rebetcha 645 on at

Like
a
(0)

Report
Copy link

Link copied!

No problem.

What I mean is: why not change the {Value: RequestReviewGallery.Selected.'Drexel Subject'} in RequestReviewGallery.Selected.
With the {} and the Value: you sort of create a record. But RequestReviewGallery.Selected allready is a record in it self. Depending on the data sources used in the RequestReviewGallery and the items property of the ComboBox this should work.
In the DefaulSelectedItems property you need to add information about what records provided in the Items property should be selected by default. The only thing you have to make sure of is that both data sets follow the same schema (Columns, Column types, etc).
lumberjacklurch 455 on at

Like
a
(0)

Report
Copy link

Link copied!

Rebetcha,
I put RequestReviewGallery.Selected.'Training Subject' (Training, not Drexel) into the DefaultSelectedItems property.

I get an error, "The property experts Table values, but this rule produces inompatible Text values."
Rebetcha 645 on at

Like
a
(0)

Report
Copy link

Link copied!

Skip the .'Training Subject' part.
Literally only add RequestReviewGallery.Selected . You reference the whole record in that way. With the .'Training Subject' attached you reference only the field contents of that specific field.
lumberjacklurch 455 on at

Like
a
(0)

Report
Copy link

Link copied!

I got rid of the 'Training Subject' part, but now the the title of the record is showing up in the combo box, not the Training Subject. I saw that the DisplayFields property is set to ["Title"], but it won't let me change it. Everytime I change it, it changes back if I click away from it.
Rebetcha 645 on at

Like
a
(0)

Report
Copy link

Link copied!

What type of column is the Training Subject column??