Unable to patch multiple records in sharepoint through gallery

(1) Share

Report

Posted on by aayaanmayank

248

Hi Everyone,

Can someone plsssss help me on this? i have sepnt hrs but unable to solve. i have tried all the way but nothing worked. I want to update records in sharepoint list through gallery, as i have repeated column projectIDs and IDs are repeated, then against each Project there are more then 4 milestones and each milestone has start and end date. i want to update multiple dates at once but only able to update one row item at once.

this is the formula i am using to save the records.

If(IsBlank(Patch(TS_Project_Milestones,
LookUp(TS_Project_Milestones, Project_ID = Gallery4.Selected.Project_ID && Milestone = Gallery4.Selected.Milestone),
{
Start_Date: DatePicker1.SelectedDate,
End_Date: DatePicker1_1.SelectedDate
}
))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @aayaanmayank, Try this:

ForAll(Gallery4.AllItems As Var, Patch(TS_Project_Milestones, LookUp(TS_Project_Milestones, Project_ID = Var.Project_ID && Milestone = Var.Milestone ), { Start_Date: DatePicker1.SelectedDate, End_Date: DatePicker1_1.SelectedDate } ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Thanks,
ANB

Was this reply helpful? Yes No
aayaanmayank 248 on at

Like (0)

Report
Copy link

Link copied!

hi thanks for trying but this is updating one date across all the date picker for that projectID.

Was this reply helpful? Yes No
ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @aayaanmayank, The code should work if Milestone is added in AND condition with Project ID.

Try this:

Patch(TS_Project_Milestones, ForAll(Gallery4.AllItems, { Start_Date: DatePicker1.SelectedDate, End_Date: DatePicker1_1.SelectedDate } ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Thanks,
ANB

Was this reply helpful? Yes No