Combo Box Blank in Form Edit Mode

(0) Share

Report

Posted on by zerocool55

Hi Everyone,

I need you support regarding an issue I'm facing with 2 combo box I'm using in an edit form.

combo box item :

Filter(

PortfolioProjectList,

'Created By'.Email = VarUserEmail

)

in New mode, the combo box works fine and display all the projects filtered from another sharepoint list.

the form is successfully submitted and the value (single selection) is written in sharepoint list.

if I decide to edit the record in the form then the combo box doesn't display the value recorded in sharepoint. I've tried the change the Defaultselected items to : [Parent.Default] or {Value:ThisItem.Project} but the combo box will remain blank with no fault in the defaultselecteditems.

Any suggestion?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @zerocool55,

If you populate the ComboBox based on another SP list, I think that's the point causing your issue.

You need to retrieve the field value from the SP list that you used to populate the ComboBox with, like comparing the ThisItem.Field with the projects from another list.

Was this reply helpful? Yes No
zerocool55 94 on at

Like (0)

Report

Maybe I wasn't clear. The combo box works when I have the form in the new mode. I can't see the previously entered date when editing a record, as I have the dropdown with all options.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @zerocool55,

I know that.

"in New mode, the combo box works fine and display all the projects filtered from another sharepoint list."

I have mentioned that the data source you used to populate the ComboBox is the point, if it is another data source different with the one you used in the Form Item property, I think it is the key.

If this is not what happened in your scenario, please tell me that if PortfolioProjectList is the same data source you used to set the Item property of the form?

Was this reply helpful? Yes No
Verified answer

zerocool55 94 on at

Like (0)

Report

@v-qiaqi-msft

I managed to find a fix.
For the defaultselecteditems of combo box, I wrote the following:
LookUp(
PortfolioProjectList,
ProjectName = TaskDetailsList.Selected.Project
)
PREV
PREVI

Was this reply helpful? Yes No