set default value in SharePoint form for SharePOint list item

(0) Share

Report

Posted on by kouliscon

247

hello,

I have modified the SharePointIntegration form for my SharePoint list in order to have three screens (New, Edit, View)

I would like two values to get default values when a new item is created only and those columns are:

- Status

- Evaluation

I understand I have to add a variable at the OnSave, currently I have:

- If(SharePointFormMode="CreateForm", SubmitForm(FormNew), If(SharePointFormMode="EditForm", SubmitForm(FormEdit)))

can someone tell me how to modify the above formula?

thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @kouliscon ,
You do this with the Default of the control. Yours is fairly easy as you have a separate new form. On this form, set the Default of the controls containing Status and Evaluation to the desired values.

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
kouliscon 247 on at

Like (0)

Report

@WarrenBelz below are the existing formulas:
- onSave: If(SharePointFormMode="CreateForm", SubmitForm(FormNew), If(SharePointFormMode="EditForm", SubmitForm(FormEdit)))
- Default of Status datacard: If(IsBlank(VarStatus),ThisItem.Status,VarStatus)

can you please modify with a variable that is if new to set the value "In Progress" at Status field?

thank you

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @kouliscon ,
You have a separate form for new records, you just need to set the Default of the Status control on that form to the value you need.
The save is irrelevant for this exercise.

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
kouliscon 247 on at

Like (0)

Report

@WarrenBelzcan you assist with formula?

this is what I have on the Status control at the default currently:

If(IsBlank("In Progress"),ThisItem.Status)

thank you

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @kouliscon ,
It is not a formula - you have a separate form for new records. If you wanted the Default value of Status to be "All Done" then the Default of the status control on the new form would be "All Done"

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
v-xida-msft on at

Like (0)

Report
Hi @kouliscon ,

Could you please share a bit more about the "Status" column and "Evaluation" column? Are they both Choice type column?

Do you want to set default value for the "Status" column and "Evaluation" column when your Edit form is in New mode?

Based on the needs that you mentioned, I think it is not necessary to set up variable to store the default value for your "Status" column and "Evaluation" column.

I assume that the "Status" column and "Evaluation" column are both Choice type column in your SP List, I have made a test on my side, please consider take a try with the following workaround:

Go to your FormNew, set the DefaultSelectedItems property of the "Status" ComboBox to following:

If( FormNew.Mode = FormMode.New, { Value: "In Progress" }, Parent.Default )

set the DefaultSelectedItems property of the "Evaluation" ComboBox to following:

If( FormNew.Mode = FormMode.New, { Value: "Specific Value xxxx" // type specific value here }, Parent.Default )

Please consider take a try with above solution, hopes it could solve your problem.

Best regards,

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report
@WarrenBelz I followed your advice and didn't do anything with the Save as you said, I just added at the Default of the status datacard the following: LookUp(Choices('SPListName'.SPFieldName),Value="SpecificValue") and that did the job.

@v-xida-msftthe columns are:
status: choice column of "in Progress", "Completed", "Cancelled"
Evaluation: text field
have another post "value-to-appear-at-a-field-based-on-a-value-from-another-field" as I would like the Evaluation field to get a specific text if the choice completed is selected at the status field.

thx

any ides?

Was this reply helpful? Yes No