Another great video Reza, will be directing all the folks who want to start using Power Automate here! I watched another video recently talking about trigger conditions and they had a great tip of using the filter array option to build your trigger condition expression, really simple and switching from basic to advanced view gives you the trigger condition expression you need (including the @)
And his mic quality is actually good! Unfortunately so many of these talented developers making content have thick Indian accents, although they can’t help it - this makes it hard to understand coupled with bad microphones its doubly difficult to comprehend the great info they teach: shout-out Reza! 💪🏼
Hi Reza. I just had to share this with you. I used your video named "Power Apps Save Pictures to SharePoint - Camera Control Tutorial" . The comments were turned off, so I am using this video's comments section. Whenever I wanted to submit the attachments I kept on getting a warning that the "Id" was needed for the form submit. It took me nearly 5 hours of swearing and crying to realize, after watching your video over and over again, that I had used "ID", instead of "Id" in the JSON schema. The warning message was telling me the fault all along. Now I am laughing at myself. Thanks for all your help, I and I sure many others, really appreciate it.
Thanks for sharing the details Ashley. Glad to know it worked :) The comments are turned on for that video. I have a lot of recent comments on that video.
Honestly - Whenever I face any challenge anywhere in Power Platform, Preferably I always look for your videos because of you pick complex tasks in your videos which covers other multiple scenarios....You helped me a lot. Thank you Reza...Cheers!
Thank you sooo much!!! I'm not even sure you realize how helpful your videos are. You have a multitude of tips and helps in this video alone. I've been struggling with 1 thing... I was not able to see the add dynamic content/expression editor button. After trying several things and numerous searches, I was feeling defeated. But you casually mentioned it in this video. I am grateful! That's only 1 example. There are many more!!! Thank you!
Thank you for FINALLY explaining the use of the ? in traversing json! I've seen/read dozens of blog posts or videos where they just give the notation without explaining it.
Amazing video! Thank you so much!!! I was searching for a good content that explains how to build expressions for months and finally found answers to most of my questions in your single video :)
Hi Reza, thank you for all your efforts in creating videos. You're the best in terms of the content and making each steps understandable, dare I say better than Jon Levesque and Jon is great!
Massive thanks Reza! - I always found myself going back to the 101,201.... series you had done w/ Jon L.... but I now have new supercharged, super-concise reference for PA expressions!.. With a vast array:) of excellent use cases - Well and truly bookmarked! 🔖
Thanks Reza, a gold mine of information there as usual. I struggle with the new editor, I probably just need to get used to it and practice more. Always find myself going back to the classic one. Sure the expressions are harder to edit, but I drop them out to an editor first then copy paste them back in. Something about that makes it easier to compare expressions and see those silly errors. Quotes, comma, brackets missing etc. One of the things I have started to do with expressions is when I have collected data is to create an array of items I need and use on the flow. Then inside that array use expressions to do any conversions or processing I can do against them to save on compose and variable steps. e.g. from SharePoint get item, take any date / time fields and convert into various formats and have them as their own items directly further down the flow. With those items I also add expressions inside If(Empty(Item), 'no value', converttimezone) etc In cases where fields are not required fields to avoid some failures. Looking forward to the next one. This video will be in my video reference library. ;)
Great video, Amazing Power Automate content in a single 35 min video. Request you to make something for Batch add/delete or some other batch process using power automate.
Thank you Reza, I had lost my expression builder and could not understand why. You showed me that my browser resolution was too high, it was driving me nuts.
Thanks for another great video. Have a question: We are checking if we could store some business rules as expressions in dataverse tables and then invoke them in Power Automate based on needs.
Thank you Reza for another great video. I really thankful for the guidance on avoiding loop. Regarding parsing Json can you please guide how we can apply query or filter on the parsed json to get only specific data by matching some string?
Hi Reza!!! Commendable Videos. Kindly suggest for below mentioned issue I have a table with multiple mail IDs. Flow generated same number of mails as per IDs. (If mail id is 4 times, it will send 4 mails with HTML table) Rgds
Hi Reza, Your posts and videos are awesome and very helpful. I posted questions on the comments today and last week. For some reason I do not receive comments and my questions ate missed from the posts. Did anyone have idea on those? Thanks!
@@RezaDorrani I posted a question how to get/retrieve user groups (group names) and Permission level of each group in a site using power automate. I am able get each separately, but unable to map them, that is a user group to it's permission level. Your clues and idea are so helpful. Thanks for reaching out!
Thank you Reza. That was a real dive in. Would you think of an equivalent GetItems action but against Dataverse table? So with one action, we could filter a table on multiple columns. List Rows( filter rows) seems to accept only one column at a time.
It does support multiple filters. I will have to look at your flow in action to know more about your issue. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
14:13 Would it be possible to convert the date/time to the user's local time zone, meaning the result shows differently based on the user's location? Thanks for sharing.
aWESOME. i wanted to change date/time receive from a SP list and extract the date part only and send it in an email. which expression builder will work the best.
I would have to try that scenario to know the expression. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Rezza, Appreciate to this truly awesome content. I was having a question, does power automate expression have left, right, mid etc. string functions. ?
Hello Reza, is there any way to send an image to a group channel on team using power automate? I have tried but with thumbnail, however the resolution is very bad even though that i use size = large. you are doing an excellent job, i love your videos
Thanks so much for watching and loving the videos. I have not done much work with flow and group channels. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com/
Hello Reza, I have a question, why in 13:18 your expression "and" that has "startsWith" and "endsWith" expressions inside gave you true? Especially "endsWith" expression with second parameter as 'd'? It should have returned the false as your string 'Reza Doranni' doesn't end with letter 'd'.
Hey Reza thank you for sharing this amazing knowledge I do question please try reply it How can I shows custom fields value which are in dataverse. Basically I am creating custom update from and I need to show user there fields value which they have created while submitting from Canvas How can I achieve this Database : dataverse
I do not have a video on this use case. I would have to try it out to provide the steps. I will recommend you check on the forums at powerusers.microsoft.com/
Hi Reza, thanks for the video. I have a question. So, I am trying to automate feedback forms where there's a column named 'Additional Comments' and users enter comments with a newline. As soon as a new line is encountered in SQL, it goes to next column and hence not taking the data properly. I was thinking if I could replace the newline character in the flow with a space character. Please let me know how to proceed with this problem. Thanks :)
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, as per your advice I posted the issue on the Power Automate Community site. Site groups generated using (_api/Web/SiteGroups) in http request, and Roledefintions generated using (_api/Web/RoleAssignments?$expand=Member,RoleDefinitionBindings) in different http request. Both are within the same flow. I am trying to map Group Name (from _api/Web/SiteGroups) output to Permission Level (in _api/Web/RoleAssignments?$expand=Member,RoleDefinitionBindings) output. Tried Compose, Select, ... in Data Operation including loop, but unable to achieve. Thanks!
I will have to look at your flow in action to provide guidance. Forums would be your best bet. I myself go to assist in the forums but only in my free time.
Hey reza this is great. however Im not able to edit the expressions in the dialog box. are u aware of this bug? not sure who can i raise this to. possible to advice? also, isit possible to trigger an approval based on a particular input of a form using an expression? for eg. If form contains a particular response, send approval to A. If form contains a different response, send approval to B.
Question regarding Flow run links being sent out. If I receive an email with a flow run link to the exact flow that failed and it is day 29. Will I still be able to access it ?
You can now increase duration of flow run history as it can be stored in Dataverse. Check learn.microsoft.com/en-us/power-automate/dataverse/cloud-flow-run-metadata
Tried to put an expression in when a document is checked out @equals(triggerBody()?['IsCheckedOut'],true) and it doesn't launch my flow. If I check within the flow the it launches and I can control it, but not when the trigger condition is added.
Hi riza sir, I am using sharepoint list as a data source and I am extracting data with "get items" then next step I used "select data operation" option when I am going to to "crate a html table" with output of "select data operation option" . In html table all column are fine expect multi choice column in that column I am getting a Array data instead of sting. Please help me out this
@@RezaDorrani in power apps we can use concat formula which we can choose the column data in this case value column. How can i get like that expression in power automate
@@premkumarreyya9691 There is a select function. It is difficult to provide guidance without looking at your flow. I would recommend to post your query on the forums at powerusers.microsoft.com/
Hi sir hope you are doing good. Can you please give me a way how I can read the CSV format attachment from mail and that attachment data needs to be written into some SP list. Need your guidance can you please help me with this.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you for the video !! Could you please help to write an expression in power automate. If Column A is less than or equal to Column B then output should be column C else output should be column D. I have developed a workflow and trying to write the expression in "SELECT" tool where the output from If condition should be captured. Please help. Thank you
If(lessOrEquals(a,b),c,d) It would be ideal to look at screenshots of your flow in action. I would recommend to post your query with screenshots on the forums at powerusers.microsoft.com
Hi Reza ..I have requirement that I need create folder in SharePoint library with name that comes from Excel name column and after that need to update other values of columns also like status ,start date... from Excel only can you please tell me how I can update(which action i can use to update folder columns ) other columns after creating a folder in power automate flow
I do not have any video on this scenario. To provide guidance, I would have to try out this scenario. I will recommend you check on the forums at powerusers.microsoft.com/
It depends on the data structure. If I have a string a,b,c,d and using split it will create an array. There are options and it differs based upon the use case.
I do not have a video on this scenario & would have to try it out to provide guidance. I would recommend checking on the forums at powerusers.microsoft.com in case someone has done something similar.
Hello Reza, Please let me know how we can close an opportunity as Won/Lost. I tried update a row action in MS dataverse but it is not working. Getting incorect code for status error. Looking forward to your reply. Thanks in advance
How can I know without knowing the table structure, column types etc. etc. + I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
How to extract the data from Dataverse into xml file.. I have two dataverse tables related and I need to extract the data from both of them into xml.. is that possible?
Hi Reza, I have a power Automate where I am pinging multiple person in teams one by one using apply to each from my power BI data. Problem is as it is teams i dont know weather it worked or not so I call result('MY_PARENT_ACTION').It give me all the details however It is giving me Result Set: [{"name":"Apply_to_each","inputs":{"foreachItems":[ Which I dont want I want only one value from that result say the person how is clicked. I am not able to figure out kindly help
I will have to look at your flow in action to provide guidance. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Another great video Reza, will be directing all the folks who want to start using Power Automate here! I watched another video recently talking about trigger conditions and they had a great tip of using the filter array option to build your trigger condition expression, really simple and switching from basic to advanced view gives you the trigger condition expression you need (including the @)
Awesome, thank you!
Your 💡 is awesome as well.
That Video was by Damian Bird. Really useful trick to get those trigger conditions worked out.
@@Worrelpa yes it was, I like a lot of his stuff!
Cheers guys - appreciated 👍
He does a great job - gets right to the point - doesn't waste any time - very concise - very knowledgeable.
He says Thank You :)
And his mic quality is actually good! Unfortunately so many of these talented developers making content have thick Indian accents, although they can’t help it - this makes it hard to understand coupled with bad microphones its doubly difficult to comprehend the great info they teach: shout-out Reza! 💪🏼
Almost a year later after this video and you're still helping out beginners like me. Thank you, Reza!
So happy to hear that
Hi Reza. I just had to share this with you. I used your video named "Power Apps Save Pictures to SharePoint - Camera Control Tutorial" . The comments were turned off, so I am using this video's comments section. Whenever I wanted to submit the attachments I kept on getting a warning that the "Id" was needed for the form submit. It took me nearly 5 hours of swearing and crying to realize, after watching your video over and over again, that I had used "ID", instead of "Id" in the JSON schema. The warning message was telling me the fault all along. Now I am laughing at myself. Thanks for all your help, I and I sure many others, really appreciate it.
Thanks for sharing the details Ashley. Glad to know it worked :)
The comments are turned on for that video. I have a lot of recent comments on that video.
Honestly - Whenever I face any challenge anywhere in Power Platform, Preferably I always look for your videos because of you pick complex tasks in your videos which covers other multiple scenarios....You helped me a lot. Thank you Reza...Cheers!
Wow! Thank You so much for watching and learning from the videos. Much appreciated.
Thank you sooo much!!! I'm not even sure you realize how helpful your videos are. You have a multitude of tips and helps in this video alone. I've been struggling with 1 thing... I was not able to see the add dynamic content/expression editor button. After trying several things and numerous searches, I was feeling defeated. But you casually mentioned it in this video. I am grateful! That's only 1 example. There are many more!!! Thank you!
Wow! You are most welcome! So glad to hear the video is useful and packed with content.
Thank you for FINALLY explaining the use of the ? in traversing json! I've seen/read dozens of blog posts or videos where they just give the notation without explaining it.
Glad it was helpful!
Amazing video! Thank you so much!!!
I was searching for a good content that explains how to build expressions for months and finally found answers to most of my questions in your single video :)
Great to hear! Thank You so much for watching.
Best Power Platform Developer ever, thank you for your amazing videos ❤️
Wow, thank you!
Reza, you have shown me so much and answered many questions - thank-you!
Most welcome
Excellent tutorial. Very timely as I'm currently working on flows where I'm having to use a lot of expression. Thanks for sharing.
Glad it was helpful!
Excellent! Exactly what I was looking for. Thank you!
Great to hear!
Hi Reza, thank you for all your efforts in creating videos. You're the best in terms of the content and making each steps understandable, dare I say better than Jon Levesque and Jon is great!
Thanks Alex.
Massive thanks Reza! - I always found myself going back to the 101,201.... series you had done w/ Jon L.... but I now have new supercharged, super-concise reference for PA expressions!..
With a vast array:) of excellent use cases - Well and truly bookmarked! 🔖
Thanks Gerard.
Goal was to make a one stop shop video and cover all aspects of expressions with real world use cases.
Thanks Reza, a gold mine of information there as usual.
I struggle with the new editor, I probably just need to get used to it and practice more.
Always find myself going back to the classic one. Sure the expressions are harder to edit, but I drop them out to an editor first then copy paste them back in. Something about that makes it easier to compare expressions and see those silly errors. Quotes, comma, brackets missing etc.
One of the things I have started to do with expressions is when I have collected data is to create an array of items I need and use on the flow. Then inside that array use expressions to do any conversions or processing I can do against them to save on compose and variable steps. e.g. from SharePoint get item, take any date / time fields and convert into various formats and have them as their own items directly further down the flow. With those items I also add expressions inside If(Empty(Item), 'no value', converttimezone) etc In cases where fields are not required fields to avoid some failures.
Looking forward to the next one. This video will be in my video reference library. ;)
Thanks Phil.
Your tips are awesome!
This was most awaited video! Thanks Reza!
Hope you enjoyed it!
@@RezaDorrani Yes!
Absolutely awesome, no one can explain that better than you.
Thank You 😊
It is a very useful video for me. Great job. Thank you.
Glad to hear that. Thanks for watching
Thanks Reza for sharing your knowledge..please keep up the good work you are doing for the community.
My pleasure
Thanks!
Thank You!
Like always BRILLANT!!
Thanks, Reza
Thanks Gourav
Thank you very much for such detailed explanation step by step! 👍
You are most welcome!
Thank you Reza 💙 Reza is the best!!!!! 💙This one is amazing. I am not sure if I can understand fully, but I will do my best. This is amazing.!
You can do it!
@@RezaDorrani Thank you👍😁
Qualitative sharing… 🙏👍
Thank you! I love the word "Qualitative".
Wow. so much to learn with Reza. Keep it up.
Thank You
Nice walkthrough!
Thank you 👍
Excellent examples and explanations. I'm an intermediate looking for better ways to do things..... Thank you!
You're very welcome!
Perfect as usual, I hope there will be more videos about Expressions
Thank You.
Every flow video of mine has a heavy usage of expressions.
This is 30 minutes of gold
Thank You
Thank you so much for sharing your refined insight is been a lot of help for a beginner like me.
You are so welcome!
Thank you Reza for this wonderful video.
You are very welcome
Reza your videos are Awesome! All facts! Thank you
brilliant clear teaching thankyou
Thanks Mike
Great video, Amazing Power Automate content in a single 35 min video. Request you to make something for Batch add/delete or some other batch process using power automate.
Thank You.
I will add the batch process request to my backlog.
Thanks for another great video and knowledge shared
My pleasure.
Reza as always excelente video. Lots good examples, wish you the best.
Thanks Marcelo
great video Reza!!
Thanks Chad
You're the best, Thx!!
Thank You for your kind words
Priceless Reza thanks for this.
You are most welcome
Thank you for the video Reza :)
Most welcome
Simply amazing!
Thank You!
Very good. Thank you
Your most welcome!
Thank you Reza, I had lost my expression builder and could not understand why. You showed me that my browser resolution was too high, it was driving me nuts.
👍
Muchas gracias por compartir tu conocimiento con todos nosotros 👍👍👍
Gracias
Great video thanks Reza for effort and support
Glad you enjoyed it
Very very nice video Reza 👌👌👌👏👏👏
Most most most welcome
Really nice video!!
Thank you very much!
Thanks Reza. Mind 💥 again...
Thank You so much.
magical video
Thank You
Awesome Reza 👍👍👍
Thank you! Cheers!
Thanks for another great video. Have a question: We are checking if we could store some business rules as expressions in dataverse tables and then invoke them in Power Automate based on needs.
Never tried that scenario. Probably would be possible.
Thank you Reza for another great video. I really thankful for the guidance on avoiding loop. Regarding parsing Json can you please guide how we can apply query or filter on the parsed json to get only specific data by matching some string?
I have done several flow videos where I have used the Data Operation action "Filter" .
big thank from VietNam
Most welcome
Great as always. Can you make a video on your vidéo recording and editing process :D ? Maybe you use power platform in the process :)?
Thanks Jeff.
I use Camtasia to record and edit my videos.
I take on average 4-6 hours per video for recording and editing.
Hi Reza!!! Commendable Videos.
Kindly suggest for below mentioned issue
I have a table with multiple mail IDs. Flow generated same number of mails as per IDs. (If mail id is 4 times, it will send 4 mails with HTML table)
Rgds
I do not have a specific video on that use case.
May be this video helps ruclips.net/video/tp0jLnmKcEs/видео.html
Hi Reza,
Your posts and videos are awesome and very helpful. I posted questions on the comments today and last week. For some reason I do not receive comments and my questions ate missed from the posts. Did anyone have idea on those?
Thanks!
Thanks for liking my videos.
Which platform are you unable to post comments on? RUclips or the community forums?
@@RezaDorrani I posted a question how to get/retrieve user groups (group names) and Permission level of each group in a site using power automate. I am able get each separately, but unable to map them, that is a user group to it's permission level. Your clues and idea are so helpful.
Thanks for reaching out!
@@gayirga3825 I would recommend to post your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Sure will do that.
@@RezaDorrani Thanks!
Thanks Reza 👌
You are most welcome
Amazing Video.. Please see if you could slightly reduce the pace in the upcoming videos
I have got my pace down from about 2 years ago :)
I will work on going one level slower. Thank You for the feedback.
Thanks sir
Most welcome
Thank you Reza. That was a real dive in. Would you think of an equivalent GetItems action but against Dataverse table? So with one action, we could filter a table on multiple columns. List Rows( filter rows) seems to accept only one column at a time.
It does support multiple filters.
I will have to look at your flow in action to know more about your issue. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
14:13 Would it be possible to convert the date/time to the user's local time zone, meaning the result shows differently based on the user's location? Thanks for sharing.
As long as you have info of users local time zone while running the flow, you can do that.
Thank.
aWESOME. i wanted to change date/time receive from a SP list and extract the date part only and send it in an email. which expression builder will work the best.
I would have to try that scenario to know the expression. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Rezza, Appreciate to this truly awesome content. I was having a question, does power automate expression have left, right, mid etc. string functions. ?
It does not. You would need to use substring function.
Hello Reza, is there any way to send an image to a group channel on team using power automate? I have tried but with thumbnail, however the resolution is very bad even though that i use size = large.
you are doing an excellent job, i love your videos
Thanks so much for watching and loving the videos.
I have not done much work with flow and group channels. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com/
Hello Reza, I have a question, why in 13:18 your expression "and" that has "startsWith" and "endsWith" expressions inside gave you true? Especially "endsWith" expression with second parameter as 'd'? It should have returned the false as your string 'Reza Doranni' doesn't end with letter 'd'.
the actual expression was showcased at 12:34
13:18 - shows the static expression text that I mistyped.
@@RezaDorrani Thanks for your clarification and for your great content👍
Hey Reza thank you for sharing this amazing knowledge I do question please try reply it
How can I shows custom fields value which are in dataverse.
Basically I am creating custom update from and I need to show user there fields value which they have created while submitting from Canvas
How can I achieve this
Database : dataverse
I do not have a video on this use case. I would have to try it out to provide the steps.
I will recommend you check on the forums at powerusers.microsoft.com/
Hi Reza, thanks for the video. I have a question. So, I am trying to automate feedback forms where there's a column named 'Additional Comments' and users enter comments with a newline. As soon as a new line is encountered in SQL, it goes to next column and hence not taking the data properly. I was thinking if I could replace the newline character in the flow with a space character. Please let me know how to proceed with this problem. Thanks :)
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, as per your advice I posted the issue on the Power Automate Community site.
Site groups generated using (_api/Web/SiteGroups) in http request, and Roledefintions generated using (_api/Web/RoleAssignments?$expand=Member,RoleDefinitionBindings) in different http request. Both are within the same flow. I am trying to map Group Name (from _api/Web/SiteGroups) output to Permission Level (in _api/Web/RoleAssignments?$expand=Member,RoleDefinitionBindings) output.
Tried Compose, Select, ... in Data Operation including loop, but unable to achieve.
Thanks!
I will have to look at your flow in action to provide guidance. Forums would be your best bet.
I myself go to assist in the forums but only in my free time.
@@RezaDorrani That is great! Thanks Reza as always!
Hey reza this is great. however Im not able to edit the expressions in the dialog box. are u aware of this bug? not sure who can i raise this to. possible to advice?
also, isit possible to trigger an approval based on a particular input of a form using an expression?
for eg.
If form contains a particular response, send approval to A. If form contains a different response, send approval to B.
Not aware of any such bug. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Question regarding Flow run links being sent out. If I receive an email with a flow run link to the exact flow that failed and it is day 29. Will I still be able to access it ?
You can now increase duration of flow run history as it can be stored in Dataverse.
Check learn.microsoft.com/en-us/power-automate/dataverse/cloud-flow-run-metadata
Tried to put an expression in when a document is checked out @equals(triggerBody()?['IsCheckedOut'],true) and it doesn't launch my flow. If I check within the flow the it launches and I can control it, but not when the trigger condition is added.
I will recommend checking or posting your issue on forums in case someone has experienced something similar
community.powerplatform.com/
@@RezaDorrani thank you, I will
Is there any simulator tool where we can test out functions?
I’m not aware of any simulator tool
Hi riza sir,
I am using sharepoint list as a data source and I am extracting data with "get items" then next step I used "select data operation" option when I am going to to "crate a html table" with output of "select data operation option" . In html table all column are fine expect multi choice column in that column I am getting a Array data instead of sting.
Please help me out this
You would need to use expressions to convert array of choices to string.
join is the name of the function.
@@RezaDorrani in power apps we can use concat formula which we can choose the column data in this case value column.
How can i get like that expression in power automate
@@premkumarreyya9691 There is a select function.
It is difficult to provide guidance without looking at your flow. I would recommend to post your query on the forums at powerusers.microsoft.com/
@@RezaDorrani ok sir i will send messages you there thank you
@@premkumarreyya9691 Don’t send to me. Post it on the forums. Allow everyone to answer. I go to forums only in my free time.
Hi sir hope you are doing good. Can you please give me a way how I can read the CSV format attachment from mail and that attachment data needs to be written into some SP list. Need your guidance can you please help me with this.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you for the video !! Could you please help to write an expression in power automate. If Column A is less than or equal to Column B then output should be column C else output should be column D. I have developed a workflow and trying to write the expression in "SELECT" tool where the output from If condition should be captured. Please help. Thank you
If(lessOrEquals(a,b),c,d)
It would be ideal to look at screenshots of your flow in action. I would recommend to post your query with screenshots on the forums at powerusers.microsoft.com
Hi Reza ..I have requirement that I need create folder in SharePoint library with name that comes from Excel name column and after that need to update other values of columns also like status ,start date... from Excel only can you please tell me how I can update(which action i can use to update folder columns ) other columns after creating a folder in power automate flow
I do not have any video on this scenario. To provide guidance, I would have to try out this scenario. I will recommend you check on the forums at powerusers.microsoft.com/
Do you know maybe how to replace a select action with an expression (to create array from one JSON property)?
It depends on the data structure.
If I have a string a,b,c,d and using split it will create an array.
There are options and it differs based upon the use case.
Hello Reza! Can you help me? I need to do automatic delete from SharePoin list the rows of records older 1 year. How can i do this? Thank You
I do not have a video on this scenario & would have to try it out to provide guidance. I would recommend checking on the forums at powerusers.microsoft.com in case someone has done something similar.
hi reza, this is a great video for beginners like me. I needed help sorting an array of integers. Can you please help.
Check github.com/rdorrani/Microsoft-Flow/blob/master/SortingArrayswithFlow_20190919223830.zip
Hello Sir!
Can we able include the google maps in the powerapp.
Not sure about google maps.
Check ruclips.net/video/bUO9QxKhe6U/видео.html & ruclips.net/video/cj2cC8EBj-I/видео.html
Hello Reza, Please let me know how we can close an opportunity as Won/Lost. I tried update a row action in MS dataverse but it is not working. Getting incorect code for status error. Looking forward to your reply.
Thanks in advance
How can I know without knowing the table structure, column types etc. etc. + I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
How to extract the data from Dataverse into xml file.. I have two dataverse tables related and I need to extract the data from both of them into xml.. is that possible?
Never tried this, hence do not know if it’s possible. I will recommend posting your query on forums at powerusers.microsoft.com
@@RezaDorrani thanks
Hi Reza, I have a power Automate where I am pinging multiple person in teams one by one using apply to each from my power BI data. Problem is as it is teams i dont know weather it worked or not so I call result('MY_PARENT_ACTION').It give me all the details however It is giving me Result Set: [{"name":"Apply_to_each","inputs":{"foreachItems":[ Which I dont want I want only one value from that result say the person how is clicked. I am not able to figure out kindly help
I will have to look at your flow in action to provide guidance. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza Can you help me get ISOWeekNum in MS flows
I have not tried an expression for this one.
I will recommend posting your query on the forums at powerusers.microsoft.com
This link contains the Reza playlist to power automate expressions. ruclips.net/p/PLN-cZRQeAiDVQ-6ZWGr43yyTcpu6mUgrR
Thanks for sharing
Wtf🤯
I hope in a good way :)