I can't seem to find the email column to be looked up when referencing my email list to a new list. For reference, here is my list in SharePoint Online:
The list contains a cost center code, a business unit, and an approver. I need the approver to show in the next list. I created a list and I created a lookup field but I cannot see the Approver as part of the lookup field:
Any suggestions to fix this issue would be great help and advice.
My goal, by the way, is to show this value in Microsoft Flow, but the main UI is PowerApps.
Could you please share a bit more about the Approver column in your Company Code list?
Is it a Person or Group type column?
Further, do you want to create a Lookup column in a new list to reference the Person type column value within the Company Code list?
If you want to create a Lookup column in a new list to reference the Person type column value within the Company Code list, I afraid that there is no way to achieve your needs in SharePoint currently.
Please check and see if the following article would help in your scenario:
Actually, the Person or Group type column in SP list is also a Lookup type column, creating a Lookup type column in SP list to reference the Lookup type column value in another SP list is not supported within SharePoint list currently (Cascading Lookup value is not supported).
The Approver column in the list is a Person/Group lookup type of column. What I want to achieve is to display the Company Code in a drop-down on another list, and getting the proper approver to appear on that list based on the Company Code stated.
Any way I can do that? And thanks, for the reply!
Also just to clarify, what I'm trying to achieve is get this done in Microsoft Flow for approvals. The workflow goes like this:
I have two SharePoint lists: One for the form and one for the approver and company code
I am stuck in determining how to send the approval to the approver 1 (Where it references the company code with the specific approver) which is a lookup list that has the approver. I need SharePoint to send it to a specific approver based on the Company Code chosen by the requestor. Is there any way I can do this in SharePoint? Are there alternatives to do this?
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021