Power Platform Community Forum Thread Details

Hello, I'm having this issue in a Sharepoint List that integrates a PowerApps form.

My form contains a data table, with two columns, one stores the Employee's Name and the other one the Employee ID.

Each row has two DataCards with DataValue Fields. I use a ComboBox Card for the Employee Name, which is linked to a SharePoint List.

For the Employee ID, I use a simple Text Card that uses this LookUp Formula for automatically get his value.

The LookUp works with the same SharePoint List called "Empleados OVT"

This is my formula for the Default property:

LookUp('Empleados OVT',Nombre=DataCardValue28.Selected.Nombre,GMIN)

I do the same for 12 DataCards.

I know that there is a Threshold for LookUp Columns, but there is another solution avoiding use LookUp Formulas?

Categories:

Building Power Apps

@mariomartinez - your terminology is confusing because I cannot see a Form control or any DataCards in your image.

Regarding LookUp columns, I have yet to come across any need to use them. This data type has limits in terms of delegation and is pointless when you can use fully delegable data types like Single Line Text or Number.

It is important to note that SharePoint LookUp columns were created for the SharePoint user interface in mind. Given you're expecting users to interact with your SharePoint list through a customised form interface, I would delete your LookUp columns and replace them Single Line Text or Number fields, and then leverage the LookUp function to "relate" both lists together on a common identifier you can guarantee will be unique. In your scenario, this could be the Employee ID.