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

I inserted this formula as well and nothing. 

Highlighted
Continued Contributor
Continued Contributor

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

Highlighted

@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. 

Highlighted

@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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (12,554)