Forum Discussion
Date Column - if, then, else
I want to add a File Expiry date on documents only. In other words, if Content Type is a Folder, then File Expiration should equal Last Modified date. Otherwise File Expirations should be Last Modified + 90 days.
I am new to SharePoint - but in my mind, the following makes sense, but of course it is not working.
if [Content Type]='Folder',[Last Modified], [Last Modified]+90
Thank you
Using Content Type Column in Calculated Column Formula is not supported.
Here only possible approach to set Expiration Date using Power Automate.
Reference Link: https://www.c-sharpcorner.com/blogs/when-an-item-or-file-is-modified-trigger-for-sharepoint-connector
Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community
