web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Calculate column in co...

Power Apps

Answered

Calculate column in collection

(0) Share

Report

Report

Posted on by CSilva

I have an application where users will create a collection with several columns containing dates and times. At the end of the experience, I need to perform some calculations and fill in the remaining columns using the data collected. What formula can I use to go through the collection and perform calculations for each item and patch it to the correct column?

For example, I have columns titled "Check", "Check Out", and "Difference". What formula would I use to get the difference between "Check" and "Check Out" in the "Difference" column for each item in the collection?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @CSilva

You can use addcolumns to do this:
ClearCollect( NewCollection, AddColumns( YourCollection, // replace with your collection name "Difference", DateDiff(Check, CheckOut, TimeUnit.Minutes) // replace Minutes with Hours, Seconds, etc. as needed ) )
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Let the user fill the collection without your calculated values. For example the user will collect startDate and endDate.
They you can apply AddCollumns(yourcollection,"Mycalculation",DateDiff(startDate,endDate,days))

Was this reply helpful? Yes No

Join the conversation