I've got a
current staff list with a
StartDate (datetime) column and two calculated columns: 'DaysWorkedAt', 'YearsWorkedAt'
I have an MS Flow workflow attached to the
new employee list on
new item created, it adds an entry to this list and performs the appropriate work adversaries calculation for the 2 columns mentioned above.
My formula for the calculated 'DaysAtCompany' is this:
Problem I have:
Adding a new entry via the interface to the
current staff list the calculation works.
Adding it via the new employee list through MS Flow the calculated columns has a value of
I can't seem to work out what is causing this or how to fix it. I am using the internal names correctly. I can't find any special characters getting inserted.
Attached an image for reference.