Combobox error?

(0) Share

Report

Posted on by NurNida

213

I suspect my combobox giving error while click on button cancel.

So far it works fine during submit, update data to sharepoint except cancel.

Shrepoint :

ReguStatus

Multiple lines of text

Button Cancel:

If(IsBlank(DataCardValue94_1.Text),
Notify("Pls enter remarks for cancellation in Audit trail section",NotificationType.Error),
Set(Action,"Cancelreq"); - powerautomate update status as cancelled
SubmitForm(Form2_1))

ReguStatus

Item:

SortByColumns( Filter( PR_Configuration, Lower(LookupKey2) = Lower("ProdRegulatory" & txtcmpny.Text) ),

"SortItem", Ascending)

Default :

Update: Concat(ComboBox2.SelectedItems, ItemDetails, ",")

DefaultSelectedItems:

RenameColumns(Filter(Split(Parent.Default, ";"), !IsBlank(Result)), "Result", "Value")

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NurNida ,

Please try below steps:

1. Update:

Concat(ComboBox2.SelectedItems, ItemDetails, ", ")

2. DefaultSelectedItems:

RenameColumns(Filter(Split(ThisIem.ReguStatus, ", "), !IsBlank(Result)), "Result", "ItemDetails")

Best regards,

Was this reply helpful? Yes No
NurNida 213 on at

Like
a
(0)

Report
Copy link

Link copied!

I try to use the default as per suggestion, my combobox return blank . Actually, I use this in my Edit form.

RenameColumns(Filter(Split(ThisIem.ReguStatus, ", "), !IsBlank(Result)), "Result", "ItemDetails")

This combobox load in Form Mode : view
I make this combobox edit and reseelect value , button cancel work as it is..

I realized it is because this combobox load (pic below) as one value and need to be split.
Not sure how to do this.

Was this reply helpful? Yes No
NurNida 213 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No