Forum Discussion
How to use lookup for person/group, choice,...
I have sp list "Training list" with columns Training name (single line text), Department (choice), Trainer (Person/Group),... and sp list Training plan which have columns Training, Trainer, Category, Date, Status,... In Training plan I need to automatically fil Trainer and Category based on selected Training from lookup column. I am aware that is not possible to use this types of columns (choice, person,...) in lookup, but I don't know how to resolve this issue 
Please advise how to resolve this.
P.S. I also planed to use power apps to create forms which will be used for this sp list if this could be useful.
1 Reply
- You could use Power Automate to do this. When you create or updated, use Power Automate to lookup the additional values in the Training List and copy the values to the Training Plan.
This video explains the concepts: https://www.youtube.com/watch?v=KYsMNoc7aPY
