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 Modifi...
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