Unanswered

How to keep values in Editform when editing an entry

(0) Share

Report

Posted on by fsabatier

Hi,
I have created an Inventory app. I have an EditForm Edit screen to edit entries from My SharePoint list. In my app, the SharePoint list is viewed with a vertical gallery, when selecting an entry, it goes into the details screen, you can then tap the Edit icon to go into the Edit screen and edit those details. You can also add new entries. I have 2 issues. The form is functional, but:

When editing an entry > Navigate(EditingScreen1) - The Datacard value of the current selection blanks out, this only occurs with Datacards with Comboboxes:
- The ComboBox Item property is set to the dropdown choices. This is the formula:
  - ["Text1", "Text2", "Text3", etc.].
- For this case, I'd like the Datacard to retrieve their information from the SharePoint List when entering the EditScreen. The SharePoint List columns are Single Line of Text type columns. How do you best set the Combobox property to retrieve the Single Line of Text data and be able to show all values in the drop-down selection?
I have the same issue for the Datacard with a Barcode Reader, but in this case, when going to the EditScreen, the Datacard resets with the last value the Barcode Reader reads. I want the Datacard to retrieve data from the SharePoint list while having the ability to Scan and enter a new value. The formula I have for the Datacard with Barcode Reader button:
- Barcode Reader -
  - OnScan property: Set(VarBarcode,FirstN(Self.Barcodes))
- DatacardValue -
  - Default property: First(BarcodeReader1.Barcodes).Value
- The SharePoint list column type is Single Line of Text.

Any way to make this functional? Let me know if I'm not clear with my explanation above.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

hasnainhaider68 47 on at

Like (0)

Report
It sounds like you're encountering a couple of issues related to data binding and default values in PowerApps when working with SharePoint lists and forms
Combobox Data Binding in Edit Form
You want to populate the ComboBox in an EditForm with values from a SharePoint list column that contains single-line text. To achieve this, you need to set the ComboBox's Items property to the values from your SharePoint list.
Here's how you can do that:
Select the ComboBox control inside your EditForm on the Edit screen.
In the formula bar, set the Items property of the ComboBox to your SharePoint list column. If your SharePoint list is called "MyList" and the column is called "MyColumn", the formula would be:
Items = MyList.MyColumn
Additionally, make sure to set the DefaultSelectedItems property of the ComboBox to the value you want pre-selected when you're editing an existing item. If the selected item's value is stored in a variable called SelectedValue, the formula would be:
DefaultSelectedItems = LookUp(ComboBox.Items, Value = SelectedValue)

Was this reply helpful? Yes No
WorkingRicardo 818 on at

Like (0)

Report

Hey @fsabatier @hasnainhaider68 was there ever a solution to this? I'm having the same problem, (comboboxes going blank when you go to edit them in sharepont). Altough I only have one scree set up for my app, so when you are editing it uses the same one you would use for creating new entries

Was this reply helpful? Yes No