Collection vs Patch

(0) Share

Report

Posted on by R Bakker

725

Hi everyone

This works

Patch(BSInspections,Defaults(BSInspections),{StationNum:{Id:NumT.ID, Value:NumT.StationNumber}},{BaitLeft:BLeft},{BaitAdded:BAdded},{Faeces:FaecesYN},{InspectionDate:Today()})

But this does not

Collect(ColStation,{StationNum:{Id:NumT.ID, Value:NumT.StationNumber}},{BaitLeft:BLeft},{BaitAdded:BAdded},{Faeces:FaecesYN},{InspectionDate:Today()})

BLeft, BAdded, Faeces are true false Set() variables, Do Collections not like Set() variables? I'm not getting errors but the collection just shows the date and BLeft, BAdded, Faeces all as false.

Thank you for your time.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

timl 36,770 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Corissandageri

Syntactically, this formula adds a new record to BSInspections. It merges all the fields that you specify after Defaults(BSInspections) into a single new record.

Patch(BSInspections,Defaults(BSInspections),{StationNum:{Id:NumT.ID, Value:NumT.StationNumber}},{BaitLeft:BLeft},{BaitAdded:BAdded},{Faeces:FaecesYN},{InspectionDate:Today()})

In contrast, this function would add 5 records to the ColStation collection. Therefore, these two calls are not equivalent.

Collect(ColStation,{StationNum:{Id:NumT.ID, Value:NumT.StationNumber}},{BaitLeft:BLeft},{BaitAdded:BAdded},{Faeces:FaecesYN},{InspectionDate:Today()})

The formula beneath would behave the same as your Patch example.

Collect(ColStation, {StationNum:{Id:NumT.ID,Value:NumT.StationNumber}, BaitLeft:BLeft, BaitAdded:BAdded, Faeces:FaecesYN, InspectionDate:Today() } )

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

Thank you timl, this works well

Was this reply helpful? Yes No