This video has saved me a ton of time. Thank you! 🤩

This was great! One of the best tutorials I have seen on any Power Query topic. Great for building a foundation to learn! Thank you.

Packed with many valuable learning in this small exercise 😊

Just save this to my list. In case I need to solve some problem in the future. Just watched your video from 3 years ago about mail merge with Google docs. It helps to solve the problem in my new project. Thank you so much.

Wuahhh, this is genius! Thanks for sharing

Great Video. This is what i was exactly looking for. I used the parameters to query from database using this tutorial. Thanks for uploading this video!

This is great! thanksa lot for the super clear step by step explanation. Congratulations!

I have seen a BUNCH of youtube videos in my years. Excel, python, SQL, Power BI etc. etc. your methodical walkthrough and explanation is one of the best 'teachings' I have experienced on youtube :) nice. And super cool functionality too. Coupled with datalavidation on tablerange lookup, with a recorded macro to run update - this I am most definitely going to use. Thank you :9

sempre molto bravo nella spiegazione

This is great, however, I can't seem to get it to work picking up a date. I've got dates on my worksheet, formatted as dates but when I try using the function to retrieve the date I get the message "We cannot convert the value #datetime(2022, 4, 1, 0, 0, 0) to type Text.". How do I work round this?

Exactly what I was looking for! Thank you

Exactly what I was looking for!

great tutorial! I have 3 named ranges used as filters for a table, but I want to not require them all to have values. Applying the code in the video, it causes there to be 0 results when any of the cells are blank. Can you help with how to modify the code to allow for blank values...that way if there are no filters, all records would show in query table. Thanks!

Fantastic 👍🏼. That’ll be GREAT if you could parameters as dependent drop-down lists to make that better functional and to avoid not found results.MOREOVER, you could add a simple button to REFRESH☺️

BTW, what if I wanna list the all without filters 🤔?

Thanks a lot you're an angel

Amazing! Just what I needed! Thanks

Fantastic video. Thank you so much. Helps me a lot

GOOD! Thank you for your explanation

I have dates in my table. How can I Filter for a specifit date which I mentioned in a cell (Same as Olivia" in your example)

Little long for the content but useful as always. I’m trying to use named range as starting and end points of a sheer region I need to grab. Haven’t found it yet. Maybe I will leverage different property besides content.

Perfect, thank you!

this is excellent. thanks

In case I want to expand the same parameter to another sheet, how would I do?

Thank you, I learn so much from here, could you please make a video about how to put task list from google sheet to google task with google app script? thank you

Great tutorial, thanks a lot for this. What would be the solution when you have to add /filter for the same parameter but multiple values, let’s say Olivia and Grace"?

Can you please let me know how can we use the function in the query in advanced Editor of Power Query or can we access values from cell into the SQL query

Can I use the function into a Json.Document(Web.Contents ... script? Want to have a dynamic value in there.

Thanks!

thank you

I’m trying to create a filter, but the filter could have 1 to several criteria for the same column. Your video illustrates one criteria per column and the position is 0. What would I have to do differently to turn that one criteria into a range of criteria and then use the count of that range for the positions in the list? For example, there may be 2 criteria with positions 0 and 1, then next time there may be 3 criteria with positions 0, 1, and 2. I just can’t figure out how to make those positions dynamic/variable. I saw that someone asked about that earlier and was directed to another video. I watched that, but it didn’t answer my question. Any help would be greatly appreciated!

Great content! Thank you. It was very useful. A question that I have: If I leave the "name_range" cells empty then I get no results in the table, which makes sense. However, it would be very useful in my case to get the whole table (as if it was not filtered) if there is no input in those cells, instead of no table. Is that possible? Thank you!

im using same method but the table is returning empty. even the formatting is also same as text.

Why it doesn't work when I want to have a table with numbers (instead of names)?

Awesome. It's not that easy to find good tutorials about advanced PQ and it's not easier in Excel.

I followed the steps but didn't work me. The function when invoke show's the cell value but my table is empty.

Can I use the dynamic parameter for 6 different sheets in the same workbook? I am building a workbook with 6 tables and I want to do the dynamic parameter in another sheet and set it to connection only.

Surely you do provide the accompanying excel files as well? Where can one find them? I’d like to download and follow along as you are performing the steps.

The Moment I try to use the function I get the following error: Formula.Firewall: Query 'ResultsList' (step 'Filtered Rows') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. let Source = MergedList, #"Filtered Rows" = Table.SelectRows(Source, each (Text.Contains([Name], getName()) )) in #"Filtered Rows" getName being my function instead of getSalesRep The function itself invokes fine, but as soon as I add it instead of the static value, my query breaks. Any ideas why?

is there any change of you covering big query of google sheet? since google sheet has a limit data volume, it would be woth it.

Can you read from a list (more than 1) and give each result in a separate sheet with the sheet named by the name in the list. Like a result sheet for Olivia is named Olivia

Is there a way to use a named range (lets call "sales_reps") that has more than 1 item and recall something like: getValue("sales_reps")(0) or getValue("sales_reps")(1) etc. (0,1... are the index numbers) for each rep?

I tried using the same function or parameter in a different sheet and was all blank, any idea?

Doesn't seem to work with numeric values, only text.

Why is there no queue function in Excel? It is useful when used with Google Sheet

I'm running into a problem with this. I'm working from a named cell which contains a value and is formatted as Number. I'm getting an error that says "We cannot convert the value 2023 to type Text." I don't see where it's trying to convert to type Text or why it would attempt to do so. The Editor says there are no syntax errors. Here's my code. llet Source = Excel.CurrentWorkbook(){[Name="GFY_input"]}[Content], ChangedType = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}}), MyList = Table.ToList(ChangedType), Report_GFY = MyList{0} in Report_GFY The error comes in on the transformation to a List. Under the List header it shows Error.

Hi, thanks for sharing. But, I have some issue to make it. I think this is because the cell I'm using is number type. Could it be the reason? do you know how to fix it?

How about this is value instead of string in our query?

Do you know SQL . If yes , wanna learn from you