Unanswered

Sharepoint list editted form in PowerApps is setting some values to "Blank"

(0) Share

Report

Posted on by WorkingRicardo

878

So I have a Sharepoint list that I edited through PowerApps. 2 Columns (Product and Client) are set as text columns, even though in the PowerApps are actually a Combobox (The datacard is set to update with what you select). These Comboboxes take their options from an Excel file (I know Excel is terrible data source, but I'm forced to use it and have not managed a way to do otherwise).

Even though the Excel table has 30k+ items, I have no trouble searching for even the 31kth item, so no problem there, as I can save whatever you select and it will add a new row for the list.

The problem is when you are going to edit an already added entry to the list: one combobox is empty and the other one has the value of whatever you picked last. And for some reason that second one will be higlighted when you select the List entry, even before clicking the edit button.

I have tried with smaller Excel files and the same issue remains, it will save the Sharepoint data, but when you are editing, it will just remain blank.

My guess was the error would have to do with any of the Default properties of the Combobox... But no luck there, I didn't edit them and they are as they would be when you create the element.

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

MudassarSZ365 591 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WorkingRicardo ,
Default Property: For each ComboBox that is showing incorrect values, set the Default property to match the expected value from the SharePoint list item
DefaultSelectedItems = LookUp(Choices(SharePointListName.ColumnName), Value = Parent.Default)
Use ClearCollect: If the Excel file is large, consider using the ClearCollect function to cache the items in a local collection to improve performance:
ClearCollect(LocalProducts, ExcelDataSource)
Check for Errors: Use the Errors function to check if there are any errors related to the data submission to SharePoint:
Errors(SharePointListName)
If the provided guidance helps you resolve the issue with your SharePoint list form, please mark it as the solution and leave a thumbs up. Thank you! 😊
WorkingRicardo 878 on at

Like
a
(0)

Report
Copy link

Link copied!
Wait I'm confused on this one:

DefaultSelectedItems = LookUp(Choices(SharePointListName.ColumnName), Value = Parent.Default)

The product column is not a Choice column, it's a text value column. In powerApps I inserted the comboBox and mapped the Update property of the data card to put the selected item. So, in this case, what would I have to type in DefaultSelectedItems for Product?
Using ChatGPT I managed to get this formula:

If(IsBlank(Parent.Default); Blank();Filter(Wilo_Iberica_S_A__Item;Producto = Parent.Default))

It has no errors but it is still leaving blank that item when I edit for some items in the Excel column. Here I might be running into trouble because of the Excel file, as I tried same formula in different App and Excel file of 20k rows, and it works for all I tried (10, but all worked). It also has some loading time... As I assume that its looking for what was selected. Isn't there a way to hardcode what you select as text for that column? And please dont say Patch T_T... I tried coding that and could never get it to work.

The whole If is Blank thing I had to add because if I tried with just filter it had errors. Also, my PowerApps uses ";" as separator.
Furthermore, for Client I already have something typed in, as this Combobox determines another value with the use of "Coalesce(locSelectedClient)" and in On Change "UpdateContext({locSelectedClient: Self.Selected})"

For DefaltSelectedItems, how would I type in both formulas?
Further test revealed that Excel is not the problem, tried with a list of Sharepoint for the options, and nope, also can't get it to save forever the data in the list