web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Data from sharepoint c...
Power Apps
Unanswered

Data from sharepoint column

(0) ShareShare
ReportReport
Posted on by 122

7F992230-2589-44A4-A1AE-85E7D3ED0110.jpeg

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?

I have the same question (0)
  • Verified answer
    ChrisPiasecki Profile Picture
    6,422 Most Valuable Professional on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard