Show choice column value from another list on display form

[haider1]

Hi,

I have 2 lists, I want to display a choice column value called "Status" from list 2 on the label in display form from list 1 .

Thanks in advance

[vish3027]

@haider1 You need to work on Items property and DefaultSelectedItems/Default property of dropdown to get value from other list.

It will be conditional as you may need to get particular records status value from another list.

DefaultSelectedItems/Default = {Value:"retrieve the value required here"}

[v-qiaqi-msft]

Hi @haider1,

Have you solved your problem?

Do you want to display choice from another list based on item in the display form?

Could you please tell me that if there is relationship between 2 lists?

I assume that both of two lists share a same column, you could retrieve the status value based on this same column in your display form.

Set the Label Text property as below:

LookUp(List2,SameColumn=ThisItem.ColumnName).Status.Value

[haider1]

Hi,

there is no relationship between the 2 lists, I'm only patching from list1 to list2, the idea is the user has two buttons to select (Yes and No) to confirm his availability inside his flat when he choose yes the status column in list 2 will be updated as "Available" and if he choose No, the status column in list 2 will become "Not Available", so I want to retrieve the value of the status he chooses in my display form of list 1 and based on current login user, that means each user see his availability after he chose yes or No.

[v-qiaqi-msft]

Hi @haider1,

What do you mean by "retrieve the value of the status he chooses in my display form of list 1"?

Since you want to update the Status column based on yes/no button, why would you like to retrieve the status value in your display form from list1?

Is this display form populated with the list2?

Feel more confused....

[haider1]

Hi @v-qiaqi-msft ,

thank you for your reply.

you can see in the attached picture after he chose yes/no, a label must show with his selection Yes=available, No=Not Available, the status column that contains the two choices (Available and Not Available) is in the second list and the attached picture is in the form of the first list, so I want to show the availability value in the form of list 1.

[v-qiaqi-msft · Accepted solution]

Hi @haider1,

If this is a form populated with list1, then you could reference to the availability value directly using the "ThisItem.Availability ".