Forum Discussion

h11's avatar
h11
Icon for Helper III rankHelper III
2 years ago

Lookup Formula showing only a few projects - Power Apps

In my Power app, I have a SharePoint list displayed in the gallery, and the form includes all fields from this list, which functioned perfectly. However, after adding a custom card to the form with the bottom three fields sourced from a different SharePoint list, I had issues. The Lookup formula only works for some projects, while most return an error. Below are the screenshots and formulas I've used, where a unique id named 'Project Code' is utilized to retrieve fields from the second SharePoint list.

 

1. Formula I used to get the data on the data from the Gallery is: 

Sort(Filter(

    PriorityCollect,

    StartsWith(Title, TextInput2.Text) &&

    ('Project Status'.Value = Dropdown3.Selected.Value || IsBlank(Dropdown3.Selected.Value)) &&

    ('Project Manager'.DisplayName = Dropdown1.Selected.Value || IsBlank(Dropdown1.Selected.Value))

),ThisRecord.'Priority Ranking',SortOrder.Ascending

)

2. Formula I used to lookup for date on the custom card with different SharePoint list:

Coalesce(Text(LookUp(Report, 'Project Code' = Text(Gallery1.Selected.'Code*'), 'Date')),"Not Found")

 

I got results for 10 out of 500 projects after I used the above formula.

Other 490 projects didn't show up results.

 

Please assist me by identifying where am I going wrong, so that I can apply the correct formula to retrieve the data. Thank you!

Need Help

3 Replies