Unanswered

Combox blank after running patch collection

(0) Share

Report

Posted on by Mawdman85

134

I have seen previous posts about this including replies from @WarrenBelz so understand this is a known issue but I cannot get the items property of the combo box to display the value after the patch. The patch to SP list is working fine.

The onchange propertys of my gallery fields is as follows:

If(ThisItem.ID in colVehExcUpdates.ID,

Update(colVehExcUpdates,

LookUp(colVehExcUpdates, ID = ThisItem.ID),

{

ID: ThisItem.ID,

ExceptionReason: VehExcReason.Selected,

VORReason: VORReason.Selected,

Comments: VehExcComments.Value,

ExceptionDate: VehExcStart.Value,

ExceptionEndDate: VehExcEnd.Value

}

Collect(colVehExcUpdates,

{

ID: ThisItem.ID,

ExceptionReason: VehExcReason.Selected,

VORReason: VORReason.Selected,

Comments: VehExcComments.Value,

ExceptionDate: VehExcStart.Value,

ExceptionEndDate: VehExcEnd.Value

}

))

I have a save icon to trigger the patch:

If(

CountRows(colVehExcUpdates) > 0,

Patch(

'IKEA Vehicle Exceptions',

colVehExcUpdates

);

Notify(

"Success",

NotificationType.Success

)

);

Clear(colVehExcUpdates);

I have set my defaultselecteditems of the combo box to

{ExceptionReason: ThisItem.ExceptionReason.Value} but it still shows blank after I trigger the save patch

Categories:

Building Power Apps

I have the same question (0)

All responses (39)

Answers (0)

Sort by

WarrenBelz 154,889 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Mawdman85 ,

Assuming you are reading from a multiple choice field and the output of your Combo Box (field displayed) is ExceptionReason

ForAll( ThisItem.ExceptionReason, {ExceptionReason: Value} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Mawdman85 134 on at

Like (0)

Report
Copy link

Link copied!

It's giving me an invalid arguments error

ExceptionReason is the column in the SP list that it's mapped to (proven by setting Items to ThisItem.ExceptionReason which works fine, just when the patch function is called it removes the value from the combo box)

Was this reply helpful? Yes No
WarrenBelz 154,889 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Mawdman85 ,

As I noted, it was based on the assumptions I could determine from your post. So I need to know

What type of field is ExceptionReason and if a Choice is it single or multi-value

I see the Items of your Combo Box is ThisItem.ExceptionReason - is it single or multiple choice ?

Was this reply helpful? Yes No
Mawdman85 134 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Thanks for the response

It's a single choice field

Was this reply helpful? Yes No
WarrenBelz 154,889 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Mawdman85 ,

If the Update of the data card is (and works)

ExceptionReason: VehExcReason.Selected

and this is all single choice, then the DefaultSeletedItems would simply be

ThisItem.ExceptionReason

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Mawdman85 134 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

I don't have an update property for this combo box. The onchange property is set to update the collection.

It's a combobox within a gallery so there's no datacard involved.

I'm also using powerapps for teams in case that makes any difference...

Was this reply helpful? Yes No
WarrenBelz 154,889 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Mawdman85 ,

Does not really matter - (I missed the reference to the gallery, but the principle is the same). What is the Items of the Combo Box (which I assume is single selection)

Was this reply helpful? Yes No
Mawdman85 134 on at

Like (0)

Report
Copy link

Link copied!

it is indeed single selection @WarrenBelz

items property is:
Choices('Table Vehicle Exceptions'.ExceptionReason)

Was this reply helpful? Yes No
WarrenBelz 154,889 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Mawdman85 ,

Earlier, you said the Items was

ThisItem.ExceptionReason

now you are saying

Choices('Table Vehicle Exceptions'.ExceptionReason)

please confirm which and also the Items of the gallery

Was this reply helpful? Yes No
Mawdman85 134 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
The Items property for the gallery is:
SortByColumns(Filter('Table Vehicle Exceptions', 'Vehicle Reg' = VehicleGallery.Selected.'Vehicle Reg'), "ExceptionDate", SortOrder.Descending)

items property for the combo box is
Choices('IKEA Vehicle Exceptions'.ExceptionReason)

DefaultSelectedItems property of the combo box is ThisItem.ExceptionReason

Was this reply helpful? Yes No