Combo box reset on record if value is removed from collection

(1) Share

Report

Posted on by nleuck_101

462

Hello All,

I need some help in resolving an issue with my combo box value resetting if that value is no longer in my collection. I have an app where injuries are assigned to specific safety specialist. The combo box is a collection from Office 365 Groups. There are some records that don't have a selection anymore because that original safety specialist that was assigned is no longer in the Office 365 group. But in the Dataverse the record still shows the original selection. Is there a way that if the value is not in the collection from the Office 365 group, it still can show the value that was original assigned in the combo box?

Here is my formula for the DefaultSelectedItems property: LookUp(collection, displayName = ThisItem.SafetySpecialist)

Any help would be greatly appreciated!

Categories:

Building Power Apps

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nleuck_101

To handle the scenario where your ComboBox’s DefaultSelectedItems is based on a collection from Office 365 Groups but the originally assigned value (e.g., Safety Specialist) is no longer in that collection, you can modify your formula to:

First try to find the matching record in the current collection.

If not found, create a fallback record with the original value so it still displays in the ComboBox.

If( !IsBlank(LookUp(collection, displayName = ThisItem.SafetySpecialist)), // If we find it in collection, return that record [LookUp(collection, displayName = ThisItem.SafetySpecialist)], // Else return a single-item table with a fallback record to show original value [{ displayName: ThisItem.SafetySpecialist, Id: Blank() }] )

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
nleuck_101 462 on at

Like
a
(1)

Report
Copy link

Link copied!

@Haque

Thank you for your response! It solved my issue.

Was this reply helpful? Yes No