We would get this error while trying to get the value of a related entity (lookup) through a related entity (lookup) in the current record using the incorrect formula.
For e.g. here Region is a lookup in the Village, which in turn is a lookup in the Product record (ThisItem).
The solution here is to use the LookUp function
Before |
After |
ThisItem.Village.Region.Name |
LookUp(Villages, Village = ThisItem.Village.Village).Region.Name |
Search the Villages table, using the GUID of the Village, and fetch the name of the region lookup field in it. |
Hope it helps..
One thought on “Fix- Multiple levels of many-to-one relationship expansion aren’t supported in PowerApps”