Power Platform Community Forum Thread Details

I have three sharepoint list.

The list A record the header information.

The list B record the item catalogue or list.

The list C record the detail information.

In the list C I have two lookup column, one for the list A and one for the list B. And both of them, also show in the list C additional list information. Meaning that, if the lookup column in the list C for the list C is called AReference, in the setting for that columns I also show the title, the version and the status. (Status is a column in the List A)

And the same happens with the lookup reference column for the list B.

I build a powerapp based on the List A. (browse, detail and edit screens)

Manually build three additional screens for the list C.

In the edit screen, I am trying to place a dropdown field based on the lookup column for the list A (AReference) but I am having the following situation:

1. As I said before, the column AReference is a lookup column and it is based on the ID of the list A, but I also show addtional reference column of the list A (selected in the setting of the AReference column).

2. In the dropdown field, the list of values shows all the ID number of the list A.

3. I need to display the title values but, when I save the record, send to the lookup column on the list C, the ID value.

In the dropdown properties, for the values I select the name of the column I want to show.

But where I need to setup, to sent to the sharepoint , the ID instead of the Title value?

Thanks in advanced

Abdel