I am stuck trying to implement this feature in PowerApps. Let me explain the issue,
I have two SharePoint Lists that are added as sources in PowerApps, the lists are as follows -
List 1
Defect Type and Sub Type
List 2
Solved! Go to Solution.
Hi @Elliottd,
Could you please give a sample to describe the relationship between the list1 and list2?
Do you want to display the Scheme Name from list1 corresponding to each record in the list2?
Modify your formula as below:
LookUp('Defect Type and Sub Type','Scheme Name'=ThisItem.'Scheme Name')
I think the formula you provided makes no sense, if the scheme name from list1 equals to schema name from this item, then there is no need to display schema name since they are totally same.
You should refer to the primary key between the list1 and list2, so that you could retrieve the schema name based on the same primary key from list1.
For example, TypeID is the primary key that both list1 and list2 shares, you could use the following formula:
LookUp('Defect Type and Sub Type',TypeID=ThisItem.TypeID).'Schema Name'
Hi @Elliottd,
Could you please give a sample to describe the relationship between the list1 and list2?
Do you want to display the Scheme Name from list1 corresponding to each record in the list2?
Modify your formula as below:
LookUp('Defect Type and Sub Type','Scheme Name'=ThisItem.'Scheme Name')
I think the formula you provided makes no sense, if the scheme name from list1 equals to schema name from this item, then there is no need to display schema name since they are totally same.
You should refer to the primary key between the list1 and list2, so that you could retrieve the schema name based on the same primary key from list1.
For example, TypeID is the primary key that both list1 and list2 shares, you could use the following formula:
LookUp('Defect Type and Sub Type',TypeID=ThisItem.TypeID).'Schema Name'
User | Count |
---|---|
256 | |
107 | |
90 | |
51 | |
44 |