Power Automate Flow odata filter dataverse lookup and choice columns

Sounds simple but it is painful. Involves virtual columns and other chaos. And even if you don't use Dataverse you will get an inside look at how I work through problems in flow.

[FizzyMcPhysics]

2 years later and this video is still worryingly useful.

[blinkjoel]

You can query based on related table using the human value, by using the following syntax in the Filter Query box, including brackets:
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!

[DataisKing]

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?

[ronalddinoso]

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?

[daisukeniwatari]

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, '_')

[FurquimRafa]

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

[ctb]

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

[draushaus]

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?

[YaryRivera]

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?

[pawanachettri]

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.

[chriseiserbeck]

Hey Shane - great video! Can you tell us how to format the select columns in the list rows step to limit the amount of data being pulled through from dataverse? I’ve tried the column name, schema column name and keep getting bad request (or a warning about the dataset if I leave it blank!!!)

[syntraxify]

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

[burhanshah]

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.

[matfam]

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

[anthonyleduc]

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

[ubezmusic]

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

[ksowjanya]

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

[patrickfillion]

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.

[ksowjanya]

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

[vLife]

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