Power Platform Community Forum Thread Details

Hi All

I am hoping someone can help, but I have the blue dot of death in my app, caused by the following code;

Filter(Customers, StartsWith(Title, CustomerSearch1.Text ))

The name of the Datasource being a SharePoint list called Customers and I have a search box called CustomerSearch1. Have I done something wrong or missed something?

I also have a second SharePoint list called Projects, and a searchbox called ProjectSearch1, however I cannot get this to work. Is there any way to add to the below code to allow me to also Filter based on the results of the searchbox?

Filter(Projects,Customer.Id=CustomerGallery.Selected.ID)

Thanks for any assistance.

Shaun

Categories:

Building Power Apps

Hi @Anonymous,

I think you mean the delegation issue for hte blue remindings.

Filter(Customers, StartsWith(Title, CustomerSearch1.Text ))

I don't think this code should bring the blue remindings, as it should work with SharePoint custom list. Would you please share a screenshot of the issue you mentioned?

Understand delegation

For your second filter formula, which field in the projects that you would like to filter with?

If also the Title field, then the formula should be:

Filter(Projects,Customer.Id=CustomerGallery.Selected.ID, Startswith(Title,ProjectSearch1.text ))

For more information about how to use filter, search and other functions in PowerApps, please check:

Filter, Search, and LookUp functions in PowerApps

StartsWith function in PowerApps

Regards,

Michael

Community site session details

Blue Dot of Death

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates