[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:

General Questions

I have the same question (0)

All responses (12)

Answers (0)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

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

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()) } )

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (0)

Report

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

same issue

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

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

Please update to Source.Email

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

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

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()) } )

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (0)

Report

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

Hello Stalin,

Email is error it only has .Mail

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

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

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: ""})

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (0)

Report

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

Hello Stalin,

The items property of the combo box is

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

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

@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

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

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

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)

Was this reply helpful? Yes No