Unanswered

SharePointIntegration Custom Form Not Populating Default Values

(1) Share

Report

Posted on by snwboarder159

Please Note: I am using the SharePoint Integration to customize the form layout. This is different than creating a completely new form from scratch.

Issue: The customized form grabs the default values for some columns, but not others when clicking New form. Number and Text fields populate with the default values, but dropdown menus do not. Attached screenshot shows menu fields in Red that do not populate defaults, while the number fields at the bottom (Green checkmarks) do populate.

Background:

Under the EditForm-->Advanced tab-->Item field, I have entered the below formula (see 2nd screenshot). This has successfully pulled in the default values for Text and Number fields, but not for Dropdown menus.

If(IsBlank(SharePointIntegration.Selected), Defaults('LIST_NAME'),SharePointIntegration.Selected)

The DefaultMode is set to FromMode.Edit, but this has not impacted Text and Number fields from populating the default values.

Question: How can I get the default values to populate for dropdown menus? I also want these default values to be set within the SharePoint List Column directly, not through hardcoding values in the custom form.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report

Re: SharePointIntegration Custom Form Not Populating Default Values

Hi @snwboarder159, Are you using Dropdown or combo box control?

If it is combo box then DefaultSelectedItems property should be updated.

And if it is dropdown then Default property need to be updated.

For the exact code, you have to share more on the data type of the columns Contract Status and Term Length (Yrs)

Sharing few post for the same. Have a look on them:

https://powerusers.microsoft.com/t5/Building-Power-Apps/combobox-default-selected-items/td-p/2277986

https://powerusers.microsoft.com/t5/Building-Power-Apps/Combo-Box-DefaultselectedItems-value-from-text-field/td-p/1977460

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
snwboarder159 20 on at

Like (1)

Report

Re: SharePointIntegration Custom Form Not Populating Default Values

ANB - These are both Choice columns with Drop-Down Menu display. Attaching images for both. I do see that Drop-Down fields have slightly different options than the number/text fields due...namely they have added a 'DefaultSelectedItems' field that does not exist for the other fields. In the number/text fields the 'Default' is set to Parent.Default. Do I simply need to add this manually to the same section for the Drop-Down fields?

It's odd (though not that odd for Microsoft) that other than the one customized formula I mentioned previously, no other manual changes were made and defaults still populated for number/text fields.

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report
Re: SharePointIntegration Custom Form Not Populating Default Values

@snwboarder159 DefaultSelectedItems should be this: You might have to unlock the datacard in which these combo box are present.

LookUp(Choices('SPListName'.SPFieldName),Value="SpecificValue")

Remember to replace 'SPListName' and 'SPFieldName' with the actual SP List name and Field name, and "SpecificValue" with the choice value you would like to set as default.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
snwboarder159 20 on at

Like (1)

Report

Re: SharePointIntegration Custom Form Not Populating Default Values

Thank you! So to clarify, there is no way to connect the Default Value to the one maintained within the SharePoint column? I was hoping to be able to manage default values from within the SharePoint Column Properties and not within the custom form properties. This is how the number/text fields are currently working.

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report

Re: SharePointIntegration Custom Form Not Populating Default Values

@snwboarder159 If you are leveraging the SP form as it is. I mean that these combo box is not added by you as custom control then OOTB defaultselecteditems should work.

In my example, CH is choice column. The default value of DataCard is ThisItem.CH

And the combo box DefaultSelectedItems is

So this is working as expected.

What is the item property of your form?

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report
Re: SharePointIntegration Custom Form Not Populating Default Values

@snwboarder159 The item property should be this: I just saw in your screenshot. You are using Defaults

If(IsBlank(SharePointIntegration.Selected),First([@NameOfList]),SharePointIntegration.Selected)

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
snwboarder159 20 on at

Like (1)

Report

Re: SharePointIntegration Custom Form Not Populating Default Values

ANB - I am leveraging the standard SharePoint form and only utilizing the custom form for visual/formatting changes. There is only 1 form (the original SharePoint default form) and I then use a combination of columns and blank datacards to position the fields. The only non-visual change I did was to the Item properties for the EditForm and that was simply to change from using the First() formula to using Defaults() - see below.

FROM: If(IsBlank(SharePointIntegration.Selected), First('LIST_NAME'),SharePointIntegration.Selected)
TO: If(IsBlank(SharePointIntegration.Selected), Defaults('LIST_NAME'),SharePointIntegration.Selected)

See field setup below. This is the same as you have it, but yet my defaults are not showing up for drop-down menus. This is my frustration. By all accounts it should work, but it's not. I thought I may be missing something as I am still very new to this.

Was this reply helpful? Yes No
snwboarder159 20 on at

Like (1)

Report

Re: SharePointIntegration Custom Form Not Populating Default Values

ANB - When 'First([@NameOfList])' was being used, then NO defaults populated. They only began to populate AFTER I changed it to 'Defaults('NameOfList').

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report
Re: SharePointIntegration Custom Form Not Populating Default Values

@snwboarder159 This is strange. Can you try this:

If( IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected), First('*YourListName*'), SharePointIntegration.Selected )

If this doesn't resolves then please follow the MS article:

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-form-integration

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
snwboarder159 20 on at

Like (1)

Report

Re: SharePointIntegration Custom Form Not Populating Default Values

ANB - Thanks for your help. Unfortunately, that did not work either. I get an error when I input it. Which is weird as this exact formula is listed on Microsoft's help page you linked. I'll keep playing with it and see if I can figure something out.

Was this reply helpful? Yes No