web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patch gallery items do...
Power Apps
Answered

Patch gallery items does not patch combobox selected items

(0) ShareShare
ReportReport
Posted on by 29

I have a gallery that based on the selected items patches the records to sharepoint. The two comboboxes, company and privileges values are from other lists in sharepoint and I want to convert these ones into text during the patch.

The record title is created but the company and privileges are not been patched, if I only check one record, for example BPCS. If I select more than one, the first one patches correctly but the last one selected is missing the company selected and privileges.

My gallery:

isantos_0-1648271044345.png

isantos_2-1648272450269.png

 

//OnCheck checkbox6:

ClearCollect(
TempSpecialAccountsCol,
Filter(
ASSpecialAccountsGallery.AllItems,
Checkbox6.Value = true
))

//Patch in bold the two fields with issues

/*Special Accounts */
ForAll(TempSpecialAccountsCol,
Patch('NewHire Requests',Defaults('NewHire Requests'),
{
Title:ThisRecord.Title,
NewHireID:VarNewHireSandboxID,
RequestStatus:{Value:"Not Started"},

Request_x0020_Subtype:Concat(ThisRecord.cmbSubType.SelectedItems,Subtype , ","),
RequestClass:Concat(ThisRecord.cmbClass.SelectedItems,Title , ","),
UserGroup:Label55.Text,
SupportTeam:LookUp(UserGroups,Title=Label55.Text,UserList)

}));

 

//SharePoint List showing record after patch, Request SubType and RequestClass are missing

isantos_1-1648272282210.png

 

Strange that if more than one option is selected it patches all correctly with company and permissions except the last one selected from the gallery.

I have spent so much time on this and can't find the problem.

Hope someone has an idea on the issue.

Thanks

I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @isantos :

    Please try:

    ForAll(
     Filter(ASSpecialAccountsGallery.AllItems,Checkbox6.Value = true),
     Patch(
     'NewHire Requests',
     Defaults('NewHire Requests'),
     {
     Title:ThisRecord.Title,
     NewHireID:VarNewHireSandboxID,
     RequestStatus:{Value:"Not Started"},
     Request_x0020_Subtype:Concat(ThisRecord.cmbSubType.SelectedItems,Subtype , ","),
     RequestClass:Concat(ThisRecord.cmbClass.SelectedItems,Title , ","),
     UserGroup:Label55.Text,
     SupportTeam:LookUp(UserGroups,Title=Label55.Text,UserList)
     }
     )
    );

    Best Regards,

    Bof

  • isantos Profile Picture
    29 on at

    Thank you very much Bof for taking the time and providing me with a solution.

    Have a great day

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard