Answered

Submitform not saving one field to sharepoint list

(0) Share

Report

Posted on by Thrive

I have an app with a form tied to a SharePoint list. It has an edit form to pull up records and save them back to the list when the user makes changes. It was working fine for a whole year until last week. Oddly, nothing changed, app and SharePoint list were not modified.

App edit form has multiple dropdown boxes but only one is not saving changes to the list. There are two dropdown boxes that are related to each other: Service Area and Facility Area. User first selects a service area in the service area dropdown and it filters the options that appear in the Facility Area dropdown that are relevant to for the selected service area. The Facility Area dropdown is the one not saving back to the list. There's a save button on the form that triggers a submitform event. Help!!

Form: Frm_ProjectEdit --- and it is pointing to my project list on sharepoint

Save button: OnSelect: SubmitForm(Frm_ProjectEdit)

Service Area: DataCardValue48 --- corresponding sharepoint list column type is "lookup"

Facility Area: DataCardValue47 --- corresponding sharepoint list column type is "lookup"

In the Service Area, Update property is set to: DataCardValue48.selected

In the Facility Area, Update property is set to: DataCardValue47.selected

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 155,378 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Thrive ,

What is the Items of DataCardValue47

Was this reply helpful? Yes No
Thrive 34 on at

Like (0)

Report
Copy link

Link copied!

DataCardValue47 items filters the facility area choices depending on what is selected in DataCardValue48 (Service Area) and the relations are mapped by another list called Def_Facility_List.

ForAll(Distinct(Filter(Def_Facility_List, ServiceAreaName = DataCardValue48.Selected.Value), Facility), {Result: ThisRecord.Value})

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,378 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Thrive ,

Lookup columns in SharePoint are not the best idea to use at all with Power Apps, however that is another discussion. Your Data Card Update if I am reading your posts correctly should be

{ Value: DataCardValue47.Selected.Result, Id: LookUp( Def_Facility_List, Facility = DataCardValue47.Selected.Result ).ID }

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Thrive 34 on at

Like (0)

Report
Copy link

Link copied!

Thanks! This worked like a charm. Not sure why it was working fine for a whole year before breaking. Must be MS pushing updates.

Was this reply helpful? Yes No