Answered

Edit Form saves blank fields to sharepoint

(0) Share

Report

Posted on by awalker

233

My app keeps track of several different categories of information. They are in different screens but the screens are set up very similarly. One of the screens worked fine until May. I haven't needed it since then but will need to use it again starting January. Last week I went through to make sure everything was ready to go, but my edit form for the wellness program screen won't save all the data fields to sharepoint. Attached is a screenshot from the sharepoint list.

The "Description" field is not filling in.

The "Update" function for Description is DataCardValueDescription.Text

There is a combo box selection from another sharepoint source in the Description field of the edit form. The selection of this combo box fills in DataCardValueDescription.Text that gets saved to sharepoint.

Does anyone have advice on what to troubleshoot? I'm running out of ideas.

I've attached some screenshots of the app itself.

Categories:

Building Power Apps

All responses (10)

Answers (1)

Sort by

ChadVKealey 1,393 on at

Like
a
(1)

Report
Copy link

Link copied!

It looks like "ComboBox1" is directly overlaying the "DataCardValueDescription" text field, so it's hard to tell which control the data is actually appearing in. I'm not really sure why you have both controls there, but you could try setting the Update property for the card to "ComboBox1.Selected" (or possibly "ComboBox1.Selected.Text" - depending on what the Items property of that control is set to).
awalker 233 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, the "DataCardValueDescription" is behind the combo box. The reason for this is that the "Update" function does not accept "ComboBox2.SelectedItems.Text" or any variation available. It is looking for a text box, looks like.
awalker 233 on at

Like
a
(0)

Report
Copy link

Link copied!

I attached another screenshot with the "DataCardValueDescription" moved above the combo box to show the text does display in it.
ChadVKealey 1,393 on at

Like
a
(1)

Report
Copy link

Link copied!

It's looking for a text value, but that could be in a text input control, a label or the value selected in a combobox or dropdown control. What is the "Items" property for ComboBox1? This has to be a table, and the "SelectedItems" represents one or more records from that table that are selected, but you need to specify the column value from that table record to get the text value that the Update property is looking for.
awalker 233 on at

Like
a
(0)

Report
Copy link

Link copied!

So, here is where it gets a little squirly. The combobox "Items" is referencing another sharepoint list.
The edit from source is a list called "WellnessLog" while the "Description" combo box gives a selection of options from another sharepoint list called "AvailableOptions".
ChadVKealey 1,393 on at

Like
a
(1)

Report
Copy link

Link copied!

Also, since the ComboBox control allows multiple selections (or, rather, can allow multiple selections), it's output is always considered a table. So, even if you've set the "SelectMultiple" property to "false", you still need to treat the data as a table. So, try First(ComboBox1.SelectedItems).Value in the Update property.
awalker 233 on at

Like
a
(0)

Report
Copy link

Link copied!

I did not realize that. Helpful information. I tried First(ComboBox1.SelectedItems).Value but the app did not like it.
ChadVKealey 1,393 on at

Like
a
(1)

Report
Copy link

Link copied!

That's fine, PowerApps doesn't really care where the data comes from, only what shape it takes (table, record or value) and that you use the proper syntax to reference it. Understanding those different data forms is critical to really understanding how to work with the information in PowerApps.

So, if the field/column you're showing in that combobox is the "Title" field from that list (ie: the Items property is 'Available Options'.Title), then the text value you want to put into the Update property will be "First(ComboBox1.SelectedItems).Title".
awalker 233 on at

Like
a
(0)

Report
Copy link

Link copied!

Details. I forgot that the first column in sharepoint lists are always "Title".
The "Update" Function accepted "First(ComboBox1.SelectedItems).Title" but it still won't save the information into the "WellnessLog" list.
Verified answer

awalker 233 on at

Like
a
(0)

Report
Copy link

Link copied!

Turns out, something got corrupted in the EditForm data field. I had to delete the "Description" Field and re-build it. Now it works. No idea what it was. I duplicated the Edit form and recreated an identical data field to make sure it wasn't something I did. The duplicated form worked fine. It was a Powerapps quirk.