cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tscott07
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. 

 

13 REPLIES 13

I inserted this formula as well and nothing. 

ZabiBabar
Continued Contributor
Continued Contributor

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

@ZabiBabar 

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

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,373)