Power Apps

Error on For All from Collection Patch

(0) Share

Report

Posted on by ctedesco3307

975

Hi All - SharePoint backed trying to patch update a value using the collection ID. I keep getting this

- the ID number is right - but it does not find it for some reason. What am I missing? ty

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

MS.Ragavendar 7,613 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@ctedesco3307,

ForAll( colvendorUpdates As rec, Patch( KPI_VendorList, LookUp( KPI_VendorList, ID = rec.ID ), { 'Last Service Date': dt_lastsdt.SelectedDate } ) )

(Or)

ForAll( colvendorUpdates As rec, Patch( KPI_VendorList, rec, { 'Last Service Date': dt_lastsdt.SelectedDate } ) )

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Suggested answer

11manish 3,849 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
try above suggested.

Based on the error message and your code, the most likely causes are:

ThisRecord.ID is stored as Text instead of Number

colVendorUpdates doesn't contain the SharePoint ID but another identifier.

colVendorUpdates was not built directly from KPI_VendorList, so ThisRecord isn't a valid SharePoint record.

Was this reply helpful? Yes No
ctedesco3307 975 on at

Like
a
(0)

Report
Copy link

Link copied!
This works if I update one record but not if I have more then one to update

ForAll( colvendorUpdates As rec, Patch( KPI_VendorList, LookUp( KPI_VendorList, ID = rec.ID ), { 'Last Service Date': dt_lastsdt.SelectedDate } ) )

This one does ot have an ID lookup reference - so wont work for my scenarios
ForAll( colvendorUpdates As rec, Patch( KPI_VendorList, rec, { 'Last Service Date': dt_lastsdt.SelectedDate } ) )

Was this reply helpful? Yes No
ctedesco3307 975 on at

Like
a
(0)

Report
Copy link

Link copied!
Based on the error message and your code, the most likely causes are:

ThisRecord.ID is stored as Text instead of Number ** I tried putting Value() around it but did not work

colVendorUpdates doesn't contain the SharePoint ID but another identifier. ** the SharePoint identifier is in there

colVendorUpdates was not built directly from KPI_VendorList, so ThisRecord isn't a valid SharePoint record. *** it is and it is a valid record.

Thank you

Was this reply helpful? Yes No