Forum Discussion

KMK82's avatar
KMK82
Copper Contributor
Jan 16, 2023
Solved

cannot see a list of new column created in sharepoint list

Hi, 

 

I have created a new column (Calculated), called "Overdue days" in sharepoint list.

Then, tried to set a new rule in Automate tab. 

Once I clicked "A column value changes" under "Create a rule", then I clicked "Choose a column". But I could not see  "Overdue days". 

I can see this column when I view the list in All items. 

Wondering why i cannot see it in the list in creating a rule. 

 

  • KMK82 You can find the list of supported/unsupported columns and more information about Rules feature in SharePoint at: Rules in SharePoint Online/Microsoft Lists 


    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.

2 Replies

  • KMK82 You can find the list of supported/unsupported columns and more information about Rules feature in SharePoint at: Rules in SharePoint Online/Microsoft Lists 


    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.

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    KMK82 you cannot use a calculated column in a rule which is why it doesn't appear in the list of columns. It's the same limitation within Power Automate where you cannot add a filter query using a calculated column.

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources