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 !!
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!!!
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.
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 🙏
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.
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.
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.
Thanks for covering Power automate with SharePoint online. looking forward and excited to see more videos on SharePoint online capabilities with Power Platform.
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.
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.
@@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
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/
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?
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 TH-cam channel. In future I may think about writing a book. Never say never.
@@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
Thanks a lot Reza for the valuable content in your videos. Very nicely explained with every single detail. Appreciate your knowledge sharing. Great Work!!!
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. :)
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.
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.
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
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 It is skipped right after this moment. th-cam.com/video/yeAnuTB85eg/w-d-xo.html You bridge from creating the HTML table directly to sending the email, thus skipping the, "Number of Records in Result." panel.
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!!
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
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.
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
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!
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/
@@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.
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.
Hi Reza, it is always very helpful to follow you. Using 'Get Files (properties only)' I can filter the Modified column but it looks like the filter of Created column does not work properly. I even tried to filter it using the same string I got for a specific ID (I mean: Created eq '2021-03-04T08:09:22Z') to get 0 results. Could you please let me know if there are issues filtering the Created column (or if I missed a relevant comment in your video)? Thanks, Sergio
@@RezaDorrani Hi Reza, thanks for your kind reply. Actually I was using an expression but I always got 0 results (unless I used a very large filter). That led me to the solution. Since I was filtering a library with more than 5000 files, I added also the 'Order by' condition 'ID desc' to get the files I was looking for. ciao, Sergio
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.
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
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
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 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. 🙏
Hi Reza, Do you have videos about the data operations you showed briefly in this video? "Select", "HTML table" and how to put it together in the email?
Hi Reza - thanks for great video! You mentioned at the start the 5000 threshold. I have a sharepoint list over 5000 items (lets say 8000) - is the limit about the number of items returned or queried? for example, if I queried the sharepoint list, would the query be on the first 5000 items or would it be on the 8000?
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?
Hi Reza, again this is an top video from you. Thank you! Is there an option to use filter query also with calculated fields? Or do I put the calculated data with power automate in another field to choose?
Hi Reza, so informative..I have one doubt , how to extract all list line items to excel or CSV file in the same format from SharePoint list...I have been searching this excel to connect power bi since direct connection taking so much time to refresh in the power bi full load.. Please advice.
There is a data operation related to CSV. You can directly use that and provide it the Items obtained from the SharePoint list items query. Not sure about your use case with Power BI direct query. I will recommend you check on the forums at powerusers.microsoft.com/
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!
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
Thank you so much for sharing this, Reza, I found this incredibly helpful. I’m trying to set something up very similar to this, but instead of student name as a string, I have person or group column. Sometimes with multiple users in that column. When I follow the steps in this video, the select action returns everything from the ‘Person/Group’ object. Is there a way I can return just the display name from the person group object when using the select function?
I believe you would have to use expressions to grab them from the person type object. Check on the forums to see if someone has posted an expression or post a screenshot of your response at powerusers.microsoft.com/
Hey Reza. I am trying something similar, however, still unable to do it. I have a SharePoint List that I am trying to retrieve data from. Different users enter multiple items per week. I want to filter by date which is a NOw to Last week at the same time and filter by Unique EMails. This means this is a scheduled trigger So as I send the Email it should contain the information of unique people and the last items information like Date. How should I tackle this in Power Automate get items.
I do not have a video reference on this scenario and 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
Hi Reza - Thanks for at very nice video. Always nice to see the new features. Unfortunately all my colums from the sourcelist is not show in the "select an item" view. Any idea why?
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
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
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/
Reza, Thank you for this nice video. All your examples are about filtering columns against absolute values. Do you have examples where you filter against dynamic content like value which is received via power apps or variable?
Thanks for this awesome instructional vid, Reza! 😃 I have challenges with filtering data from my SP List because it's approx. 30k records (and growing). Do you have any tips for someone filtering a larger data set?
When applying filters, ensure that your columns you are filtering on are indexed. You can index columns from list settings. Max of 20 indexes per list.
Hey Reza, It's an awesome video in filter. Thank you so much. How can we filter excel online using multi-select inputs from the user. For example, I have to filter the STATUS column (of an excel online table) where the status are 'Pending', 'completed,'Not Started'... Any help would be grately appreciated.
Hi Reza, as always, thank you for this video! My data source is SQL and haven't find how to write the create date expression. Do you have a video or blog that you can share? I've been looking for the last couple of days and tried different expressions but I'm getting errors. Thank you
Hi Reza: Thank you for this very needed and most frequently used Topic. I have referred to this video many times by now. I appreciate the knowledge well explained. I, however have a question. My library has values for a given record only in the system columns. Such as: ID, Name, Created, Created By, Modified and Modified By. I need to select part of the file name/folder name and compare with a value. My OData could be: Name contains 'ID'. However, I get an error Name column does not exist! Nor can I see Name column in the Library Setting either. OData does not allow system columns such as Name nor it will allow a calculated column if I circumvented by replicating the Name column to a calc column. Any thoughts on how to handle a situation like this?
I dont think calc columns are supported. I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
This video is a Public Utility. Thanks a lot Reza
Thanks 😊
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 !!
Thank you for your kind words and welcome to the channel. I hope to keep providing valuable content.
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!!!
Your are most welcome and thanks so much for the appreciation
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.
Glad I could help
Reza, not only do I enjoy your vids, I learn so much from them.... Much appreciated.
Thank You 😊
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 🙏
Awesome!
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.
Thanks a ton for the amazing feedback.
May be I am not so good at tagging my videos I guess.
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
Yes - its been 2 years :)
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.
Thank you for watching and thanks for the sub. Welcome to my channel.
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.
You're most welcome! Thanks for sharing your scenario.
Thanks for covering Power automate with SharePoint online. looking forward and excited to see more videos on SharePoint online capabilities with Power Platform.
You are welcome and much more to come!
Thanks!
Thank You!
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.
Thank You Jasmin
This experimental feature just saved me a huge headache, and solved my problem in a couple minutes. Thank you!
Thank you for watching.
The new interface for building ODATA queries will make life much easier :-) Great video as always.
Totally agree and thanks for watching.
You truely are a master of Power Automate and of teaching it... ☝️
Thank you for the great video 👍
Thank you Thomas. I will keep trying my best.
Thanks a lot. I was having trouble with boolean fields and now I'ld can go ahead. Excellent video.
You are welcome!
Very helpful video and explanation for those of us whom are new to "Flows" and find it overwhelming.
Thank You
OMG😮.. Masterclass explanation with clear contents.. One of the best explanation I've ever seen.. Thank you for the clear explanation 👍🏻
Thanks Mani
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.
@@manirathinam8161 check video again to see how I filter on yes/no type columns
@@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
@@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
So very helpful as always, Reza. The way you present your content is clear, very thorough and easy to understand.
Thank You Jason!
You're a Genius Reza ! You saved my day
Thanks!
Excellent explanation! Thank you for making these types of things easier to understand!
You're very welcome!
This is an absolutely Master Class tutorial.
Thanks Harry
I was struggling with filter query drop down option enabling. This video helps me a lot
Glad to hear the video is useful
Ви дууууже допомогли! Щиро вдячний! Лайк і підписка однозначно!
Дякую
amazing, I have been trying to do this for almost a week and this worked perfect thank you
You’re most welcome
Thx man, You solve my 12 weeks problems... amazing video
Happy to know the video resolved your problem. Thanks for watching.
Thank you very much this video had helped in solving some of my long-standing odata filter issues .
Glad it helped
Simply awesome Reza. This is so cool.. there is always something new to learn in your videos like the lookup and manage metadata filters.
Thank you Sahil.
Wow Reza, your videos are always with all the details and examples. You are awesome 😊
Glad to hear that! Thanks so much
@@RezaDorrani You're welcome and keep supporting and guiding your viewers😊
@@RezaDorrani I created one flow and followed all the steps to apply Odata Filter query in Get data but showing Output as 'Value' = [ ].
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/
@@RezaDorrani Sure, thank you!
All i can say that "Salute" for your contribution
Thank You
Thank you, that help me do finish my job again
Glad to hear that
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?
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 TH-cam channel.
In future I may think about writing a book. Never say never.
@@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
@@millyq3407 Thank You 🙏
Really, it was a great video reza. I am very grateful to you
Glad you liked it
@RezaDorrani yes reza. Really I liked it.
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!...
Great to hear! I hope this becomes the go-to guide for everyone :)
@@RezaDorrani you are Power House when it comes to Power Platform. Another excellent video and sharing your knowledge. You ARE THE BEST!
@@ArohShukla Thank you Aroh
@@RezaDorrani Just dipping back into my ODATA go-to guide :-) - quality resource⚡
@@365g 👍
Thanks a lot Reza for the valuable content in your videos. Very nicely explained with every single detail. Appreciate your knowledge sharing. Great Work!!!
Thank you
Helped me a lot! Thank you very much. Was able to throw a chunk of steps in some flows right away.
Glad it was helpful and thank you for watching
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. :)
Thanks so much!
Reza the doppelgänger :)
@@RezaDorrani thank you Reza. Do you have tutorials/channel on other topics like Spfx, Azure, RPA, DevOps? I would love to learn from you.
@@kaushar. My channel has a lot of topics but not spfx or devops.
@@RezaDorrani Appreciate your for quick response. Thank you🙏
An excellent video that will save me an awful lot of time!
Glad to hear that. Thanks for watching.
Very nice video. Very useful for all the things I do with sharepoint lists at work
Thanks for watching
Amazingly useful video, needed this exactly today, covered perfectly and easy to follow❤
So happy to hear that. Thanks so much for watching.
This is a great video! Helped to solve how to query a lookup column. Thank you!
Glad to hear that. Thanks for watching.
Thank you very much for the video. It helps a lot and i appreciate all the details and explanations. Very good job
You are most welcome!
What a fantastic video. So clear and so detailed
Thanks so much!
Great great work, Reza! I really got a lot out of this video.
Glad to hear it!
You saved me again! Keep them coming! Thank you Reza!
You are most welcome.
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.
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.
Excellent delivery
Thanks
Reza - This was a Great video, help me figure out what I was doing wrong Thank You!
Happy to hear the video is helpful
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
Either create a view and when querying select the view or use Select data operation as shown in this video - th-cam.com/video/VnWg-Eox37Q/w-d-xo.html
@@RezaDorrani I get it. I could not thank you enough for your help. Be blessed...Peace and Love
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?
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.
@@RezaDorrani It is skipped right after this moment. th-cam.com/video/yeAnuTB85eg/w-d-xo.html
You bridge from creating the HTML table directly to sending the email, thus skipping the, "Number of Records in Result." panel.
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.
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!!
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
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.
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
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!
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/
@@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.
@@sa4ita Then maybe that is the only option.
Really great tutorial with good pacing and explanations. Thank you!
You're very welcome!
Excellent tutorial..
Glad you liked it!
Thanks a lot. Explained it very nicely like in your every video.
Thank You
Another great Video. Appreciate your tutorials.
Glad you like them!
Thanks for the video Reza, it was very helpful
Glad it helped
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.
Glad it was helpful! Thank you for watching.
Hi Reza,
it is always very helpful to follow you.
Using 'Get Files (properties only)' I can filter the Modified column but it looks like the filter of Created column does not work properly. I even tried to filter it using the same string I got for a specific ID (I mean: Created eq '2021-03-04T08:09:22Z') to get 0 results.
Could you please let me know if there are issues filtering the Created column (or if I missed a relevant comment in your video)?
Thanks, Sergio
You would have to use expressions.
Check this thread - powerusers.microsoft.com/t5/Building-Flows/Get-items-Filter-Query-Created/td-p/113917
@@RezaDorrani Hi Reza, thanks for your kind reply.
Actually I was using an expression but I always got 0 results (unless I used a very large filter). That led me to the solution. Since I was filtering a library with more than 5000 files, I added also the 'Order by' condition 'ID desc' to get the files I was looking for.
ciao, Sergio
This is amazing, thank you! I've meaning to do this and your video explains it very clearly.
Glad it was helpful! Thank you for watching.
This a amazing and helpful. Thanks a lot Reza👍
My pleasure 😊
Fantastic! You helped me a lot! Thank you very much Reza!
Your most welcome!
Great video and much appreciated........
Glad you enjoyed it
Awesome Reza, loved it..
👍
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.
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
Great video, really helpful. Thanks
Glad it was helpful!
Great as always! Miss getting to work with you!
Hey, thank you.
Is this Mace?
@@RezaDorrani yes sir! Hope you are enjoying some time off!
@@macetennison9028 Sure am. Happy Holidays to you and your family.
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.
I was not :)
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
I have it in my backlog and one that is set as medium priority.
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?
When performing get items, it also has an order by property. You can specify the column and order direction.
@@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. 🙏
Thanks. Very helpful as usual.
Most welcome!
Great content mate
Good Job!
Thanks a ton!
Hi Reza, Do you have videos about the data operations you showed briefly in this video? "Select", "HTML table" and how to put it together in the email?
Check th-cam.com/video/TCIr7Bc3Oko/w-d-xo.html
Video description has links to download the sample flows as well.
@@RezaDorrani Thank you! Looking forward as always
Hi Reza - thanks for great video! You mentioned at the start the 5000 threshold. I have a sharepoint list over 5000 items (lets say 8000) - is the limit about the number of items returned or queried? for example, if I queried the sharepoint list, would the query be on the first 5000 items or would it be on the 8000?
Query would be on 8000. Result returned would be max 5000.
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?
SharePoint views are only to restrict the columns returned. It does not actually perform the query in that view. So OData is a must.
@@RezaDorrani got it
Awesome Video.
Thanks!
Hi Reza, again this is an top video from you. Thank you! Is there an option to use filter query also with calculated fields? Or do I put the calculated data with power automate in another field to choose?
Oh I've seen you answered this in your video: th-cam.com/video/I8FdUmECAn8/w-d-xo.html. Thank you again ☺
Calculated columns are not supported in odata queries.
Hi Reza, so informative..I have one doubt , how to extract all list line items to excel or CSV file in the same format from SharePoint list...I have been searching this excel to connect power bi since direct connection taking so much time to refresh in the power bi full load..
Please advice.
There is a data operation related to CSV. You can directly use that and provide it the Items obtained from the SharePoint list items query.
Not sure about your use case with Power BI direct query.
I will recommend you check on the forums at powerusers.microsoft.com/
@@RezaDorrani thank you ... 👍
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?
Use sort descending by Created date
The best video to explain this :D I really recomended it
Wow, thanks!
Thank you so much, you clarified a lot with this excelent video 👍
Glad it was useful. Thank you for watching Thomas.
Great video again. I have a Date and Time column but my output data from List is added with +4 hours.
Flow always works with dates and times in UTC format. You will need to convert it using expressions.
Check th-cam.com/video/O97IdCbfMQI/w-d-xo.html
Many many thanks. It really helps!
Glad it helped!
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!
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
@@RezaDorrani Sure! Thanks for your response.
As always amazing video! 💯
As always thank you for watching and finding it useful :)
Thank you so much for sharing this, Reza, I found this incredibly helpful. I’m trying to set something up very similar to this, but instead of student name as a string, I have person or group column. Sometimes with multiple users in that column. When I follow the steps in this video, the select action returns everything from the ‘Person/Group’ object. Is there a way I can return just the display name from the person group object when using the select function?
I believe you would have to use expressions to grab them from the person type object.
Check on the forums to see if someone has posted an expression or post a screenshot of your response at powerusers.microsoft.com/
Hey Reza. I am trying something similar, however, still unable to do it. I have a SharePoint List that I am trying to retrieve data from.
Different users enter multiple items per week.
I want to filter by date which is a NOw to Last week at the same time and filter by Unique EMails. This means this is a scheduled trigger
So as I send the Email it should contain the information of unique people and the last items information like Date. How should I tackle this in Power Automate get items.
I do not have a video reference on this scenario and 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
@@RezaDorrani Thanks Rezza. Will be waiting for your video to come out soon.
@@derrickkuria4206 I will need a lot more folks requesting this topic in order for me to add it to my backlog.
Hi Reza - Thanks for at very nice video. Always nice to see the new features. Unfortunately all my colums from the sourcelist is not show in the "select an item" view. Any idea why?
Only a few column types are supported. I did mention it in the video.
Thank you for the video, awesome, I have question that I want to filter query current month wise please advise on dynamic expression
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
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
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/
@@RezaDorrani okay
Reza, Thank you for this nice video. All your examples are about filtering columns against absolute values. Do you have examples where you filter against dynamic content like value which is received via power apps or variable?
th-cam.com/video/UZdngrwWsqA/w-d-xo.html
@@RezaDorrani thank you! It was something that I was searching for! I tried it and it works perfectly! Thank you again for your work!!!
well done.
excellent work Thanks
Thank you! Cheers!
Amazing! Thank you so much
Most welcome
Thanks for this awesome instructional vid, Reza! 😃 I have challenges with filtering data from my SP List because it's approx. 30k records (and growing). Do you have any tips for someone filtering a larger data set?
When applying filters, ensure that your columns you are filtering on are indexed. You can index columns from list settings. Max of 20 indexes per list.
Hey Reza,
It's an awesome video in filter. Thank you so much.
How can we filter excel online using multi-select inputs from the user.
For example, I have to filter the STATUS column (of an excel online table) where the status are 'Pending', 'completed,'Not Started'...
Any help would be grately appreciated.
I believe the excel connector only offers single column filtering.
I will recommend you check on the forums at powerusers.microsoft.com/
Hi Reza, as always, thank you for this video!
My data source is SQL and haven't find how to write the create date expression. Do you have a video or blog that you can share?
I've been looking for the last couple of days and tried different expressions but I'm getting errors.
Thank you
I do not have a video related to SQL and flow.
I will recommend you check on the forums at powerusers.microsoft.com/
Best videos ! Reza
Thank you Madiha
Hi Reza: Thank you for this very needed and most frequently used Topic. I have referred to this video many times by now. I appreciate the knowledge well explained. I, however have a question. My library has values for a given record only in the system columns. Such as: ID, Name, Created, Created By, Modified and Modified By. I need to select part of the file name/folder name and compare with a value. My OData could be: Name contains 'ID'. However, I get an error Name column does not exist! Nor can I see Name column in the Library Setting either. OData does not allow system columns such as Name nor it will allow a calculated column if I circumvented by replicating the Name column to a calc column. Any thoughts on how to handle a situation like this?
I dont think calc columns are supported. I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you. I will do that.