cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
audrieg
Power Automate
Power Automate

Search Function

I'm trying to follow the instructions on this page:

https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/#examples

search.PNG

 

In my case I'm searching a sharepoint list for all items with the same ID number as the GalleryList1 selection. So I translated the example to be this and put it in the "Items" property of a new gallery (GalleryList2):

 

Search( SharePointDataSourceList, GalleryList1.Selected.ID, "RefID" )

 

Can anyone tell why it's not returning the rows in the list?

 

I also tried:

Filter(SharePointDataSourceList,RefID = Gallerylist1.Selected.ID)

and

Filter(PlanTreatmentComponents,GalleryList1.Selected.ID in "RefID") (this one removed the error, but didn't display the items for RefID 1)

15 REPLIES 15

I'm actually spending an enormous amount of time converting numbers in Power Apps. Here is another annoying example.

 

I have a choice list on SharePoint (screen shot a)

I have a dropdown in PowerApps (screen shot b) - it pulls all the station numbers (no filter) from the Stations List on SharePoint

The dropdown itself is working wonderfully.....however when I go to patch it....Power Apps starts yelling about data mismatch again.

 

Patch(LogAmbient,Defaults(LogAmbient),

{Station: DropdownStations.Text,
Notes: InputNotes.Text});
Navigate(BrowseLogs, ScreenTransition.Fade)

 

 

 

ScreenShot1.PNG

screenshot2.PNG

error.png

I'm actually spending an enormous amount of time converting numbers in Power Apps. Here is another annoying example.

 

I have a choice list on SharePoint (screen shot a)

I have a dropdown in PowerApps (screen shot b) - it pulls all the station numbers (no filter) from the Stations List on SharePoint

The dropdown itself is working wonderfully.....however when I go to patch it....Power Apps starts yelling about data mismatch again.

 

Patch(LogAmbient,Defaults(LogAmbient),

{Station: DropdownStations.Text,
Notes: InputNotes.Text});
Navigate(BrowseLogs, ScreenTransition.Fade)

 

 

 

ScreenShot1.PNG

screenshot2.PNG

error.png

Here is what I tried. Let me know if I got the repro wrong.

 

1. Created "Customers" list with Name and ID field

2. Created "Orders" list with a LookUp field that pointed to Customers' ID field AND "RefID" field that would contain the ID from Customers list

3. Created Gallery "Gallery1" with Items = Customers

4. Created Gallery "Gallery2" with Items = Filter(Orders, RefID = Gallery1.Selected.ID)

5. Also tried doing Gallery2 with Items = Filter(Orders, ccLookUp.Id = Gallery1.Selected.ID). In the case of lookup fields, they are represented using records in PowerApps. Hence doing ccLookUp.Id works.

 

They both worked.

View solution in original post

Anonymous
Not applicable

on my search OnChange even I have this function Filter('[dbo].[Customer]', Upper(TextSearchBox1.Text) in Name) because I have a list of names for my customers from that table and when they type in a search I want it to filter to those names when they type; however, this is not working for me all I get is a blank if anyone could help it would be greatly apperciated. provided some pics of what my data looks like before and after I type

aosfilter.pngaosfilter2.png

 

For those who may have their data in SQL rather than Sharepoint.  Something similar can be done by creating a computer column in the table with your ID number and having it convert all of them to varchar()

For those who may have their data in SQL rather than Sharepoint.  Something similar can be done by creating a computer column in the table with your ID number and having it convert all of them to varchar()

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,423)