Lookup Formula showing only a few projects - Power Apps

[h11]

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!

[Anonymous]

Hi, @h11 

Thanks for marcelsmaglhaes help. You can visit the link to find account help. Hopefully your problem will be resolved in the Power APPS forums after the account is unlocked
Community Account Support - Microsoft Fabric Community

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[h11]

Hi @marcelsmaglhaes I did. However, after posting this question, my account got locked. I am searching for a way to unlock it but am unsure why it is locked. Also, I am unable to find an option for assistance or to contact customer service to get my account unlocked.

That is the reason, I posted in this group for help. Thank you!

[marcelsmaglhaes]

Hi @h11 ,

I recommend posting your question on the Microsoft Power Platform Community Forum. They can provide more effective assistance with your issue.