Forum Discussion

Jsanjur's avatar
Jsanjur
Copper Contributor
Jul 15, 2021

Options instead of lookup fields

Hi all, 

 

In my organization due to the need i had on my department, created a new Sharepoint List to handle the tickets from our users.  Ive created basically a ticketing system using MS Forms + Power Automate + Sharepoint list. Some other departments with the same needs we interested in the system and started doing the same.  

 

Between departments we usually share the same infomation, like "area", or "team" or "role"  and what we were facing is that once a new team was added we had to manually change all the lists to add it, we have over 20 lists and was starting to get a bit more complicated, therefore i decided to use lookup fields .. so for all those items like area, teams or roles i created different list on the list i just have lookup fields and we only have to update on one list instead of 20.

 

The problem im facing and the reason of this post is because im encountering some limitations using lookup fields, like, i cannot use them on formulas or wont work on choice or person fields etc.

 

Is theres a way that i can achieve to have the sources of shared field centralized and be able to use those fields on formulas at least. Any other alternatives?

 

Thanks in advance

Juan

No RepliesBe the first to reply