Contents
In this section, we’ll list the unsupported columns that you can’t use in SharePoint Calculated Column Formula as well as SharePoint List Validation Settings. Although the SharePoint calculated column formula will accept the ID field without any error, however, it will not be calculated on item added or changed!
How to add a calculated column to a list?
To add a calculated column, click + add column then select More. Note: Calculated fields can only operate on their own row, so you can’t reference a value in another row, or columns contained in another list or library.
Why is the me not supported in the calculated column?
The [ME] is not supported in the Calculated Column, The available workaround is creating a workflow that set the value of the current user to a new single line of a text column, then use the value of the new text column in your calculated field formula.
Can a calculated field be referenced in another list?
Note: Calculated fields can only operate on their own row, so you can’t reference a value in another row, or columns contained in another list or library. Lookup fields are not supported in a formula, and the ID of newly inserted row can’t be used as the ID doesn’t exist when the formula is processed.
Although the SharePoint calculated column formula will accept the ID field without any error, however, it will not be calculated on item added or changed! As shown below, the ID Column is not listed in the available columns, it’s not supported!
How to get field values out of SharePoint?
Getting the field values out of SharePoint with Power Automate requires knowledge of both Microsoft technologies. When using Power Automate to trigger on SharePoint list items I often use the Initialize variable or preferably Compose action s to get the Field values of my list items.
Note: The List Calculated Column scope is the columns in the same row of the same list. you can’t use other columns from other lists / sites. you can’t use other columns from other rows in the same list.