Learn to use the PowerApps Filter function 

I will if you promise to keep learning

😍 I like the idea.

Appreciate that Mario! As a fellow small business owner this make my night. 😎

Awesome. Keep up the good work. I will do my best to make enough videos you can do it all yourself. Also, I will mention if you need help I am always available for consulting. ;)

Awesome

Glad to help.

Awesome 😎

Happy to help Andre. Keep learning 😀

Awesome 😎

You are welcome.

Glad to help. 😀

Glad to help. 😀

Very cool. I haven't tried it with CDS yet.

Glad to help. 😀

Awesome

Glad to help. 😀

Thanks Bill. I try to make good content that isn’t boring. 😻

Glad to hear it!

@@ShanesCows unfortunately not didn't quite do what I wanted. On a form we want to pull the list of choices from SharePoint choice field and then set the default on the the field based on a selection from a different field...just not working. Thinking it has to do with the fact powerapps see that field as a record with all the fields of SharePoint in it. Going to tinker more when I get time to see if I can make it work.

Glad to help :)

Awe! thank you. 🐶

Feel free to email me shane @powerapps911.com anything you want to share. Thank 😻

I am and thank you. Almost to 100 videos so I am still going. Hope the help you

Awesome!

Thanks!

Glad you like them!

Glad to help. 😀

Your English is great. Thank you for the kind words. 🐶

Thanks 🙏

Happy to help

Try out this video for some ideas. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0MB-z9cyFCQ.html

Look for ForAll video. 😀

Gracias! 😀

Awesome! Kudos to you for rolling up your sleeves and learning some new stuff.

Sorry Linda. Did you get it figured out? I will try to do better in future videos. Thanks for The feedback

Awesome 👏

You are welcome

Glad to help. Maybe this video? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-43ekj5MlNJU.html

Maybe look at some of my content around forms or patch for help editing data.

Happy to help

Filter(Employees, Age > 32 and Color = "Red")

You are right. Sorry, sometimes I get too excited and forget. Do you need info from this video? I can get it for you.

😎

GroupBy function is the answer but would be a good video.

Possible? Yes. Easy no. Lots of tweaks required but no quick answer. Sorry

This will help. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kLGglidmPxg.html 😀

With SharePoint might be easiest to do all of the positive. Status = Opened Or Status = pending Something like that.

Powerapps doesn’t really do type ahead. Try a combobox with IsSearchable set to true. Might be what you need

You are awesome! Thanks

Glad to help

I am in the same predicament Shane. I need to search for a specific text but display the result filtered by those records greater or equal to today.

Yup. Try this video that explains In ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MeQDIBrJjRg.html or this one about duplicates ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Ap3_Ea9H8b0.html. Both talk about the concept more.

Look for my video on repeating tables like infopath

Justin see if this video helps you think through how better ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kLGglidmPxg.html

Just had the data source and it should work.

Look for my video on the In function

I faced the same challenge ... SortByColumns(Filter('Report database', ( (StartsWith('Customer_name',TextSearchBox1.Text) || StartsWith('Customer_country',TextSearchBox1.Text)) || (StartsWith('Customer_city',TextSearchBox1.Text) || StartsWith('Key_Account_Manager_Name',TextSearchBox1.Text)) ) ) , "Report_x0020_date", If(SortDescending1, Descending, Ascending)) The magic with the blocks of brackets is as far as I know necessary, since || can only check two statements and not a row of more than two - so for many columns it will be brackets and brackets and brackets and brackets. At least it did not work without the brackets for me, with brackets it works. If anyone knows better, please let me know. And the beauty of it: all delegable - docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list

Amy this video show Search around a filter. I think that should get you on the right track. 😁 Power Apps Search and Filter Function with SharePoint + Workarounds ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYi24okXDPs.html

Text is always in quotes. Sometimes column names inside of functions are in quotes. (Like SortByColumns and Search). I don't know I have a solid answer here. You Just have to kind of figure it out. The best way is if you look at what the formula is suggesting in the dropdown as you type that is a hint. Sorry for a weak answer.

Just wrap sort around the filter.

Yes the record has to have a primary key for Power Apps to edit it

I think SharePoint search is probably better than what you can do in PowerApps. But I hope you prove me wrong. 😀

Not really. You can use If or a collection of the two datasource have the same columns

We could do something like that. I will put it on the list but, it might be a while. The list is getting long. :)

I'm with Marlon, Shane. Please move this up on your list of videos to make.

I think this is the video you are looking for. :) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-43ekj5MlNJU.html

Yikes. I haven’t done that in a long time. I don’t have an easy suggestion. Sorry

You need to read up on Delegation in PowerApps. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview Long story short for that much info I think you will need to consider a different data source.

Blake I think this is what you are looking for? PowerApps Repeating Tables like InfoPath Part 2 - View and edit the data ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DylxsXIUyDc.html

Not sure I excatly follow. You can use And and Or functions if you wanted to in your filter or If. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-logicals

I think this is what you want. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xgznk4XlPCo.html

You can add a button to the gallery. What are you struggling with?

Filter(SharePointlist, emailcolumn = user().email) is an example

Shane, I'm having similar issues as threewiseman1. Looks like I am running into delegation problems when I try to filter by the choice column from the sharepoint list. I've figured out that I can create a collection from the sharepoint list, add a new column using the values from the choice column and then filter from the newly added column to get the gallery to show what I want. However, this doesn't help the overall project I'm working on because I still need to be able to edit and update the original sharepoint connection in the edit screen. How would I do that? The project I'm working on is a simple status update app that a field agent can use to respond to new task requests entered in the sharepoint list. The sharepoint choice column that I'm referencing and having trouble with happens to be a status column. SInce there are many rows in the list, it only makes sense to display SP list records that are "open" and filter out the ones that are "complete." Am I on the right track with using a collection on the gallery?

To store a table of results you would use a collection ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-yS6mTRlmuls.html

I relied to Prasad in email but in case anyone else is wondering what I would do is use multiple data tables on top of each other. Then only make the one visible that shows the columns I want to show.

🤩🥰🐶

You would need a gallery for each list and set each to filter.

To make it one record check out the concat function.

Yes. Each gallery you control what fields you show so should work.

Use the filter function in the items property of the drop down

Ben did you get this figured out? If not email me and I will send you the screenshots.

I would look at your items property again. Also check you have a label that is set to show a field with data

Usually, in those complex scenarios, I use the filters/search box to create a collection. And then have the gallery just show the collection. That way my reset button can reset the controls and the collection.

I think the concept you are looking for is in this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mbKovagC7As.html

@@ShanesCows thanks a lot!

Yes. Look up my video on conditional formatting. You can check if the results IsEmpty and not show the button if true.