You’re offline. This is a read only version of the page.
Announcements
122
Has a SharePoint list with column for date and cost. Want to select, from Date, and to Date, to retrieve the sum from cost in this period, to a textbox in powerapps. Anyone have an idea, or a youtube video link?
Hi @ENRM,
You can filter down your SP list based on the date range, then wrap that in a Sum function, aggregating on the Cost column value.
Sum(Filter(ListName, DateColumnName >= fromDate.SelectedDate AND DateColumnName <= toDate.SelectedDate), CostColumnName)
---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
Share
Report
All responses (
Answers (
