Unanswered

SharePoint List Integration Form is Saving but Edited Columns Won't Save

(0) Share

Report

Posted on by SolarFlare2023

Hey all I'm working on editing a SharePoint List Form and am running into an issue where the SharePoint columns are not updating with the selected values. The form is saving new forms and edited forms and other non-edited columns are saving correctly.

Both DataCard's update functions are dropdownbox1.selected and combobox1.selected and the data fields are both correctly labeled for their respective columns ("column name").

Dropdownbox1 item formula is: Distinct(choices([datasource].column), value)

ComboBox 1 item formula is: Filter(Datasource, column = dropdownbox1.selected.value && Status = "text").Column

The one inconsistency that I've been able to find based on the documentation is that my SharePointForm1 Item is currently "If(IsBlank(SharePointIntegration.selected), First([DataSource]), SharePointIntegration.Selected)"
Based on the documentation for understanding SharePoint Forms Integration done by powerapps I'm supposed to use this formula

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

I've been unable to figure out why the IsEmpty isn't working and it's the only thing I can find that's inconsistent with the documentation. I thought that since the other unedited fields were saving it was a problem with the Dropdownbox1 and/or ComboBox1, but I can't figure out the problem. Please let me know if there are any other things I've not mentioned that I should be checking.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 152,967 Most Valuable Professional on at

Like (0)

Report
Hi @SolarFlare2023 ,

The second Update assuming you are writing back to a single choice column would be

{Value: ComboBox1.Selected.ColumnName}

Can you please confirm the column types you are writing back to

Was this reply helpful? Yes No
SolarFlare2023 2 on at

Like (0)

Report

It is a look up column and that did not work for the update.

Was this reply helpful? Yes No
WarrenBelz 152,967 Most Valuable Professional on at

Like (0)

Report
@SolarFlare2023 ,

This gets more complex and is one of the many reasons you should consider using Lookup columns at all. You need to “get back” the Id column with (using the list and field being looked up)

{ Value: ComboBox1.Selected.ColumnName, Id: LookUp( YourLookedUpList, YourLookedUpField = ComboBox1.Selected.ColumnName ).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