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??
Solved! Go to 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.
@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."
Refreshed - no change
deleted/readded - no change
checked permissions - all the same
no errors anywhere
Weird!
Created a new app and it still does not work.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
162 | |
91 | |
67 | |
63 | |
63 |
User | Count |
---|---|
216 | |
158 | |
96 | |
86 | |
79 |