How to: OData filter in Power Automate on Dataverse lookup field
Vložit
- čas přidán 26. 07. 2024
- Writing an OData Filter in Power automate to filter records based on a Lookup field value has always been a challenge. In this video you will understand the logical and schema names in Dataverse. That should be good enough for you to never Google this filter.
To enroll in my Udemy courses see below link for discount vouchers sslwsh008.securedata.net/dotn...
This video contains
0:00 Introduction
0:44 Setup and involved tables
1:13 Understanding Dataverse lookup field
2:53 Creating the flow and writing OData filter
5:15 Testing the solution
6:02 How to add lookup field to Select action
8:10 Free course coupon
Contact me
- LinkedIn / alirezaaliabadi
- Twitter / aaliabadi1
- Instagram / alireza.aliabadi_ig
- Facebook / alireza.aliabadi.fb - Věda a technologie
I think this video is going to help a lot of people and clear confusions. If this applies to your case, please leave a comment and let me know. 😊
Hi sir, I have a question... can I sell the courses that I bought from Udemy?
Awesome as always, Alireza! Thank you
You just saved my day !! Thanks a lot for this vidéo ;)
Really helpful, thank you.
Alireza, you are always fantastic.
Gracias! easy fix!
Alireza, I'm hopeful that Power Automate will make these a little easier to select/understand in the future, but your video brilliantly walks through how to get what you're looking for. Keep the content coming!
It is not going to happen anytime soon. The problem is that OData is a very old technology that is not meant to be used for simplicity and citizen developers. The Dataverse actions in Power Automate have lots of issues. At least it works. Try time zone code and those options are there for decoration. It's more than a month that I have open ticket with Microsoft and they don't have an answer on why that doesn't work and they only offer me a workaround.
Microsoft is too big to really care about developers anymore. At the moment their ONLY agenda is to make more money for share holders.
I agree@@AlirezaAliabadi I keep having to switch between the old and new experience and I've found that the functionality varies between them. It's a great system overall, but prone to errors just like everything made by people.🙂
Brother how have I watch two full udemy courses but not subscribed to your CZcams . I owe my career to you sir, as an immigrants from Russia I love you and your content and hope to help others as you have helped me . I love the content!
👏👏
Great Content, loved the way you demonstrated. Thank you.
I've a query: How can we write the ODATA filter query where Column A is of Type "Person or Group" in SharePoint and is a multiselect? example: Column A is called Department, Column B is Employees. One department can have multiple employees, so How can we make the ODATA filter so we get All the departments where Employee1(email of employee) is a part of?
czcams.com/video/8Ngtu-W-ITA/video.htmlsi=-4v_SLhweAtBrJFI
Great and clear topic as usual, quick question 🙋🏻 in which Udemy course we’ll get this video?
It is on the way my friend. Next course is all about Dataverse struggles.
If we use this voucher then the course on udemy will be free?
Yes. You will have lifetime access to this course and all updates.
The voucher expires within 5 days but your enrolment doesn't.
@@AlirezaAliabadi i tried the voucher but still it is showing charges amt of rs 499 indian currency
@@Learnpowerplatform The voucher code is good and so far I have quite a bit of enrolments under this voucher. Try this link and if that doesn't work contact Udemy support directly
www.udemy.com/course/master-microsoft-flow-expressions-in-2-hoursish/?couponCode=BE25AE37A4
@@AlirezaAliabadi i am using the voucher for power automate crash course and this voucher not working. I asked udemy support team and they said i need to chk with instructor since its a voucher from instructor
@@Learnpowerplatform of course. The voucher is issued for expressions course. If you want the other course, there is a discount code in the description but not a free coupon.