Forum Discussion

barakathcs's avatar
barakathcs
Copper Contributor
Dec 01, 2022

Calculated Column

Hi there,

 

Can you anyone help me with the below questions?

 

1. How do I include a lookup column value in a calculated column?

 

2. Is it possible to generate an auto ID (via Power Automate) for the list that has many lookup columns from another list?

 

3. How do I use a calculated column (List B) for Lookup column filtering (from List A)? Condition like: If the item ID is selected from the lookup list (List B), it should auto-populate name of the item from the same lookup list on list A form.

 

 

microsoft lists
SharePoint Online

1 Reply

  • NicolasKheirallah's avatar
    NicolasKheirallah
    MVP
    Dec 02, 2022
    1. You don't, it's not supported. You need to do a work around using power automate and additional field and use that.

    2. You can get the last value or something and add to it via Power Automate.

    3. Same here, Recommend using power automate.

Resources