[HELP] - Patch Combo box with Multi Choice Column SPList

(0) Share

Report

Posted on by YamiteKudasai

195

Hi Everyone,

I have a list of person named Tag. When I click edit btn in power apps i saved it on a variable named varComments = ThisItem.Tag

On the DefaultSelectedItems of the combo box i put varComments.Tag.DisplayName

But when I patch I'm having a runtime-error.

This is my patch code for update

The error I found is that claims is not found on update. How to correct this?

when edit mode in combo box

Categories:

Building Power Apps

All responses (12)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @YamiteKudasai

Please try this
Patch( Comments, LookUp( Comments, ID = varComments.ID && varComments.'Created By'.Email = gvCurrentUserEmail), { Comment: comment_txtbox.Text, Tag: ForAll( comments_cmbox.SelectedItems As Source, { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Source.Mail, Department: "", DisplayName: Source.DisplayName, Email: Source.Mail, JobTitle: "", Picture: "" } ), timestamp: Text(Now()) } )
YamiteKudasai 195 on at

Like
a
(0)

Report
Copy link

Link copied!

same issue
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Please update to Source.Email
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @YamiteKudasai

I just verified it and it should be an .Email. If we use Azure AD as a Combo box list then use .Mail

Patch( Comments, LookUp( Comments, ID = varComments.ID && varComments.'Created By'.Email = gvCurrentUserEmail), { Comment: comment_txtbox.Text, Tag: ForAll( comments_cmbox.SelectedItems As Source, { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Source.Email, Department: "", DisplayName: Source.DisplayName, Email: Source.Email, JobTitle: "", Picture: "" } ), timestamp: Text(Now()) } )
YamiteKudasai 195 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Stalin,

Email is error it only has .Mail
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @YamiteKudasai

Please share the Items property of the ComboBox.

In general, a person can be filled with Person column or AD either
Choices(SPList.ColumnName)

Or
Office365Users.SearchUser({searchTerm: ""})
YamiteKudasai 195 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Stalin,

The items property of the combo box is
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@YamiteKudasai

I made the same Items property like yours and works fine
Patch( IssueTracker, LookUp( IssueTracker, ID = 1 ), { MultiplePeople: ForAll( ComboBoxSearchUserv2.SelectedItems As Source, { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Source.Mail, Department: "", DisplayName: "", Email: Source.Mail, JobTitle: "", Picture: "" } ) } )

Note:
1. Make sure to change Source.Mail on 2 places
Claims: "i:0#.f|membership|" & Source.Mail,
Email: Source.Mail,
2. I hope in Sharepoint the field tag allows multi-select Person field
YamiteKudasai 195 on at

Like
a
(0)

Report
Copy link

Link copied!

By the way stalin this is my sharepoint settings for column tag

This is the DefaultSelectedItems of my combo box
And still get same error about claims. I think the claims for the data from SP still empty. But claims in SP has values
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
SharePoint Settings looks good.

Other troubleshoot items.
Remove the SharePoint connection and add it back
Create a new column and try the same code (If #1 option not works)