Function stopped working

[Danny_L]

Hey all,

I have a Sum and Filter function on one of my data cards that all of a sudden stopped working. It was working this morning.

Basically what it does is it will search through my data source (Excel File on OneDrive) and looks for:

Qty Completed based on Work Order. Our end users will work on a work order at different times of the day and I added this so that they know how many have already been done. Here is the code:

Sum(Filter(Mechanical, Work_x0020_Order_x0020__x0023_ = DataCardValue5.Text),Value(Qty_x0020_Completed))

It was populating this morning and now it is not. No clue why. Anyone have any thoughts??

[mdevaney]

@Danny_L 
Can you try refreshing the datasource?  Or deleting/re-adding the connector?

Did the permissions change? (Go-check, don't just assume).  Any errors or warnings?

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Danny_L]

Refreshed - no change

deleted/readded - no change

checked permissions - all the same

no errors anywhere

Weird!

[mdevaney]

@Danny_L 
If you start a blank app and try it again from scratch does it work?

[Danny_L]

Created a new app and it still does not work. 

[Danny_L · Accepted solution]

Talked to MS. My formula was incorrect. I had to change it to this:

Sum(Filter(Mechanical, 'Work Order #' = DataCardValue5.Text),Value('Total Qty.'))

Instead of Total Qty, I had Qty Completed as I thought the value would be populated there which is why I chose it. Once I made that change, it worked.