Set value of Dropdown on Form Submission

(0) Share

Report

Posted on by Marutha_K

Hi All,

Been spent a lot of time on setting a value of dropdown control while submitting the Power Form. Need suggestions/help.

App - Canvas app

Data Source - SharePoint List

Form type - Customized the default SharePoint new/edit form

I have a drop down field called Status from SharePoint list called Requests. I would like to set the value of the dropdown before the submit button is clicked so that the value of drop down also gets submitted while form is getting submitted.

Tried setting default values or DataCardValue29.Selected.Value ="Completed" but the value of the drop down didn't update or work as expected.

Any suggestions or help is appreciated

@RezaDorrani @WarrenBelz @LaurensM

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@Marutha_K - what is the data type for the Status field? Is it Single Line Text or Choice? Is your dropdown control a dropdown control or a Combo box ?

Was this reply helpful? Yes No
Marutha_K 51 on at

Like (0)

Report

Hi @Amik ,

It is a Choice field of type dropdown from SharePoint list as a data source.

I have tried multiple ways but couldn't accomplish it.
1. Setting the value of the dropdown before form submission
2. Setting the default value of the dropdown - but this may not work for my scenario since the previous value set as default value (in SharePoint list) itself gets affected - value of status changes depending upon the current user and upon multiple values entered & submitted

Hence am thinking it is correct to set the value of drop down before submission of the SharePoint form.

Was this reply helpful? Yes No
Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@Marutha_K - assuming it is a Combo Box, and you want the Default value of that Combo Box to be automatically set to "Completed" when the Form is in NewMode, apply the below to the DefaultSelectedItems property of the Combo Box:

If( 'Your Form'.Mode = FormMode.New, {Value: "Completed"}, Parent.Default )

Was this reply helpful? Yes No
Marutha_K 51 on at

Like (0)

Report

Hello @Amik
Thanks for the response. If I set the DefaultSelectedItems property then the previous value stored in this control gets affected - to explain further, I am trying to set the value of the combo box while the form is getting submitted but if I set the DefaultSelectedItems property then the previous value of the drop down which is displayed in the form gets affected.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@Marutha_K - the previous value would not be impacted because the formula suggested is only setting the default value if the Form is NewMode. If the Form is in EditMode, then the existing value is returned.

I have re-read your requirement several times, and unfortunately I cannot understand what it is you need.

Was this reply helpful? Yes No