data from custom form not being submitted to SharePoint list

[CarlHRVA]

I have a custom form I created for a list in SharePoint that is not behaving as expected and I could really use some help! I have 4 choice columns in my list: State, Hotel Name, Inn Code and Facility ID. In my custom form, I've added a data source, edited the choices to come from my new data source(a Master Property List) and set up a cascading drop-down from State>Hotel>Inn Code + Facility ID. This all works as intended in the form in SharePoint but when I save my new entry all 4 fields come up blank. As a side note, there is a lot of data in the list/these columns but when I try to filter them I only receive the default choices(Enter Choice #1,Enter Choice #2,Enter Choice #3). Any help is greatly appreciated!

[v-xida-msft]

Hi @CarlHRVA ,

Could you please share more details about the formula you typed within the Items property of the State, Hotel Name, Inn Code and Facility ID Dropdown box (ComboBoxes) in your Edit form?

For your first question, do you enable "Allow Multiple" options for these Choice type fields in your SP list? I assume that these Choice fields are all Single one choice file. Please go to the Edit form (SharePointForm1) of your custom form app, then set the Update property of the State field data card to following:

StateComboBox.Selected.DisplayColumn

set the Update property of the Hotel Name field data card to following:

HotelNameComboBox.Selected.DisplayColumn

set the Update property of the Inn Code field data card to following:

InnCodeComboBox.Selected.DisplayColumn 

set the Update property of the Facility ID field data card to following:

FacilityIDComboBox.Selected.DisplayColumn

Note: The DisplayColumn represents the display column value within above Choice field ComboBoxes. If you Type Distinct formula within above ComboBox Items property, you need to modify above formula as below:

StateComboBox.Selected.Result

...

...

For your second question, the Filter functionality options related to the Choice fields in your SP List is based on the available options you provided for the Choice field in your SP List itself in default.

Best regards,

[CarlHRVA]

Thanks for your help! Yes, they are all only allowing one choice. IS it relevant that the columns we are looking up to are actually single line of text columns? I've been troubleshooting and changed the form a bit since this post. Now there are two formulas for State and Hotel Name. Inn Code and Facility ID are no longer working, I've screwed them up trying so many different things. It displays the correct Inn Code when I am in the formula bar but the dropdown displays nothing.

State:

Sort(Distinct('Master List',State),Result)

Hotel Name:

Distinct(Filter('Master Property List',State=DataCardValue22.Selected.Result),'Property (PIM Short Name)')

Inn Code:

Distinct(Filter('Master Property List','Property (PIM Short Name)'=DataCardValue23.Selected.Result),Inncode)

Facility ID:

Distinct(Filter('Master Property List','Property (PIM Short Name)'=DataCardValue23.Selected.Result),'Facility ID')

[CarlHRVA]

@v-xida-msft  Scratch that. The formulas for Inn Code and Facility ID are working again. I'm not sure what happened, they are exactly the same but they are working now. When I add DisplayColumn to the Update properties I get a "Name isn't valid. Identifier isn't recognized" error.

[v-xida-msft]

Hi @CarlHRVA ,

Could you please share a screenshot about your issue?

Does the formula works for the State ComboBox and Hotel Name ComboBox?

Please make sure you have specified "Result" column as display value column within your Inn Code ComboBox and Facility ID ComboBox.

I could not find any syntax error with the formulas you provided. You could consider modify your Inn Code Items formula to following:

Distinct(Filter('Master Property List','Property (PIM Short Name)'=DataCardValue23.Selected.Result),Inncode).Result

modify the Facility ID Items formula to following:

Distinct(Filter('Master Property List','Property (PIM Short Name)'=DataCardValue23.Selected.Result),'Facility ID').Result

then check if the proper value could be displayed within the ComboBoxes.

After that, take a try with the solution I provided in previous reply to update the Update property of the corresponding field data card in your Edit form, then check if the saved choice value could be saved into your SP List.

Best regards, 

[v-xida-msft]

Updated -- On your side, you should replace the DisplayColumn with actual column name from your ComboBoxes.

For Inn Code field data card Update property:

InnCodeComboBox.Selected.Result

For Facility ID field data card Update property to following:

FacilityIDComboBox.Selected.Result

Best regards, 

[CarlHRVA]

@v-xida-msfthere are my four columns, they're all working as intended now as far as cascading drop down. 

My problem now is that when I go into SharePoint, enter an item into the list and save it, these four columns values do not get input into the columns in the list. When I try to add .Result to the end of the Update properties, I get the error. I have a feeling this is because I'm using a different data source than the field was originally mapped too? I'm really not sure but I've been at this all night lol. Thanks so much for your help 

[CarlHRVA]

@v-xida-msft  Does it simplify things if these were look up columns? 

Currently they are choice columns in "Help Desk Ticket Log" or (List 1) where the form is being filled out and I am changing the Items property to get the items from a separate data source: Master Property List (List 2)

Would it be better if I used a look up column and avoid introducing a second data source?

[v-xida-msft]

Hi @CarlHRVA ,

Please modify the formula within the Update property of these Choice field data cards to following:

State field Data Card Update property:

{
   Value: StateComboBox.Selected.Result
}

Hotel Name field Data Card Update property:

{
 Value: HotelNameComboBox.Selected.Result
}

Inn Code field data card Update property:

{
 Value: InnCodeComboBox.Selected.Result
}

Facility ID field data card Update property:

{
 Value: FacilityIDComboBox.Selected.Result
}

Best regards,

[CarlHRVA]

I was able to add those formulas to the Update property but the values still aren't populating in the list when I use the form in SharePoint.