PowerApps自定义SharePoint表单级联下拉新建记录报错求助

Hey there! Let's figure out why your cascading dropdown setup works for editing existing items but blocks new record creation—all while keeping your current PowerApps workflow intact, since your team is already comfortable with it.

First, Let's Break Down the Core Issue #

When editing an existing record, PowerApps pulls in pre-filled values for your category and subcategory, so the dropdowns have valid selections right away. But when creating a new record, the form starts blank, and small gaps in your dropdown logic or form setup can prevent SharePoint from accepting the submission.

Common Fixes to Try #

1. Fix the Subcategory Dropdown's Empty State #

Your current formula Distinct(Filter(CategoryandSubCategory,Title = CategoryComboBox.Selected.Value),SubCategory) returns an empty set when no category is selected. If your subcategory field is marked as required (either in SharePoint or PowerApps), this will block new submissions because the form can't pass a valid value.

How to fix it:

• Update your subcategory dropdown's Items property to handle blank category selections:

  If(
      IsBlank(CategoryComboBox.Selected.Value),
      {SubCategory: "Please select a category first"}, // Add a placeholder option
      Distinct(Filter(CategoryandSubCategory, Title = CategoryComboBox.Selected.Value), SubCategory)
  )
  

• Add validation to your submit button to ensure both dropdowns have valid selections before submitting:

  If(
      IsBlank(CategoryComboBox.Selected.Value) || SubCategoryComboBox.Selected.Value = "Please select a category first",
      Notify("You must select both a category and subcategory", NotificationType.Error),
      SubmitForm(YourSharePointFormName)
  )
  

2. Verify Form Field Binding for New Records #

Make sure your subcategory data card is correctly mapped to the dropdown's selected value when in "New" mode:

• Open the subcategory DataCard, check its Update property—it should be set to SubCategoryComboBox.Selected.Value (not a static value or existing record reference).
• Confirm the Default property for the DataCard handles the blank new record state:

  If(
      YourSharePointFormName.Mode = FormMode.New,
      "", // Blank for new records
      ThisItem.SubCategory // Use existing value for edits
  )
  

3. Disable the Submit Button Until Valid Selections Are Made #

Prevent accidental empty submissions by locking the submit button until both dropdowns have valid values:

• Set your submit button's DisplayMode property to:

  If(
      !IsBlank(CategoryComboBox.Selected.Value) && !IsBlank(SubCategoryComboBox.Selected.Value) && SubCategoryComboBox.Selected.Value <> "Please select a category first",
      DisplayMode.Edit,
      DisplayMode.Disabled
  )
  

4. Check SharePoint List Field Settings #

Double-check if your subcategory field in SharePoint is marked as Required:

• If it is, make sure your PowerApps form enforces this (either via the dropdown validation above, or by keeping the DataCard's Required property set to true).
• If it doesn't need to be required, you can toggle the "Required" setting off in SharePoint list settings to remove the submission block.

Quick Test to Validate #

1. Go to your form, switch to "New" mode.
2. Select a category—confirm the subcategory dropdown loads valid options.
3. Select a subcategory, then click submit. If it works, you've fixed the issue!

内容的提问来源于stack exchange，提问作者Rajendra Prasad