Feb 28 2022 07:38 AM
Hi,
I have a rather odd issue and I'm struggling to figure out what is happening. I have a very simple setup in a document library which has 3 columns: -
Last Reviewed | Frequency (months) | Review Date |
28/02/2022 | 12 | 28/2/2023 |
The last column Review Date needed to be calculated based on Last Reviewed and Frequency. I previously got this working ok but using calculated date doesn't help when using Flow. I have therefore deleted the field and tried to recreate it but the calculated field is still doing the calculation even though no formulas are present. I'm very confused, so any help would be appreciated
Regards
Chris
Feb 28 2022 07:44 AM
@Chris_Loxley-Watkins it's probably caused by your local cache. Do ctrl+r about 8 times and see if that clears it.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Feb 28 2022 07:52 AM
@RobElliott thanks for the quick reply, I was hoping that was it but I have cleared the cache and tried using In Private mode and it's still calculating the value
Feb 28 2022 09:38 AM
@Chris_Loxley-Watkins Are you using Date and Time column or calculated column, can you confirm? Question title says calculated column & the image attached in your above reply shows the Date and time column.
Where are you doing the calculations exactly? Check if there are there any workflows/flows running behind the scene on this list which are causing update to list fields.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Mar 01 2022 01:44 AM
Mar 01 2022 02:38 AM