Make a Value Visible when A Choice is Selected from Another Sharepoint List

[syhrh]

Hi, I created 2 People columns; Approver Level 1 and Approver Level 2. I want that when the user fills in the form in the Employee list in the Approval Type column, their Approvers name will be visible. Approver Level 1 and Approver Level 2 are set in the Approvers list and both are People columns. Can anyone please help me?

Approval Type column is a choice column.

Thank you

[jcfDaniel]

Hi,

In those Approver labels you should be able to do a lookup based on the value of the approval type.

Something like Lookup( ApproverList, ApprovalType = ApprovalTypeDropdown.SelectedText.Value ).Level1Approver.DisplayName

[AJ_vizMan]

@syhrh - You need to use lookup column.
Create a Lookup column in 'test- Leave Request' SharePoint List.

Procedure to follow is explained here : 

https://kwizcom.com/blog/sharepoint-lookup-column/#:~:text=A%20Lookup%20column%20is%20one,are%20retr....

Catchup this section : "How to Create an Out-of-the-box Lookup Column in SharePoint"

[syhrh]

@jcfDanielThank you for replying. Which property should I input this formula? 

[syhrh]

@AJ_vizMan Thank you for your suggestion. The link given shows that the values need to be selected. I want the Approver Level 1 and Approver Level 2 columns are view mode only and be automated when any Approval type is selected.

[jcfDaniel]

Hi @syhrh , in the label´s text.

[syhrh]

@jcfDaniel but there's no label's text. The datacard and its datacardvalue don't have Text

[syhrh]

@jcfDaniel 

this is the Items property in the Approver Level 1 datacard. I'm trying to filter only Approver Level 1 display name with the Approval Type (DataCardValue3) that will appear in the box. But it's blank when I run it. How to make it right?

[jcfDaniel]

Hi,

I don't use forms so I don't know much about them but there is a text property in DataCardValue, assuming the column is text in your table.

[syhrh]

@jcfDaniel No, there's no text property in DataCardValue. I searched for it