Answered

Dataverse Filtered Combo Box Error on Save

(0) Share

Report

Posted on by VJ-22072138-0

I have filtered a Dataverse Combobox as shown below and receive a error when the form is submitted/saved. If I remove the filter is works fine.

Items Filter:

Filter(Choices([@Projects].new_ItemValue2), EntCode = "PRO1" && Module="Project" && Prompt="Status").ItemValue

Itemvaluecard Update code:

DataCardValue26.Selected

Any help would be appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Syvenn your filter looks good but you will have to remove the .ItemValue at the end:

Filter(Choices([@Projects].new_ItemValue2), EntCode = "PRO1" && Module="Project" && Prompt="Status")

Click on the DropDown and change the DisplayFields and SearchFields property to ["ItemValue"]

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
VJ-22072138-0 53 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply. When I make the mods, the Combobox is now empty and the Display and Search fields default to ["cr965_name"]
Thanks

Was this reply helpful? Yes No
VJ-22072138-0 53 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply. When I make the mods, the Combobox is now empty and the Display and Search fields default to ["cr965_name"]
Thanks

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Syvenn you will have to change that value to the field you want to display.

I am guessing it will be:

["cr965_itemvalue"] //or ["ItemValue"]

Was this reply helpful? Yes No
VJ-22072138-0 53 on at

Like
a
(0)

Report
Copy link

Link copied!

Error message is gone, but the DB does not update with the selected combobox value

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Syvenn could you show me your code that you use to save it to Dataverse. Please also share what type of field you are trying to update (I probably expect a LookUp).

If it's a and edit form and you are using just the SubmitForm() function.

Is your Item and DataSource property value correct?

Was this reply helpful? Yes No
VJ-22072138-0 53 on at

Like
a
(0)

Report
Copy link

Link copied!

1. Code to save is the submit function: SubmitForm(ProjectDetailForm_3)
2. The field is a Lookup field
3. Item and Datasource are correct
It works ok if I remove the filter, but need the filter to populate the box with the correct data

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Syvenn thanks for the info!
Unfortunately I am unable to recreate that particular issue. I also added extensive filtering to my test scenario and was able to update that LookUp field.

When you use the filter without the .ItemValue at the end, normally the LookUp should populate.

Filter(Choices([@Projects].new_ItemValue2), EntCode = "PRO1" && Module="Project" && Prompt="Status")

Originally that will have caused the issue, because the selected value was the .ItemValue field and you need to patch a record.

Instead of typing the display name you can also change it by clicking on the DropDown, going to the property panel on the right and clicking edit display field:

If your value without the filter works and is Choices([@Projects].new_ItemValue2), I don't really see why the filtering would change the patch functionality.

Was this reply helpful? Yes No
VJ-22072138-0 53 on at

Like
a
(0)

Report
Copy link

Link copied!

The combo box populates ok. It doesn't save to the database. If filter is removed it does save.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Syvenn just for me to get a better understanding, did you test it now?
With removing the filter do you mean only leaving in Choices([@Projects].new_ItemValue2) or did it originally have another value?

Has anything else been changed in the data card or dropdown since your last test?

Was this reply helpful? Yes No