Answered

Sharepoint list item going blank (even with a code that workd before)

(0) Share

Report

Posted on by WorkingRicardo

818

I'm using Excel as a source of a Combobox to send to a Text column in Sharepoint. The way the Items is configured is like this, as I need to filter first the Excel table (and show the full table should nothing be selected in another combobox):

If(
 IsBlank(DataCardValue11.Selected.Value);
 Contactos; // Si DataCardValue1.Selected.Value está vacío, devuelve toda la tabla sin filtro
 Filter(Contactos; Departamento = DataCardValue11.Selected.Value)
)

The DefaultSelectedItems property of this combobox is this:

{NameOfColumn: Parent.Default}

Default property of DataCard:

ThisItem.ColumnName

And this does save what you pick to the Sharepoint list, but if you go to edit, it will go blank... And it's extremely weird, as I have an exact thing for another column (excel table that needs to be filtered to a text column), same code same everything, and that one is saving, at first it wasn't but I wasn't using the:

{NameOfColumn: Parent.Default}

Both combobox/datacards have the exact same code so I'm stumped in figuring out what's wrong.

Any ideas D:?!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report
Hi @WorkingRicardo ,

Since you are using the entire or a part of excel table as the data source of Combo box, either selected item or default item should have exact same structure as the table. Now you are using {NameOfColumn: Parent.Default}, which makes them different.

First, please modify the Items of Combo box and simplify it:

Filter(Contactos; IsBlank(DataCardValue11.Selected.Value) || Departamento = DataCardValue11.Selected.Value)

Second, DefaultSelectedItems need to get a record from the table based on the criteria:

LookUp(Contactos; ColumnName = Parent.Default)

Best regards,

Was this reply helpful? Yes No
WorkingRicardo 818 on at

Like (0)

Report
hey @v-jefferni ty for your reply. The DefaultSelectedItems formula worked =D
Altough for the simplified Items formula I'm getting a Delegation warning, is that bad? The source of info doesnt have that much data, about 70 rows.

Edit: altough when nothing is selected (like when creating new item), i'm getting a "DisplayName" eq Null not supported error. (DisplayName is the Column name in the code of
LookUp(Contactos; ColumnName = Parent.Default)
LookUp(Contactos; ColumnName = Parent.Default)

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @WorkingRicardo ,

As long as the data source items won't exceed the number settings of data row limit, it doesn't matter.

Best regards

Was this reply helpful? Yes No