Power Platform Community Forum Thread Details

I have a SharePoint list (ASRData) that has a column that is a lookup column. This lookup column is a lookup to an item in a document library in the same site. The value in this lookup column was established using a Flow. Here are some basic details of the SharePoint list.

- The Title column of the ASRData SharePoint list was renamed from "Title" to "ASRNbr". This is effectively a 5-6 character string of digits. All other attributes of this column were unchanged.

- The document library (ASRReport) contains PDF documents where the "Name" column = the pdf file name. The Title column of this doc library was set equal to the "Name" column minus the ".PDF" (file extension).

- A column exists in the ASRDatalist named ASRFullRpt that is a lookup column to the ASRReport doc library to the doc library's Title column.

- A flow is used to establish the link from the item in the SharePoint list to a specific doc in the ASRReport document library. In effect, the SharePoint list's ASRFullRpt may have a corresponding value in the Title column of the ASRReport document library. The flow effectively sets the list's ASRFullRpt lookup column equal to the ID of the ASRReport doc library's doc whose Title = ASRNbr. Simple flow.

Problem is that when the lookup column from the list is added to a Edit form in Power Apps, the value simply appears as Text and does not react to when clicked on. The PowerApp was not created from scratch but simply auto-generated from the list using the "Customize Forms" option (shown below). This auto-generation was used to present users with a sample of data.

ASR pic1.png