Your videos are detailed yet succinct with lucid flow. The examples chosen for the concepts are great applicable solutions. Your channel is an absolute go-to whenever I’m looking for ways to implement an idea/functionality in PowerApps. Thank you!
@RezaDorrani
Жыл бұрын
Thank You so much for the awesome feedback! Makes me happy and motivated to keep creating quality content.
@felxelgato
15 күн бұрын
Thank you Reza for all you do. You've made my learning of SharePoint enjoyable.
@RezaDorrani
15 күн бұрын
Glad to hear it! Thanks so much for watching and learning from my videos.
@benjaminjones5544
Жыл бұрын
Another superb video Reza, so thank you. I was just think about globally how many businesses you are indirectly helping, by helping there employees build solutions to everyday business process issues.
@RezaDorrani
Жыл бұрын
Thank You so much
@hermitthelog6758
Жыл бұрын
You are a life saver my friend. I've been wrestling with syntax errors for an hour now with no luck. Thank you!
@RezaDorrani
Жыл бұрын
Most welcome
@user-dz5ut1nl8k
6 ай бұрын
WOW!! I've been trying to get a flow to work all day and couldn't find an answer. 5 seconds into your video, I was able to make it work. Thank you!! I've subscribed!!
@RezaDorrani
6 ай бұрын
Fantastic!
@melodyydunn
Жыл бұрын
Reza, You are Brilliant! Thank you! I always look for your training first. You explain things so clearly and concisely that it makes it easier to understand. Thank you for your time and effort in helping us "Citizen Developers" understand these new technologies!
@RezaDorrani
Жыл бұрын
Wow, thank you!
@keithwhittaker8727
23 күн бұрын
Thank you Reza. Once again you answered my question. I really do appreciate your videos, they make me look like I know what I'm talking about.
@RezaDorrani
23 күн бұрын
You’re most welcome! Keep learning
@MohammadAli-ts2ev
Жыл бұрын
Great great...many of the times I got stuck with multi filters...now things are clear. .thank you Reza bhai...
@RezaDorrani
Жыл бұрын
Always welcome
@TheFunkBros
Жыл бұрын
Been looking for hours how to do the lookup columns, 5 minutes here and its working... earned you a subscribe dude. Good stuff. Thanks.
@RezaDorrani
Жыл бұрын
Happy to hear that & thanks for the sub!
@philipcoltharp918
Жыл бұрын
Your aesthetics on your presentation are so smooth;best I've seen. Others should mimic you. Ditto to the other's compliments of your video's content.
@RezaDorrani
Жыл бұрын
Wow, thank you so much
Жыл бұрын
Kudos ❤ for the hint with joining with ' or ' the Selected mail Array of report to users and generating an ODATA query as an output. Thanks Reza!
@RezaDorrani
Жыл бұрын
Glad it was helpful! Thank You for watching.
@FrancescoZit
Жыл бұрын
Dear Reza, is your example only for a case in which you have a maximum of two direct reports, right?
@RezaDorrani
Жыл бұрын
@@FrancescoZit My AD had 2 members reporting to me. If there were more, it would pick them up.
@pepito7666
6 ай бұрын
Great video! You really helped me. I couldn't create the OData filter query, due to my column name, wich had spaces in the name, like "Fecha de consulta". I was like one hour trying and looking for how to solve my problem, but I decided to watch a video, and fortunately I got the solution in here. Many thanks!!!
@RezaDorrani
6 ай бұрын
Glad it helped!
@AnandhAdhithan
Жыл бұрын
Excellent tips on SP oData filters query. Really helpful in development scenarios!
@RezaDorrani
Жыл бұрын
Thanks Anandh
@kevinjoseph9023
Жыл бұрын
Fantastic work, excellent narration… Easy to follow. Thank you😊
@RezaDorrani
Жыл бұрын
Most welcome and thanks for watching
@tmcpang
4 ай бұрын
Reza, I love the way to explain stuff. It's short and clear. Thank you so much for creating video like this for us. I have a question related to querying a SharePoint list from Power Automates; how do I query against a multi-value choice field?
@RezaDorrani
4 ай бұрын
Thanks so much. I did 2 videos on this topic. Check and see if I covered it in other video if not then may be I never tried it. In that case I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@oluwatobipaul6171
Жыл бұрын
Thank you Reza. I learnt some new and shorter tricks like viewing the field name for each field, also working with the choice column in the experimental view
@RezaDorrani
Жыл бұрын
Glad to hear that!
@abhishekgowda218
Жыл бұрын
Reza bro you have seriously replied to every comment aah.....great one man !
@RezaDorrani
Жыл бұрын
Thanks Abhishek
@Jonasman1336
3 ай бұрын
You are a genius! Thanks for sharing your knowledge
@RezaDorrani
3 ай бұрын
Thanks so much
@stephanielachman717
10 ай бұрын
Thanks for your tips about how to turn on the advanced window for the filter query.
@RezaDorrani
10 ай бұрын
Most welcome
@rohtashsharma3496
Жыл бұрын
Wonderful video, your all videos are so knowledgeable that I can not leave without complete it. It is like a thriller movie watching experience for me.
@RezaDorrani
Жыл бұрын
Wow! Thanks so much. So happy to hear that. I try and ensure every min being watched has value for the viewer.
@rohtashsharma3496
Жыл бұрын
And, when people ask what is the source of knowledge or hacks - I recommend your channel. Keep doing it.
@RezaDorrani
Жыл бұрын
@@rohtashsharma3496 Thanks for recommending!
@DavidSmithBali
Жыл бұрын
You've just fixed a problem I've been stuck on for 3 days. I messed up 100 live entries of my sharepoint list
@RezaDorrani
Жыл бұрын
Glad to know the video was helpful
@santanup8567
Жыл бұрын
Hey Reza, Thanks for all your content..this really help us to understand the concepts fully. Also could you please make a video on the PowerApps native app capabilities! Cheers.
@RezaDorrani
Жыл бұрын
Native capabilities meaning?
@kannanr4563
Жыл бұрын
great tutorial as always, and your channel will be the first i review when ever i have some clarification with power query..
@RezaDorrani
Жыл бұрын
Great to hear! Thanks so much for watching and liking the videos
@user-qc4rf1qc4m
6 ай бұрын
Great video, the information you provided here is very valuable to me and has saved me a lot of time troubling with Get Items filtering.
@RezaDorrani
6 ай бұрын
Great to hear!
@wanessafs13
Жыл бұрын
This video was exactly what I look for. Thanks so much!
@RezaDorrani
Жыл бұрын
Glad it was helpful!
@sohananahid5302
29 күн бұрын
Great video! Thanks a lot, Reza! :)
@RezaDorrani
29 күн бұрын
Glad you liked it!
@tmyanh1993
Жыл бұрын
Wow, thank you very much. Your instruction is very easy and they solved my problems.
@RezaDorrani
Жыл бұрын
Glad to hear that! Thanks Mia.
@sagarreddy2273
Жыл бұрын
Hi Reza.I am one of the biggest follower of you.i just want to upload a video on how to create more than 10000 Records from Excel to Sharepoint.Which Will Really help a lot of people.On this scenario there is no much content anywhere
@RezaDorrani
Жыл бұрын
Check kzitem.info/news/bejne/1nuQr5OYanmkYKA
@revankampf
Жыл бұрын
You are SUPERB! Learned more from your one video than multiple others! Cheers and many thanks to you!
@RezaDorrani
Жыл бұрын
Wow, thanks!
@annasiwinska7750
18 сағат бұрын
Hey Reza! Thank you so much for this. I struggle still on one filter. How would you filter by maximum value in column?
@RezaDorrani
18 сағат бұрын
Simply sort by column in desc order and then set top count
@merristenzel7711
2 ай бұрын
Amazing as always, Reza! Thank you!!!
@RezaDorrani
2 ай бұрын
Most welcome!
@MrJamessonN
2 ай бұрын
Thank you so much! This was exactly what I was looking for!
@RezaDorrani
2 ай бұрын
You're very welcome!
@The06031984
2 күн бұрын
Great video!! :) For the email body, is it possible to include a link to the sharepoint item attachement?
@RezaDorrani
2 күн бұрын
Possible! Dynamic content should include link to item.
@hugofeltrindasilva2169
Жыл бұрын
Thanks Man, you saved my time! Following your channel now!
@RezaDorrani
Жыл бұрын
Most welcome! Thanks for the follow.
@komanglayang7861
Жыл бұрын
Hello Reza, thanks for the helpful content as always. I wonder if you can make more videos showcasing various scenarios on how to build apps with Microsoft SQL Server as the connector? The resources on this one is not as many and as comprehensive as SharePoint List as the connector and I find using SQL Server as the data source is very important as well. It would be very helpful if you can make more contents in this scope and I would appreciate it very much!
@RezaDorrani
Жыл бұрын
SQL is a premium connector and requires setup. SharePoint Online is easy for anyone to setup and build. I have got a few requests on SQL. Il be asking for video topics next month. Make sure to post it in community tab of mg KZitem channel. If it gets a lot of votes, I will plan something on it.
@komanglayang7861
Жыл бұрын
@@RezaDorrani I understand the concern for the premium connector, but for some of us who have the license for it, it would be unfortunate if we know very little on how to utilize it. I am looking forward to your updates for the video topics! Thank you as always.
@RezaDorrani
Жыл бұрын
@@komanglayang7861 If I get a lot of votes on it, I will consider it.
@TheYoutubeMethod
9 ай бұрын
I like the confidence from the start
@RezaDorrani
9 ай бұрын
Thank You!
@glaubercarvalho5242
Жыл бұрын
Very good class! thank you Reza.
@RezaDorrani
Жыл бұрын
Most welcome
@Wcbssg
7 ай бұрын
Good Tutorial Video. I want to ask if that filter query can be done if that is connect to Excel for Business
@RezaDorrani
7 ай бұрын
Possible with excel also. Check documentation for that.
@olenaoleary7218
Жыл бұрын
Brilliant!
@RezaDorrani
Жыл бұрын
Thank You
@abdulrahmanbaamer8624
10 ай бұрын
Great Reza; as usual, I want to filter a list that contains ~200,000 items, based on FileName (contains duplicates). Based on this filter, i want to update the field (validity), so the latest one is "Latest" and all others are "old". Combination of FileName and revision columns are unique items Thanks....
@RezaDorrani
10 ай бұрын
I do not have a video reference on this scenario and 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
@abdulrahmanbaamer8624
10 ай бұрын
@@RezaDorrani thanks, بارك الله فيك
@aducaale328
5 ай бұрын
Thank you very much Reza
@RezaDorrani
5 ай бұрын
Most welcome
@keithmaly904
7 ай бұрын
Another awesome video. Thanks Reza!!!
@RezaDorrani
7 ай бұрын
Glad you enjoyed it!
@gitaiganor4100
Жыл бұрын
Nice video as always!. The join part of the "select users" is not very clear. Not sure I understand the way the odata is being created in that case . Thank you Reza
@RezaDorrani
Жыл бұрын
Join is to combine the array values of select with " or " in order to formulate the query. If you try that out as shown in video, and run your flow, you can check output of each action and see how it formulates the query.
@gitaiganor4100
Жыл бұрын
@@RezaDorrani ❤thank you Reza for your response, question:how does it stand from the performance/speed aspect?. I need to filter 150 users from a large list of 2000 names ? What is the limitation ? Plus, is it more efficient/quick Compares to the odata "substringof" function in a large text string , string that has been built with the join?
@RezaDorrani
Жыл бұрын
@@gitaiganor4100 That is a hefty query. Large list is not an issue as long as columns are indexed in SharePoint. Max 20 indexes are allowed. Query would be performed server side, so combining things client side will not add value.
@mgmc64
Жыл бұрын
Excellent video as always, thanks
@RezaDorrani
Жыл бұрын
Most welcome
@TemTem111
11 ай бұрын
you are totally amazing, can i ask you for table html formatting that you used in this video ?
@RezaDorrani
11 ай бұрын
Thanks! I have done other videos on html formatting. Il recommend checking those.
@bobleach
Жыл бұрын
Thanks for another great video.👏 I already use the 'Experimental Features', but often turn it on for the like of creating complex Odata filters and then turn it off. Why? Becuase I find that it does sometimes affect other connectors (I guess that's why it's Experimental), for example when I use the Select and put it in Text mode (same as what you show in this video), save and exit the flow and go back in the Select completely wipes 😣
@bobleach
Жыл бұрын
And just like my previous comments on your videos, I thought I knew how to create the Odata filters just fine (with the Experimental features on and off), but yet again I still watched this and still learnt a few tricks too - Just shows its worth me watching all your videos.
@RezaDorrani
Жыл бұрын
Thanks for watching! For citizen developers, using this new GUI like filter query experience would be of big help. Use experimental, get the syntax for the odata filter query, then set experimental to false and continue :)
@RezaDorrani
Жыл бұрын
Thanks Bob!
@satendrasharma7459
4 ай бұрын
@Reza Dorrani, Thank you for your awesome video. I have query to filter current item status value below are syntax: Set Status (Set Variable): Status=list lookup, Source = Current item, field = status
@RezaDorrani
4 ай бұрын
Your syntax does not seem to be for power automation.
@satendrasharma7459
4 ай бұрын
This syntax from nintex and need to covert to powerautomate.
@RezaDorrani
4 ай бұрын
@@satendrasharma7459 I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@JustinBouchardw
Жыл бұрын
Great video, but i'm stuck on the lookup column. I get how that works for the primary column you are looking up, but if you have multi-select lookup columns, how would one get the seconary columns? In particular, if it has a space in the column header. Primary column is StudentNumber, other columns are Faculty, and Faculty Code. StudentNumber/Faculty works, but I can't figure out how to filter by faculty code!
@RezaDorrani
Жыл бұрын
I have not tried with secondary lookup columns. Check documentation on odata queries or check on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@shaikhfirdos2723
Жыл бұрын
Most useful.. Thanks Reza..👏
@RezaDorrani
Жыл бұрын
Welcome!
@user-yb4jg9ki8i
9 ай бұрын
Been pulling my hair our with the Lookup column type. Using an unfiltered Get Items was showing the data object with Value being the property holding the name string so I was assuming that was what you should use, not the column name on the source table.
@RezaDorrani
9 ай бұрын
Im hoping it worked now
@DroneEyes
Жыл бұрын
Great explanation Reza!
@RezaDorrani
Жыл бұрын
Thanks!
@maverickaguilar693
Жыл бұрын
Wow! Great video, Reza! Thank you very much. I have a question. What if I only want to get the latest item(s) created in my sharepoint list? Thanks.
@RezaDorrani
Жыл бұрын
Use sort created desc and top count.
@maverickaguilar693
Жыл бұрын
@@RezaDorrani Thank you for your reply but I'm not really sure how to do that 😅 Can you pls elaborate the steps for me. I hope you don't mind. 😅
@RezaDorrani
Жыл бұрын
@@maverickaguilar693 I do not have a video reference on this, hence giving the idea. If you need exact steps, then I would recommend checking or posting your query on forums at powerusers.microsoft.com
@jorgeblascoarnandis3644
Жыл бұрын
Thank you for the video! The same needs to be done for Dataverse. 🥴🥴
@RezaDorrani
Жыл бұрын
I agree!
@thurstanp
Жыл бұрын
Where do you get all this knowledge from, Reza? MS Powerautomate is not that old but your depth of practical examples is endless. Kudos.
@RezaDorrani
Жыл бұрын
Practice Practice Practice
@MegaKumar0
Жыл бұрын
Thanks Reza once again a good content..
@RezaDorrani
Жыл бұрын
Happy to hear that!
@CyberMG62
Жыл бұрын
Thanks in advance for all your Videos! Based on your example I created a flow that reads tables from an excel file and goes to update or create the related sharepoint lists but it happens that the items that are created by this flow are then not found by the 'get items' by applying a certain filter , I see all the other items but the ones I created with the flow don't. At the end they can never be updated and I don't find a solution.
@RezaDorrani
Жыл бұрын
I have not come across this scenario or this issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@CyberMG62
Жыл бұрын
I solved it by creating the indexing of the columns used in the query by going to the list settings -> Indexed columns -> Create a new index
@WalidBachiri
11 ай бұрын
Amazing tutorial !
@RezaDorrani
11 ай бұрын
Thank you!
@user-ts3ns1ce8j
10 ай бұрын
Wonderful video, truly. Am I able to create a filter query for a lookup column that is looking up a calculated column? On one list I have a lookup column that is showing person/group names from a calculated column. This shouldn't be an issue because I am using it as a lookup column, rather than a calculated column, right?
@RezaDorrani
10 ай бұрын
Thanks! Calculated columns cannot be used in filter queries. Also, check your statement again :) "This shouldn't be an issue because I am using it as a lookup column, rather than a lookup column, right?"
@user-ts3ns1ce8j
10 ай бұрын
Thank you. @@RezaDorrani Sorry for misspeaking, but I'm looking to see if a calculated column can be used if it is referenced through a lookup.
@RezaDorrani
10 ай бұрын
@@user-ts3ns1ce8j I dont think thats possible
@user-lq7zc7um7e
Жыл бұрын
nice work as always, hoping to get a text copy of the HTML Body for the email
@RezaDorrani
Жыл бұрын
Thanks, Did this video 9 months ago. I do not have the flow anymore nor the html body of email.
@ybunsee
8 ай бұрын
Your videos are so good! I am happy to find the solutions in your videos. I have a question for querying a Look up Column. I did it in my power automate flow but I get this error: One or more field types are not installed properly. Go to the list settings page to delete these fields. clientRequestId: 0b9d2c01-ad3f-4085-b626-3c47b49c6c80 serviceRequestId: 0b9d2c01-ad3f-4085-b626-3c47b49c6c80 What could there be wrong in the list of my Sharepoint? My Sharepoint Lookup works normal in Sharepoint itself.
@RezaDorrani
8 ай бұрын
Thanks! I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@ybunsee
8 ай бұрын
@@RezaDorrani i found the weird problem. The colomn from where the Lookup colom got his values, did have 2 names instead of one in the url. When I sorted the column in url the name was Title but when i went into the settings of that same column the name was TitleLink. That's why my flow was not working. How can something like that happen?
@RezaDorrani
8 ай бұрын
@@ybunsee I have no clue about this
@SharmilShah-kv8hv
9 ай бұрын
Thanks Reza for this detailed video. With Copilot, I can't see filter ODATA basic/advance option. Is there an additional settings to be applied?
@RezaDorrani
9 ай бұрын
Simply swap back to old flow designer by adding &v3=false in url
@wendymackenzie9774
Жыл бұрын
Hi Reza awesome video, why would I get the error message no dynamic content available, or expression when trying to add in a filter for due dates, despite the experimental feature turned on.
@RezaDorrani
Жыл бұрын
Not sure why that would be the case.
@DrewSolomon
Жыл бұрын
Reza, amazing as always!!! any tips on choices columns? I want to grab all sharepoint items that have choice "A" in a choices column (some have A,C; others B,C, etc.). Well, i'll be doing more than that, but that is the part that i don't understand. so "eq" doesn't seem like it'll work, i need a contains.
@RezaDorrani
Жыл бұрын
I think I covered that here kzitem.info/news/bejne/2pt31KmKe2pmmJw
@DrewSolomon
Жыл бұрын
@@RezaDorrani you are the best! thank you for such a quick response!!! (link for anyone with my issue including the time stamp kzitem.info/news/bejne/2pt31KmKe2pmmJw)
@charlesdawnbeltran9603
Жыл бұрын
Excellent video! But will this work if I have a 1 column variable with an array of 5 to 10 line items?
@RezaDorrani
Жыл бұрын
I have not understood your question. It’s probably best to post your query with screenshots on the forums at powerusers.microsoft.com
@pavell5237
4 ай бұрын
HI Raza, i like your videos very much. i have a question. for the example of filtering the user name dynamically. is possible to have an example instead of using direct report to use another SP list. and user that list to dynamically filter the other sp list.
@RezaDorrani
4 ай бұрын
Have not tried that scenario. Would be complicated. I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@Mic4584
Жыл бұрын
What about filter query using a "calculated column" , Reza! Thanks in advance for your response!
@RezaDorrani
Жыл бұрын
Calculated columns are not supported in filter queries as those columns are calculated at run time in SharePoint
@bengzrave
Жыл бұрын
Great as always!
@RezaDorrani
Жыл бұрын
Thank you! Cheers!
@Obiwan-ik2tw
Жыл бұрын
Reza is my salvation!! :)
@RezaDorrani
Жыл бұрын
Wow!
@meshmut
3 ай бұрын
Thank you so much for this, I'm looking at how I can use the output on the get items results down the flow other than just sending an email. My filter will only return one row of item and I want to use a specific column result down the flow. How can that be achieved?
@RezaDorrani
3 ай бұрын
Even though filter will return 1 item it would still be an array. Once you get the values as shown in video then it’s up to you how you would want to use it. I have done many other flow videos where I have saved info in a file or sent email etc.
@kpopante
Жыл бұрын
How do I apply this flow when I want to copy an attachment from a SP list to a specific SP library subfolder based on filter (let's say i wanted to copy all the attachments for the reports of May, and June, July and so on?)
@RezaDorrani
Жыл бұрын
This video is not related to copying attachments. Its simply how to filter data. I do not have a specific video on copying attachments to sub folders. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@varaprasadj
Жыл бұрын
Thank you Reza.. how about if list contain more then 10k items.. is this query will work?
@RezaDorrani
Жыл бұрын
Give it a try
@gitaiganor4100
Жыл бұрын
Thanks!
@RezaDorrani
Жыл бұрын
Welcome
@RezaDorrani
Жыл бұрын
Thank You!
@erickperagallo5537
Жыл бұрын
Great video Reza, as always. I've been struggling with a particular scenario when I am trying to get items from a list containing country names. One of the values is "Cote d'Ivoire (Ivory Coast)" how can you create a FilterQuery for values containing special characters? Thanks!
@RezaDorrani
Жыл бұрын
I 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
@ChristianPecksteiner
Жыл бұрын
Reza that was great!
@RezaDorrani
Жыл бұрын
Thanks
@ricardohernandez1481
Жыл бұрын
Reza thank you for all your excellent videos. I’m struggling with a specific scenario. I have a master report file that is missing data for two columns for a subset of IDs. I have a report that contains that information but it is quite large. I’m not sure how to use the query filter to get files with the file path for this report and also filter it to just the IDs that are empty in the master and update it. If you have any thoughts I’d love to hear it!
@RezaDorrani
Жыл бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking on forums at powerusers.microsoft.com in case someone has done something similar
@ricardohernandez1481
Жыл бұрын
@@RezaDorrani Thank you for your reply! I will say I built the first half of the flow using one of your other videos so thank you so much for the work you do. I will check out the forums.
@notorioussamurai1671
3 ай бұрын
@@ricardohernandez1481 Did you find how to simply filter column for not empty strings? Thanks
@aguilarrob07
Жыл бұрын
Hi Reza, thanks for these videos, so I ve been learning a lot of power automate and Flows with your vids, so now I am working with a sharepoint list which has 2 parties, one entered data and the other enter another data so how can I set the first data no editable for the second party and vice versa.? Thanks for your help.
@RezaDorrani
Жыл бұрын
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
@TatyanaBaytler
2 ай бұрын
Amazing and very helpful, but i could not figure out how you create HTML table?
@RezaDorrani
2 ай бұрын
Thanks! The video is the best reference I have.
@carlw
Жыл бұрын
Very informative thanks Reza. Have you heard of any way to employ 'Does Not Contain' in the filter? Yes you can filter later but why pull back all records then filter. That's the MS Access way. Surprising msft didn't include the 'Does Not Contain' filter (he says tongue in cheek).
@RezaDorrani
Жыл бұрын
I have not explored does not contains. I remember Dataverse odata filter query having the option. Not sure with SharePoint.
@carlw
Жыл бұрын
@@RezaDorrani Ok, tx, I didn't know that. I've not utilized dataverse yet. Strange though, both utilize SQL Server I'm sure.
@RezaDorrani
Жыл бұрын
@@carlw Yes, but SharePoint Architecture is different.
@carlw
Жыл бұрын
@@RezaDorrani 👍🏻 Yes, I imagine that would have a lot more bearing on the issue.
@user-ts3ns1ce8j
6 ай бұрын
Are you able to use a get items filter on a secondary lookup column? i.e. a lookup column from using the ability "Add a column to show each of these additional fields:"? Thank you Reza, truly
@RezaDorrani
6 ай бұрын
I have not tried with secondary lookup so not sure. Might very well be a limitation.
@akankshasharma734
11 ай бұрын
Hi Reza, this video was very helpful. Just wanted to ask if we can filter the modified date(in sharepoint metadata) eq to utcNow. I tried doing it but its giving me error.
@RezaDorrani
11 ай бұрын
Possible! You can point to any date column. I have not come across an issue related to date column and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@josemontes714
Жыл бұрын
Hi Reza, great content. I´m currently trying to make a workflow in power automate that starts from responding a Microsoft forms survey and, depending on the response (multiple choice question), the flow will grab files linked to every response and compile all those files into 1. Do you have a video with an example similar to that? I´m still very new to this. Thanks! Greetings from Mexico!
@RezaDorrani
Жыл бұрын
Check my playlists on Microsoft Forms: kzitem.info/door/PLTyFh-qDKAiGPJ0JZN0i3xlACNyygTjgs Include working with files + handling multi-choice.
@florinivan6072
Жыл бұрын
Hi, Reza! Great tutorial! As always. Is there a way to use ODATA filtering to find out all the entries of people who have more than one entry assigned (all entries with same column x value or all entries without unique values in a specified column)?
@RezaDorrani
Жыл бұрын
You cannot do that with odata as far as I know
@snehanandimandalam6844
4 ай бұрын
@RezaDorrani I'm trying to filter data between two date ranges, that is between 01/01/2022 - 31/12/2023. I've seen the data range calculated time that you've shown in this video, however you're using the current month to calculate that. Can you please help me understand how to work with date ranges that are both in the past?
@RezaDorrani
4 ай бұрын
Check if I covered it here kzitem.info/news/bejne/2pt31KmKe2pmmJwsi=ulMgjD9i2d3LOgqI
@sankhlayashraj
7 ай бұрын
Another fantastic video Reza. I had one question - I have bee trying to filter my get items with following criteria: I have a column which gives me Month # of date. I would like to filter the column based on the month # and also modified date. I have used the following in PA OData query, but the records come out as 0, though I have items that have been modified on said date. What could I be doing wrong. Any help on this front is much appreciated. (Month_x0023_ eq '12') and (Modified eq '02/05/2024') This is the expression I am using for formatting the date to get the modfied date format: "formatDateTime(addDays(utcNow(), -2), 'MM/dd/yyyy')
@RezaDorrani
7 ай бұрын
I have not come across this issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@charleschadwell5261
7 ай бұрын
Great video ! Unfortunately I am a little behind the time stamp and this experimental step does not work for me . Is this no longer available?
@RezaDorrani
7 ай бұрын
Should be in classic editor. Modern editor already has it. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@NelsonONadal
Жыл бұрын
Many thanks Sir Reza, I just wondering if the MODIFIED column is allowed in using on FILTER. I tried filtering MODIFIED equals to formatDateTime(utcNow(), 'yyyy-MM-dd') it's not working, but in other created date column it is working, many thanks again.
@RezaDorrani
Жыл бұрын
Check internal name of modified column
@mohammadmohammadi2681
Жыл бұрын
Hi Reza, Thank you so much for this lovely video, it helped a lot, meanwhile I have a question can we make odata filter query based on the drop-down values if it's blank then do not add this in the query else drop-down.selected value,query depends on 7 drop-down if I pass values in any 2 columns then it should filter the datasource based on only those two fields in power Automate get items if all blank then get me complete data as we generally do in powerapps gallery for dealing if drop-down is blank the same way in power Automate get items. Please suggest Thank you
@RezaDorrani
Жыл бұрын
Flow does not have dropdowns :) Im assuming you mean calling this flow from power app. It is possible but the formula would be complex in power apps since you would have to check empty for each dropdown and accordingly formulate the query.
@mohammadmohammadi2681
Жыл бұрын
@@RezaDorrani yes exactly calling from powerapps and passing the filter query from power apps to power Automate get items odata filter query but how would I develop if powerapps drop-down is blank then it shouldn't through error in Automate that didn't get filter query data. Please suggest in this scenario
@RezaDorrani
Жыл бұрын
@@mohammadmohammadi2681 You will need to do null checks and do it. I cannot give you formula without trying it out. It would be best to post your issue with screenshots on the forums at powerusers.microsoft.com
@mohammadmohammadi2681
Жыл бұрын
Thank you
@user-md7rz7hk8l
4 ай бұрын
Hello Reza, I want to filter on a lookup column, but in the same list, not to the source list. Is it possible? I tried many different things to get the value inside the lookup field but to no avail (Examples: FIeldName, FieldName/Value, FieldName.Value, etc...). Thank you!
@RezaDorrani
4 ай бұрын
same list and source list has me confused. Lookup columns lookup to a different list. The additional columns cannot be used to filter on as far as I know
@imannayak5839
2 ай бұрын
Hi @Reza....i wanted to create a flow where only one specific user will send attachment through email.and that attachment should create or update on SharePoint folder ..can you help with the full flows??
@RezaDorrani
2 ай бұрын
I do not have a video reference on this and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@bhavyapatnam7586
9 ай бұрын
Hi Reza, I have a question. How many items do getitems or getitem action search in SharePoint? I know that these actions can return 5000 to 1lakh items when a Search is performed..but due to my restriction to use only one column search in 25k items list, the output of a same search performed multiple times does not bring the right result. Given that I am searching for the exact match that there will be only 1 result item of my search.
@RezaDorrani
9 ай бұрын
I am not aware of the exact limit. If pagination is on then it will return all items in batches of the max limit.
@mohit.kothiyal
Жыл бұрын
hi reza, i have some doubt that i am unable to figure it out. Whenever a csv is created in sharepoint library my flow instance is triggered and it parses my CSV file which is failing because my Name column has quotes in the CSV records. my filter query is like Name eq 'Name' i.e. 'Name' is the field coming from parse CSV action from the body of the CSV. eg: Mohit's so Please help me how can i write my filter query. Flow is like: file is created in a folder> Get file content> Initialize Variable> Parse CSV > Apply to each - Body Value - Get Items (where my flow is failing)> Move File
@RezaDorrani
Жыл бұрын
I will have to look at your App in action to know the cause of your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@kaviyarasivijayakumar6291
4 ай бұрын
Hi, In my flow i am using filter query for title (text) column but i am getting the body value as null Same is working when i execute separately with help of array .May i know why this glitch and your suggestions if any to be corrected in the flow.
@RezaDorrani
4 ай бұрын
I have not come experienced this and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@Deadpool12353
Жыл бұрын
Reza I think you need a new fresh look profile photo, just to refresh marketing front. It looks ok but I find it dated.
@RezaDorrani
Жыл бұрын
Thanks for the feedback. Il plan to take a few headshots during my upcoming vacations :)
@vinceee345
9 ай бұрын
Hello Sir Reza please make a video on how to make a filter query code to filter the table inside the filtering table in PowerApps. I'm stuck in my project please help.
@RezaDorrani
9 ай бұрын
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@natcongreso2763
8 ай бұрын
Hi Reza, do you have tutorial like this but passing the table to PowerApps?
@RezaDorrani
8 ай бұрын
Don’t have one for passing table.
@dannybaquer
Жыл бұрын
Hey Reza, How are you doing? I am just wondering is possible to create an PowerApp about Qatar 2022 Sweepstakes Spreadsheet? Just asking
@RezaDorrani
Жыл бұрын
I believe it is possible but not something I am planning on doing :)
@kevinbriz17
8 ай бұрын
Hi Reza, Do you have any plans to update this with the new Power automate interface?
@RezaDorrani
8 ай бұрын
New interface does not have the same functionality yet but it will come soon. The same queries shown here apply for new interface as well.
@cambly2701
10 ай бұрын
Dear Raza Can we directly use array variable in odata filter?
@RezaDorrani
10 ай бұрын
I dont think so
@brandonguerrero4395
3 ай бұрын
Have a question because I don't have the experimental query Filter, and I already enable the button but continues hide, could yo helpme to know if I need to enable or configurate something else?
@RezaDorrani
3 ай бұрын
I did not understand the question.
@glaubercarvalho5242
Жыл бұрын
Could you make a video, auto scroll with a gallery of images?
@RezaDorrani
Жыл бұрын
I only make videos when I get multiple requests on a topic. I have ideas in my backlog with over 30+ requests. This is the first request on the topic you mentioned.
Пікірлер: 316