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.

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,008)