2 years later and this video is still worryingly useful.

You can query based on related table using the human value, by using the following syntax in the Filter Query box, including brackets: (cr662_TheToy/cr662_chewystoysid eq 'Penguin') I got the second field from 11:00 in your video. Just to explain the above, the first field is the Lookup column in the table you're querying. The column after the slash is the column name of the primary key field in the related table. In your case, the cr662_chewystoysid friendly name is 'Chewy's Toys' Hope this helps!

Thanks for posting this! It was the exact issue that I was trying to solve and was struggling to figure out. I really like how you showed your research/debugging process to figure out the "virtual" name of a lookup column. One note for others that watch this video: I can clearly see that putting the GUID within single quotes worked for you but for whatever reason, I had to remove the single quotes around the GUID to get this to work for me.

This video has become a reference for me. I didn't remember how to get the virtual column name... this has helped to show me where to get it.

Hi Shane, thank you for this Video, it helped me a lot with this Odata thingy! I really appreciate your work!

Hi Shane, thanks for all the videos! I believe it is possible to query based on columns on the related table. You can use the expand option to specify the columns on the related table, then include them in the filter query. Easiest way to get the correct syntax is to use the FetchXMLbuilder tool in the XRM Toolbox. If the scenario allows to use the guid though I would use it as my first choice.

Thanks Shane. Fantastic lesson as usual! Thanks!

Thanks Shane for this wonderful lesson. It helped me a lot

Best video abou dataverse and Power Automate out there! Nice work!

cheers shane....coming up three years in power platform and still getting schooled by you!

I really loved your attitude, you're amazing!

Congrats on 100k subs!

I haven't been able to find any content on how to perform an odata filter query directly inside of PowerApps. I am trying to filter on a week number from a text input. For example Report.Run("(weekno eq '" & SelectedWeekNo.Value & '")') Do you have any good resources?

Thank you - this was unbelievably helpful

I can't thank enough🥲😊. You again saved me, and the best thing is you are showing the same lookup tables which you addressed in the previous videos which makes it easy to understand. Thank you once again.

Loving the Dataverse videos!

Great article! Just what I needed.

Hi Shane great video, for scalability what I usually do is add a connector to get items from chewys toys filtering with toy name and row count = 1, with that in the get items from chewys tracker I use the id from first record returned from the previous get items

Great video, but how do you dynamically filter using the GUID field from the lookup table to the table you want to filter? Also, how do you filter records where the GUID isn’t in the lookup table?

Ty, Shane... u saved my life.

Thanks Shane. Great Videos. How all these will work when we move from one Environment to another if we use Internal names and codes?

Shane, i would to thank you. With your help, i understand where was my mistake.thanks

Thank you Shane.

Hi Shane, thank you very much for the video!! In my case I have X2 List rows where I'm trying to pulling data from my parent table (List rows 1) based on a column status, which works fine. But in my child table (List view 2 within a Foreach) where I'm trying to pull data based on my parent ID which is a lookup in my child, I get syntax error when I use _virtualtable_value eq dynamic content for the ID in my parent. What am I doing wrong?

Hi Shane! This is incredibly useful thanks a lot! I have a view i need to write to a csv file and email a contact on a monthly basis. The view is from table X, which holds lookup columns from table Y and table Z. I am struggling to write columns from Y and Z onto csv. Can you please advise on how to achieve it?

Love your videos. Thanks for them! I have a simple flow... Retrieve inputs from a Microsoft Form and drop them onto a Sharepoint List. However, one of the form responses is 'priority', with choices (high, medium, low). On the MS List, I want 'Priority' to be a lookup column, so it can hit another list and bring back 10 for high, 5 for medium, 1 for low. I'm told I need 'Filter Query' to get that done. True? How?

Hi, thx for video, could you call the feature which help you to choose wht to copy into a row forom the buffer. Soory if my english is bad, it's not my native lengauge

Really useful video, thanks. Would you happen to have a video on how to get data from a lookup / option to use in an email or Teams post?

Hi Thanks for this video! Do you have tip on how to send a choice and look up column data from Dataverse via an email? Please advise.

