Excellent explanation! Thank you for making these types of things easier to understand!
@RezaDorrani24 күн бұрын
You're very welcome!
@ashleyprobert7212 ай бұрын
As always, thank you Reza. I was battling for hours looking for a solution on the Power Platform community. It took two minutes to solve my issue watching your video.
@RezaDorrani2 ай бұрын
Glad I could help
@pierrickdefossez31575 ай бұрын
I was struggling for hours with a combination of OR and AND in my query and once again only you could bring me the right answer and even more answers that I needed. You are so generous and such a pro! Thank you Reza, keep going like this, you are the best ever!!!
@RezaDorrani5 ай бұрын
Your are most welcome and thanks so much for the appreciation
@jamesclark20206 ай бұрын
I had no idea it was possible to do odata filter queries on Boolean columns. That piece of information alone made this tutorial really useful for me. Great video. Thank you 🙏
@RezaDorrani6 ай бұрын
Awesome!
@sadabshaikh63653 жыл бұрын
I don’t think anyone is covering this many scenarios in single video. Subscribed instantly. Great work. To the point and crisp. Very knowledgeable. I am new to power automate and just by following ur video I have developed few very interesting flows that helps my team. Cheers !!
@RezaDorrani3 жыл бұрын
Thank you for your kind words and welcome to the channel. I hope to keep providing valuable content.
@sahajabhavanam45273 ай бұрын
I was struggling with filter query drop down option enabling. This video helps me a lot
@RezaDorrani3 ай бұрын
Glad to hear the video is useful
@thrilled2bits3 жыл бұрын
Reza, not only do I enjoy your vids, I learn so much from them.... Much appreciated.
@RezaDorrani3 жыл бұрын
Thank You 😊
@simonking1733 Жыл бұрын
Experimental Filter Queries!!! This just got a lot easier. thanks for the info!! I cannot believe I am finding this out almost 2 years late
@RezaDorrani Жыл бұрын
Yes - its been 2 years :)
@abdulpasha15633 жыл бұрын
Really surprised why this video does not easily show up is queries. This is just awesome. You have touched upon the topics that really needs to be explained. The nuances of OData Filter Query has been explained very well by you. Your tone an pace is exactly what is needed to explain something that is complex. God bless you Reza. Keep doing the great work.
@RezaDorrani3 жыл бұрын
Thanks a ton for the amazing feedback. May be I am not so good at tagging my videos I guess.
@mellemelmo Жыл бұрын
Wow. Trying to initalize a variable on a new list item to get the date, but the new date showed up in yyyy-MM-dd and PA pulled in the filter query for an existing list as MM-dd-yyyy, so the dates never matched. I knew that was it, but this video showed me how to add the formatDateTime function around my variable... and it's working! Thank you so much! There's just so much to learn in every step.
@RezaDorrani Жыл бұрын
You're most welcome! Thanks for sharing your scenario.
@antonioalmeida8673 ай бұрын
Thanks a lot. I was having trouble with boolean fields and now I'ld can go ahead. Excellent video.
@RezaDorrani3 ай бұрын
You are welcome!
@liverlarson3 жыл бұрын
wish I'd found this video earlier this week. Suffered through finding a lot of information that was in this video through blog comments, trial and error, and also misdirection. Subscribed just because of the quality of this video.
@RezaDorrani3 жыл бұрын
Thank you for watching and thanks for the sub. Welcome to my channel.
@Wh0NeedsFr1ends Жыл бұрын
This is an absolutely Master Class tutorial.
@RezaDorrani Жыл бұрын
Thanks Harry
@Zim543 жыл бұрын
You truely are a master of Power Automate and of teaching it... ☝️ Thank you for the great video 👍
@RezaDorrani3 жыл бұрын
Thank you Thomas. I will keep trying my best.
@alaminmbamba2 жыл бұрын
Thank you very much this video had helped in solving some of my long-standing odata filter issues .
@RezaDorrani2 жыл бұрын
Glad it helped
@billyprater33613 жыл бұрын
This experimental feature just saved me a huge headache, and solved my problem in a couple minutes. Thank you!
@RezaDorrani3 жыл бұрын
Thank you for watching.
@Imwolfies3 жыл бұрын
Very helpful video and explanation for those of us whom are new to "Flows" and find it overwhelming.
@RezaDorrani3 жыл бұрын
Thank You
@jasmingutierrez68153 жыл бұрын
Im very impressed with your videos most especially this. This is really comprehensive. A lot of viewers will learn so much from you. Thank you for sharing your knowledge.
@RezaDorrani3 жыл бұрын
Thank You Jasmin
@ceeteezen5 ай бұрын
Excellent delivery
@RezaDorrani5 ай бұрын
Thanks
@rajaamohammed69653 жыл бұрын
Thanks for covering Power automate with SharePoint online. looking forward and excited to see more videos on SharePoint online capabilities with Power Platform.
@RezaDorrani3 жыл бұрын
You are welcome and much more to come!
@akkaradechsrithongchai77662 жыл бұрын
Thank you, that help me do finish my job again
@RezaDorrani2 жыл бұрын
Glad to hear that
@manirathinam8161 Жыл бұрын
OMG😮.. Masterclass explanation with clear contents.. One of the best explanation I've ever seen.. Thank you for the clear explanation 👍🏻
@RezaDorrani Жыл бұрын
Thanks Mani
@manirathinam8161 Жыл бұрын
Hi Reeza.. I have one doubt.. I have 5 choice columns in SharePoint list which contains options 'Yes' and 'No'. I want to send an email by extracting the items if the choice value is 'No' in all five column.. I checked the filed value of my choice columns. It says (_x0051_1).. I used (_x0051_1 eq 'No') in OData query. But I got an error saying "column _x0051_1 doesn't exist". Please let me know what can be done.
@RezaDorrani Жыл бұрын
@@manirathinam8161 check video again to see how I filter on yes/no type columns
@manirathinam8161 Жыл бұрын
@@RezaDorrani No, It is not yes/no column. It is a choice column. I am getting confusion only because of the field value I see for those 5 columns
@RezaDorrani Жыл бұрын
@@manirathinam8161 Best to post your issue with screenshots on the forums at powerusers.microsoft.com as chat is not a viable option for problem solving
@robofski3 жыл бұрын
The new interface for building ODATA queries will make life much easier :-) Great video as always.
@RezaDorrani3 жыл бұрын
Totally agree and thanks for watching.
@francoisbelanger32382 жыл бұрын
Thank you very much for the video. It helps a lot and i appreciate all the details and explanations. Very good job
@RezaDorrani2 жыл бұрын
You are most welcome!
@asrsinha_10 Жыл бұрын
Wow Reza, your videos are always with all the details and examples. You are awesome 😊
@RezaDorrani Жыл бұрын
Glad to hear that! Thanks so much
@asrsinha_10 Жыл бұрын
@@RezaDorrani You're welcome and keep supporting and guiding your viewers😊
@asrsinha_10 Жыл бұрын
@@RezaDorrani I created one flow and followed all the steps to apply Odata Filter query in Get data but showing Output as 'Value' = [ ].
@RezaDorrani Жыл бұрын
This more or less means query yields 0 results. I will recommend posting your query and scenario on forums with screenshots at powerusers.microsoft.com/
@asrsinha_10 Жыл бұрын
@@RezaDorrani Sure, thank you!
@seshasai7348 Жыл бұрын
Really, it was a great video reza. I am very grateful to you
@RezaDorrani Жыл бұрын
Glad you liked it
@seshasai7348 Жыл бұрын
@RezaDorrani yes reza. Really I liked it.
@jasonthedogcatcher2 жыл бұрын
So very helpful as always, Reza. The way you present your content is clear, very thorough and easy to understand.
@RezaDorrani2 жыл бұрын
Thank You Jason!
@gladysaguilera22905 ай бұрын
amazing, I have been trying to do this for almost a week and this worked perfect thank you
@RezaDorrani5 ай бұрын
You’re most welcome
@maamirkhan2005 Жыл бұрын
Great great work, Reza! I really got a lot out of this video.
@RezaDorrani Жыл бұрын
Glad to hear it!
@kaushar. Жыл бұрын
You made Power platform so easy to use. Thank you for this wonderful content. You resemble Jake Gyllenhaal, I mean when I see your video I see Jake Gyllenhaal. :)
@RezaDorrani Жыл бұрын
Thanks so much! Reza the doppelgänger :)
@kaushar. Жыл бұрын
@@RezaDorrani thank you Reza. Do you have tutorials/channel on other topics like Spfx, Azure, RPA, DevOps? I would love to learn from you.
@RezaDorrani Жыл бұрын
@@kaushar. My channel has a lot of topics but not spfx or devops.
@kaushar. Жыл бұрын
@@RezaDorrani Appreciate your for quick response. Thank you🙏
@victorb91755 ай бұрын
Ви дууууже допомогли! Щиро вдячний! Лайк і підписка однозначно!
@RezaDorrani5 ай бұрын
Дякую
@frenamakenson98443 жыл бұрын
Thx man, You solve my 12 weeks problems... amazing video
@RezaDorrani3 жыл бұрын
Happy to know the video resolved your problem. Thanks for watching.
@sairamn28633 жыл бұрын
Excellent tutorial..
@RezaDorrani3 жыл бұрын
Glad you liked it!
@shashanksundar83356 ай бұрын
Thanks for the video Reza, it was very helpful
@RezaDorrani6 ай бұрын
Glad it helped
@GozersHouse Жыл бұрын
Amazingly useful video, needed this exactly today, covered perfectly and easy to follow❤
@RezaDorrani Жыл бұрын
So happy to hear that. Thanks so much for watching.
@ConnectNayabAbidi2 жыл бұрын
This a amazing and helpful. Thanks a lot Reza👍
@RezaDorrani2 жыл бұрын
My pleasure 😊
@god_hacker5813 жыл бұрын
Thanks a lot. Explained it very nicely like in your every video.
@RezaDorrani3 жыл бұрын
Thank You
@jonneybravo2 жыл бұрын
Great video and much appreciated........
@RezaDorrani2 жыл бұрын
Glad you enjoyed it
@traceyharper312 жыл бұрын
Great video, really helpful. Thanks
@RezaDorrani2 жыл бұрын
Glad it was helpful!
@millyq34073 жыл бұрын
Reza you are my hero! hehehehe you have no idea how much your videos have and are helping me, im a fan! thank you so much for the time you invest on these and also the knowledge that you share. Thank you! are you coming out with a book or something?
@RezaDorrani3 жыл бұрын
Wow, thanks for your kind words. I am no hero, just a simple guy who loves to share his work. I have had a lot of offers to author books, but I had to turn them down since I am focusing on my KZbin channel. In future I may think about writing a book. Never say never.
@millyq34073 жыл бұрын
@@RezaDorrani well dear if you ever decide to do it, I’ll be buying! Keep up the good work, you make it look easy and actually motives me to keep learning
@RezaDorrani3 жыл бұрын
@@millyq3407 Thank You 🙏
@williammurray9962 жыл бұрын
An excellent video that will save me an awful lot of time!
@RezaDorrani2 жыл бұрын
Glad to hear that. Thanks for watching.
@sahilthakur033 жыл бұрын
Simply awesome Reza. This is so cool.. there is always something new to learn in your videos like the lookup and manage metadata filters.
@RezaDorrani3 жыл бұрын
Thank you Sahil.
@Michael-lo3ht3 ай бұрын
Thanks. Very helpful as usual.
@RezaDorrani3 ай бұрын
Most welcome!
@TheKermit21102 жыл бұрын
What a fantastic video. So clear and so detailed
@RezaDorrani2 жыл бұрын
Thanks so much!
@Agtorres993 жыл бұрын
Very nice video. Very useful for all the things I do with sharepoint lists at work
@RezaDorrani3 жыл бұрын
Thanks for watching
@robinjamesnjarlely3 жыл бұрын
Awesome Video.
@RezaDorrani3 жыл бұрын
Thanks!
@anselmojg2 жыл бұрын
This is a great video! Helped to solve how to query a lookup column. Thank you!
@RezaDorrani2 жыл бұрын
Glad to hear that. Thanks for watching.
@siddorachid8433 жыл бұрын
Hi REZA, Thanks a lot for this helpful and valuable video. I'M interesting to knox how to select just the columns I need from my SharePoint list, if you already have a video on this subject. Again Thanks very much
@RezaDorrani3 жыл бұрын
Either create a view and when querying select the view or use Select data operation as shown in this video - kzbin.info/www/bejne/jJ-6mGB7pN1mbbM
@siddorachid8433 жыл бұрын
@@RezaDorrani I get it. I could not thank you enough for your help. Be blessed...Peace and Love
@venkatakrishnadaddolu3353 жыл бұрын
All i can say that "Salute" for your contribution
@RezaDorrani3 жыл бұрын
Thank You
@jeffthomae63216 күн бұрын
Your videos are GREAT!! I've learned a ton. I'm trying to do birthday emails, but struggling to figure out the query syntax of the Month-day query against today's Month-day term. Any help would be greatly appreciated!!
@RezaDorrani6 күн бұрын
Thanks so much. There should be expression functions for date to get month and day terms. I have not tried those, hence not sure of the syntax. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@aerysch423 жыл бұрын
Helped me a lot! Thank you very much. Was able to throw a chunk of steps in some flows right away.
@RezaDorrani3 жыл бұрын
Glad it was helpful and thank you for watching
@donnaharrilal99362 жыл бұрын
Hi Reza, were you developer of Power Apps and Power Automate ? You know it so well. Thanks for your very helpful videos. I have learned a lot.
@RezaDorrani2 жыл бұрын
I was not :)
@manikyakotni54933 жыл бұрын
Thanks a lot Reza for the valuable content in your videos. Very nicely explained with every single detail. Appreciate your knowledge sharing. Great Work!!!
@RezaDorrani3 жыл бұрын
Thank you
@mollychen1400 Жыл бұрын
Many many thanks. It really helps!
@RezaDorrani Жыл бұрын
Glad it helped!
@365g3 жыл бұрын
Cheers Reza - Great video and great topic, comprehensively covered as always. This will be my go-to guide for all things OData in Power Automate!...
@RezaDorrani3 жыл бұрын
Great to hear! I hope this becomes the go-to guide for everyone :)
@ArohShukla3 жыл бұрын
@@RezaDorrani you are Power House when it comes to Power Platform. Another excellent video and sharing your knowledge. You ARE THE BEST!
@RezaDorrani3 жыл бұрын
@@ArohShukla Thank you Aroh
@365g2 жыл бұрын
@@RezaDorrani Just dipping back into my ODATA go-to guide :-) - quality resource⚡
@RezaDorrani2 жыл бұрын
@@365g 👍
@johnneely14393 жыл бұрын
Reza - This was a Great video, help me figure out what I was doing wrong Thank You!
@RezaDorrani3 жыл бұрын
Happy to hear the video is helpful
@danilosantos9580 Жыл бұрын
Amazing! Thank you so much
@RezaDorrani Жыл бұрын
Most welcome
@DoersGen2 жыл бұрын
Awesome Reza, loved it..
@RezaDorrani2 жыл бұрын
👍
@charlesdawnbeltran96032 жыл бұрын
Great video again. I have a Date and Time column but my output data from List is added with +4 hours.
@RezaDorrani2 жыл бұрын
Flow always works with dates and times in UTC format. You will need to convert it using expressions. Check kzbin.info/www/bejne/hWqaepd5l8uAh6s
@jhowery38233 жыл бұрын
Thank you. I was struggling with OData filtering. I could not get the column name right, and honestly, I don't think I would have guessed the format. This cut my flow time in half.
@RezaDorrani3 жыл бұрын
Glad it was helpful! Thank you for watching.
@ajd23442 жыл бұрын
Really great tutorial with good pacing and explanations. Thank you!
@RezaDorrani2 жыл бұрын
You're very welcome!
@Mamaral12342 жыл бұрын
Fantastic! You helped me a lot! Thank you very much Reza!
@RezaDorrani2 жыл бұрын
Your most welcome!
@fourthscorner98143 жыл бұрын
You saved me again! Keep them coming! Thank you Reza!
@RezaDorrani3 жыл бұрын
You are most welcome.
@macetennison90283 жыл бұрын
Great as always! Miss getting to work with you!
@RezaDorrani3 жыл бұрын
Hey, thank you. Is this Mace?
@macetennison90283 жыл бұрын
@@RezaDorrani yes sir! Hope you are enjoying some time off!
@RezaDorrani3 жыл бұрын
@@macetennison9028 Sure am. Happy Holidays to you and your family.
@balaji8303 жыл бұрын
Another great Video. Appreciate your tutorials.
@RezaDorrani3 жыл бұрын
Glad you like them!
@madihasalman13 жыл бұрын
Best videos ! Reza
@RezaDorrani3 жыл бұрын
Thank you Madiha
@edwinjonah3 жыл бұрын
This is amazing, thank you! I've meaning to do this and your video explains it very clearly.
@RezaDorrani3 жыл бұрын
Glad it was helpful! Thank you for watching.
@StraussBR2 жыл бұрын
Great content mate Good Job!
@RezaDorrani2 жыл бұрын
Thanks a ton!
@sankhlayashraj6 ай бұрын
Another great video Reza. Learnt a lot of the filtering. I just had one question. In my use case, I have a choice column that is updated by users in power apps via an editable gallery loaded with info. I am planning to send an email to defaulters who have not updated the said column using dropdowns. How can I filter blank or null value using o data filter query.
@RezaDorrani6 ай бұрын
I think I did 2 videos on this topic and tried showing many concepts like blank and or null. You can try checking the videos. I have done them long back so dont remember the formulas by heart.
@ThomasPoth3 жыл бұрын
Thank you so much, you clarified a lot with this excelent video 👍
@RezaDorrani3 жыл бұрын
Glad it was useful. Thank you for watching Thomas.
@kapiljoshi56032 жыл бұрын
Nice
@RezaDorrani2 жыл бұрын
Thanks
@motivadxs2 жыл бұрын
Thank you. Very helpful!
@RezaDorrani2 жыл бұрын
Most welcome
@vinayayinapurapu3 жыл бұрын
before asking question, i know i should applaud you. Tell me one area where you are not good at.. May be i can focus there lol :). You are truly a master. Instead of writing OData queries can i set up a view and query against the result set? In which cases is it better to go for list view vs OData query?
@RezaDorrani3 жыл бұрын
SharePoint views are only to restrict the columns returned. It does not actually perform the query in that view. So OData is a must.
@vinayayinapurapu3 жыл бұрын
@@RezaDorrani got it
@comtuner17 Жыл бұрын
Great presentation! Your videos have been of tremendous value as I use Power Automate. I do have a question about your "Number of Records in Result." Would you share how to build this data operation please?
@RezaDorrani Жыл бұрын
Thanks. This video was done years ago. You will have to point me to the time in the video where number of records in result was shown.
@confusedseth Жыл бұрын
@@RezaDorrani It is skipped right after this moment. kzbin.info/www/bejne/r5akn6iKd51om8k You bridge from creating the HTML table directly to sending the email, thus skipping the, "Number of Records in Result." panel.
@RezaDorrani Жыл бұрын
As I said this video was done a while ago and hence do not remember the specifics. Use the length expression to get the number of results.
@rohitbareja37593 жыл бұрын
HI Reza Your videos help me a lot. Can you please make a video on designing the email template and how are you capturing the records in a table format. That would be really helpful. Thanks
@RezaDorrani3 жыл бұрын
I have it in my backlog and one that is set as medium priority.
@fluhlej2 жыл бұрын
Seriously great video! thank you
@RezaDorrani2 жыл бұрын
Glad it was helpful!
@MarcoSessa3 жыл бұрын
Thank you for this great video!!!
@RezaDorrani3 жыл бұрын
Most welcome
@brunovannoten55802 жыл бұрын
Thank you! 👍
@RezaDorrani2 жыл бұрын
You're welcome!
@aminekarouach38913 жыл бұрын
well done. excellent work Thanks
@RezaDorrani3 жыл бұрын
Thank you! Cheers!
@miharold3 жыл бұрын
The best video to explain this :D I really recomended it
@RezaDorrani3 жыл бұрын
Wow, thanks!
@robh2489 Жыл бұрын
This is really useful thank you. I want to filter my items by the most recent item, would you know a OData query for that?
@RezaDorrani Жыл бұрын
Use sort descending by Created date
@smaug3045 Жыл бұрын
Hi Reza, is there a way in the Filter Query when using multiselect choice columns instead of hardcoding in the values, I can dynamically add them, so for example instead of searching on 'English', 'Geography' I can use the value filtered on my Combo box that I have filtered using multiselect. So in this example I would substitute 'English Geography' with cboSubjects, so it is dynamic and taken from the PowerApp. Thanks for all your hard work.
@RezaDorrani Жыл бұрын
It is possible. It will require you to construct your query as a variable and then add it to filter query property. I don’t have a video reference on this though. You can give it a try and in case of issues you can leverage the forums for help powerusers.microsoft.com
@eduhazard3 жыл бұрын
Fantastic!
@RezaDorrani3 жыл бұрын
Thank you! Cheers!
@eduhazard3 жыл бұрын
@@RezaDorrani I have a question, my date column is a Calculated type, doesn't appear in the "Filter Query". What is the best approach to solve this? Can I apply a rule before to change a calculate column into a date and then use the results as you showed? Thank you
@RezaDorrani3 жыл бұрын
@@eduhazard You could apply an expression in the filter query.
@RuSalas Жыл бұрын
Another Video gem! Question: Is it possible to sort by another field? Example 3 columns, One title, one is queue position and one is status. I want to sort all new by queue position in the HTML?
@RezaDorrani Жыл бұрын
When performing get items, it also has an order by property. You can specify the column and order direction.
@RuSalas Жыл бұрын
@@RezaDorrani I saw that, but only the "New" status have a queue position. Other Status do not. Thank you for your reply, I've learned so much from your videos. 🙏
@jayendrakhadikar12913 жыл бұрын
Thanks lot. 🙏
@RezaDorrani3 жыл бұрын
You're most welcome
@lymitutit30462 жыл бұрын
Very nice video.. I've watched all your videos.. but i couldn't find an vodeo over filtering S.P lists by an lookup variable. For example SP list ( A) has a lookup column which take the values form another list ( B) from the colimn Title ( string) . Now I'd like to filter the list B by the already chosen value at the lookup column at the list A. I'm struggling to find a reliabel solution,, but I can't . All sugestion on this subject would be very very helpful.
@RezaDorrani2 жыл бұрын
22:20 onwards in the video is about the Lookup Column.
@piyushborkar1988Ай бұрын
Thank you for the video, awesome, I have question that I want to filter query current month wise please advise on dynamic expression
@RezaDorraniАй бұрын
Most welcome! I would have to try that out to know the expression. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@richarddiasribeiro4293 жыл бұрын
thank you so, so much!!!
@RezaDorrani3 жыл бұрын
You're welcome!
@mallelajyothi98197 ай бұрын
Thanks reja... Clear explanation ,but in the last one multiple texonomy fields how to write the query
@RezaDorrani7 ай бұрын
I would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@daleyon40653 жыл бұрын
As always amazing video! 💯
@RezaDorrani3 жыл бұрын
As always thank you for watching and finding it useful :)
@sa4ita2 жыл бұрын
Hi Reza. Your videos helped me a lot in order to understand how can I best use power automate's functionalities. I would like to ask you one question which I haven't found answer so far. When using Get Items - properties only I receive properties surrounded by curly braces e.g {VersionNumber}. Is it possible to use them in the filter query? If yes, how exactly? Thanks!
@RezaDorrani2 жыл бұрын
Thanks. I believe a certain set of columns are supported. Not sure about {} based functions. I will recommend checking on the forums at powerusers.microsoft.com/
@sa4ita2 жыл бұрын
@@RezaDorrani Already did that and found that other users had the same problem, unfortunately no official solution or answer so far. The only workaround I found is to use array filter.
@RezaDorrani2 жыл бұрын
@@sa4ita Then maybe that is the only option.
@cherukurichaitanyaganesh86943 жыл бұрын
This made my day super coolllll
@RezaDorrani3 жыл бұрын
Thank You :)
@lekkerek2 жыл бұрын
GOLD!
@RezaDorrani2 жыл бұрын
Thank You for watching.
@queren78063 жыл бұрын
Thanks Reza, this is amazing! Do you have a video showing the tricks for sorting? I got a request that they need to sort items by an ID from another lookup table. Thanks.
@RezaDorrani3 жыл бұрын
I do not have videos on sorting. I do have a couple of sample flows for sorting in my GitHub repo which may help. Check github.com/rdorrani/Microsoft-Flow
@madhurishirsat93032 жыл бұрын
Thank you for your video Reza! I have scenario where SharePoint form should be available only for 3 days window in every quarter..& we need to send an email reminder to fill that form in 3 days..How to achieve this as window date list and actual list are 2 seperate lists. Thank you in advance!
@RezaDorrani2 жыл бұрын
I do not have a specific video on this scenario & would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@madhurishirsat93032 жыл бұрын
@@RezaDorrani Sure! Thanks for your response.
@sundrapillay66683 жыл бұрын
Thanks Reza have a blissful christmas
@RezaDorrani3 жыл бұрын
Thank you Sundra. Merry Christmas!
@TheBananisen2 жыл бұрын
Dear Reza! Always getting back to this fab video.✨. A question related to Lookup fields Is it possible to set an odata query filter on a count related column. I would like to filter the "motherlist" item only with "children" eg count related ne 0. Any idea?
@RezaDorrani2 жыл бұрын
Thanks for keeping it as a reference. I also keep coming back to this video :) I don't think it is possible to perform nested filters. You would have to first query your secondary list, get results and accordingly query the main list. I have never come across this scenario. I would recommend to check on the forums at powerusers.microsoft.com/
@kmuralikrishna15823 жыл бұрын
Great ... In this case, how can we check if that(Get Items) is retrieving duplicate records? Means using title trying to find/get a record, If the records exist more than once, flow will catch those to get records but, we need to understand is that one record or more, how can we check..? using condition or any idea
@RezaDorrani3 жыл бұрын
You would have to get items and then filter them and check for duplicates. I do not have a video on this specific use case. I will recommend you check on the forums at powerusers.microsoft.com/
@kmuralikrishna15823 жыл бұрын
@@RezaDorrani okay
@MohammadAli-ts2ev2 жыл бұрын
Hi Reza, Thank you for the treasure of information. Plz let us know as how to pass an array to the Odata filter query. Eg. I have to filter an excel online table with filter criteria being multiple locations. How can I do that??
@RezaDorrani2 жыл бұрын
Thanks for watching and liking the content. I don't believe arrays as filter query is an option. I will recommend you check on the forums at powerusers.microsoft.com/ in case someone has a solution.