Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Creating a Dashboard using powerapps

I have a powerapp that the users input their data and it is working. 

Now i have a task to do some calculations about the data from the first powerapp.  I want to just display this so i created another powerapp that pulls the connection from the SharePoint list of the first powerapp. 


I need do some calculations but not sure how to get the data i need onto the fields. 


I am stuck on 3 calculations.


1. MTD (Est value) i need to only get the current month est value based upon that fields due date.  I thought i could filter by duedate, Month(Now()) to get the items date but it says  it expects a text value???  I thought I would get the est contract value label i have and then filter it by the due date?


I will start with  this can anyone help??? I am working on a deadline. 



I inserted this formula as well and nothing. 

Continued Contributor
Continued Contributor

What is the error that you get after inserting the formula?


No the error was before i entered the formula: 

Text(Sum(Filter('Estimating List', Text(DueDate,"[$-en-US]m-yy") = Text(Now(), "[$-en-US]m-yy")), EstContractValue)), "$#,###0.00"))


i currently do not have any errors. but there is no result. 

@WarrenBelz , @mdevaney 


Can you take a look at this formula and see what may be missing?

I need to sum the total for the items in this current month. 


Text(Sum(Filter('Estimating List', Text(DueDate,"[$-en-US]m-yy") = Text(Now(), "[$-en-US]m-yy")), EstContractValue)), "$#,###0.00"))


The due date field is a date field as 6/3/2020. estcontractvalue is a number field. 


Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (26,038)