
Announcements
Hi Experts,
Good Day!
I have a SharePoint list with a custom form. I have a single-line data type named Job Function, and in Power Apps, I made it allow values to be a dropdown, from which I get the data from another SharePoint list to look up the data.
It was perfectly working until I figured out that some lookup data were not displaying. So I checked the formula, and it automatically updated with a new one.
From:
Distinct(Sort(Filter('Cost Center 2021','Complany Code Desc' = DataCardValue30.Selected.Value),'Job Function'),'Job Function'),'Job Function')
To:
ForAll(Distinct(Sort(Filter('Cost Center 2021','Complany Code Desc' = DataCardValue30.Selected.Value),'Job Function'),'Job Function'),{Result: ThisRecord.Value})
As a result, not all data are being captured in my form. I have 70 items to display, but only 41 are being displayed.
Can someone help me fix this?