Hi Shane, great vedio .. Could you please tell me whether ODFILTER works on 1lakh+ record in the dataverse

Hi Shane. How do I create a flow in excel dashboard created by me through a SharePoint form created by someone else on SharePoint?

How to filter row by a custom field (lookup reference is new table). Hope to hear from you. Thanks

Anybody run into an issue where Dataverse Choice columns do not show up in preview in SSIS with an ODATA connection?

Hey Shane, how do we find out the guid of penguin here if we have to get it dynamically? Like I have excel table with a column Company which certain values. In my dataverse table X, the column "Company" is a lookup column to table Companies. Now I got to use List Rows from Dataverse connector to get rows from X table matching the company name on the excel table. I do not have guid of each company here. I only have their values. Any thoughts?

Thanks Shane

Hey Shane, I need help with PowerApps collection filter in OData. So, in my case PowerApps creates a set of collection (clearcollect) and saves in SharePoint list. While creating and saving this collection in SharePoint list it creates a unique number in column called SN Number. Now I would like to send an email with those collection having same unique number only.

Whenever I put the Guid in a compose, it doesn't work in the o-data filter. It screams can't compare guid to string... that's quite sad.

Is there a way to use default columns like CreatedOn with OData ? Because it's not working. I am trying to filter based on the CreatedOn date of the records for a Scheduled Flow. Would appreciate any help.

Brother, I'm looking for Powerapps Import CSV or Excel using import control and that gets stored to a temp collection. the reason I ask is, with the new Form control, users will be able to add or edit only one item. instead, if there is an option for importing a file and that uploads as a gallery or data table, that helps users to add the item to the database instead of adding one by one. Requesting for assistance.

hi sir, will this method help if we have to move the application bw different environments.

How to enroll for your training class, as you mentioned at the end of the video?

Your videos are very clear and helpful for me. In this video at 10:30 after test is run , it showed 'show raw inputs and show raw outputs', but it does not show for me. plz help me with this

Thanks for this tutorial. It seems that filtering underscore is not working. Do you have any idea on how to filter underscores. startswith(column_name , '_')

Sometimes when I click view raw data I get error 200 not a large enough set, so if you or any viewers can help, thx! Also when copying integer for choice from table where column was created, remember to remove the commas when referencing that value in flow/Power Automate. Onwards to 100,000, congrats!

how to filter rows if the datatype is email?

How to filter lookup column if it is blank?

Help Shane!!! I need help... I have 2 tables in Dataverse: Events Table : (with a unique "EventID") and column named (MiscGrandTotal) where I will need the sum of all miscellaneouos items for that EventID Misc Table : (that uses the "EventID" in the "RefEventID" column for multiple rows of misc items) and it contains the UnitCost, Quantity, MiscTotal columns for each. I need to be able to add a new miscellaneous item row in the Misc Table with a new miscSubtotal, then filter all misc items rows by that EventID, aggregate the new misc item subtotal to the existing miscgrandtotal and take the MiscGrandTotal for all miscellaneous items under that EventID and send /Update the result in the Events table in the MiscGrandTotal column How can I do this in power automate?

god bless you

I need to apply this in power automate: when row selected from table1 get Name(lookup field) and then list rows dataverse table2 by filter lookup field Name equal table1 Name Name feild is lookup from table3

Thanks! xD

How to import 50000 items from Excel to SharePoint list?

At 6:59, I think you were searching for Penguin with Q instead of G.

Can we have a workaround for print() please?!!!

This is the third time I watched this one. wonder how many more times I need 🙂

Hi. msdyn_flow_approvalresponseidx_approvalid eq '@{toUpper(outputs('Create_an_approval')?['body/name'])}' and owninguser/internalemailaddress eq '@{item()}'. Isn't this a valid Odata query with lookup field (owninguser is lookup)? The table that it is selecting from is Approval Response it is to reference if the current user in the current approval process has gave his approval and to remind the others. Anyway I got this from Reza Dorrani. You are great in PowerApps, but he is master on the flows :) Cheers

"Way harder than it should be" MY THOUGHTS EXACTLY.... why is SQL easier than this???