I apologize for not being detailed with this question.
First I wanted to ask how do you mention people in this new forum? It seems like @ doesnt seem to work.
I have mentioned in my most recent reply that the combo box is indeed using
Choices for it
item property.
I appreciate you being patient with me.
I got the formula to work for me now.
My problem is that I need it to iterate over my collection called colAttachmentParticipants which is a collection I created using this formula
ClearCollect(
colExistingAttachmentParticipant,
Filter(AttachmentParticipants, ContractID = locCurrentRecord.ID )
);
How will I iterate over this and patch each of the items Participant? Should I use UpdateIf here?
With(
{
_Current:
LookUp(
colExistingAttachmentParticipant,
ID = locCurrentRecord.ID,
ReviewParticipants
),
_New: ReviewParticipantsDataCardValue7_Edit.SelectedItems
},
With(
{
_Update:
Ungroup(
ForAll(
_Current As _C,
Filter(
_New,
_C.Email in Email
)
),
Value
)
},
ForAll(
colExistingAttachmentParticipant As CurrentAttachmentItem,
Patch(
AttachmentParticipants,
{
ReviewParticipants:
ForAll(
_Update As _U,
{
Claims: _U.Claims,
Department: _U.Department,
DisplayName: _U.DisplayName,
Email: _U.Email,
JobTitle: _U.JobTitle,
Picture: _U.Picture
}
)
}
)
)
)//attachment participant patching inner with end bracket
);//attachment participant patching outer with end bracket
