Feel like this should be way easier than I'm making it but I can't get this to work. I want to calculate a running total of the values in a column called Hours in a SharePoint list. This column may or may not be empty. Here is what my flow is doing
1. Initialize variable (runningTotal, Float type)
2. Get items from SharePoint list
3. Apply to each value (from Get items)
4. Increment variable runningTotal, Value = Hours (from Dynamic content)
Issue is that the runningTotal is the evaulating to the total number of the items in the list. When I walk through the loop, it increments by 1 for each item in the SP list from Get items
I tried adding a Condition to attempt to only add when the Hours field is not null, but I don't think I'm doing that right with the new Flow upates. I tried Hours is greater than 0, which failed on the items where Hours was null. I tried Hours is not equal to '' which still counted everything.
Any suggestions?