This is a godsend... Thanks a LOT for this. It's a brilliant approach to simplify so many big and complex existing flows we've at work. Thank you for sharing.
i guess Im asking the wrong place but does someone know of a way to get back into an Instagram account..? I was stupid lost the password. I love any tricks you can offer me
I’m not sure how often folks leave comments on videos that they’ve seen once and then gone back the video much later. This is one of those comments. I came across this when I first came across the power platform. I’ve never been a programmer or anything like that, and this particular video was way above my ability to comprehend at that time. Today, about two years later, I will use this as a best practice. I’m guessing when it comes to leveraging values using loops, I have some experimenting to do. But I should be able to leverage the item property to get this done. Although at this time, I cannot afford to become a member of your channel, I know what I know today because of you… Thanks mate!
Reza, I love your channel man. Thank you for helping out the IT community. This would be very hard for me to pick up without your videos and initiative. Much respect.
You have inspired me to reshape my business by adding these technologies. Your lessons are very helpful. I’ve gotten myself in a bit too deep with a project for my number 1 client. I continue to search videos for answers to some of my new challenges. Nonetheless I always learn things from you. Thank You Reza
Thanks a lot Reza, it is also a useful tutorial on how to update object properties and arrays elements in general. Thank you again for putting this together.
Hi @Reza... thanks for your videos... well I was curious if there are many variables in a flow can we store all of them in a single place(as we do to add all the related steps in scope), variables can not be added to scope.. so is there any why to place all in a single block.
Thanks so much for this, Reza! Running into a issue and hoping you can help. I have a variable called varProfile mimicking yours. I would like to use the compose function with the 'setProperty' expression. However, I would like it to compose two var's within the json of the variable, varProfile. For example, I would like it to set the "varApproverName" and "varApproverComments" within the variable varProfile. I am able to have it compose both of those but I can't get it to set both as it runs into an error of "The variable 'varProfile' of type 'Object' cannot be initialized or updated with value of type 'String'. The variable 'varProfile' only supports values of types 'Object'." Would I need to run the compose and set variable with the output twice for each value? Is it possible to do it in just one of each?
I have not come across this issue & hence not sure what the resolution is. Debugging issues here on chat is not a good option. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you for theis great video! What about the Date/Time variables. I see them in the documentation for the desktop flow but not the cloud flows. I wanted to get the max and min of two dates but there is no straightforward way of doing it.
I have not tried max and min for dates. Im sure there are expressions that can be framed for it. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Excellent, easy-to-follow instructions for someone that has been desperately trying to understand what variables are and what role they play in flows. Question - is there any way to hide the initial variables that you initialize so you just see the Compose? That would make it super clean! Regardless, I really appreciate your training style and info. On to your next tutorial. Cheers!
Possible. I believe I have a sample flow on my GitHub repo that shows that. Check github.com/rdorrani/Microsoft-Flow/blob/master/Expressions401-ReducenumberofVariables-SaveAPICalls_20210211210303.zip
Hi Reza! Do you have any video that instead of using hard coded schema receives variables informations like a json ou collection coming from powerapps? tks!
Hi Raza! I am new to Power Automate and have been learning from your videos. I am trying to send MS forms response to Sharepoint List. Some response questions have multiple choice, so I followed the popular method of initialize an array variable, remove extra symbols from Microsoft Forms string output, split the previous line into an array, append to array variable using a formula. It works perfectly, but now I have created multiple array variables for each multiple question in a single initiate variable action as you have described. How can I get the multiple choice response for each question from MS forms into its corresponding variable?
I do not have a video reference on this specific 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 very much, thanks to your videos I have managed to set up a workflow that works correctly from a form to the sending of a summary email. But I still have an minor issue. I constructed a Likert-type form. And I would like to get in a variable only a certain type of value. For example. Question 1 Answer 1 Answer 2 Answer 3 My idea would be to have a variable that would store only the A3's to display in an email, but I'm interested in another idea. The long way would be to do it with conditions, but that's not very elegant when you have a lot of possibilities.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I did videos with forms (might have included likert type). Check th-cam.com/video/kbqXsKPTmZk/w-d-xo.html & th-cam.com/video/4eWGdi_C2hQ/w-d-xo.html I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
4:33- is this what I need to do to take the objects out of my arrays in Power BI? Power BI dynamic content is arrays, not objects, so every time I try and do something, it puts it in an Apply to Each, and there are just WAAAY too many loops going on in my flow, it's insane. Do I have to do this Expression thing to all my dynamic content so I can have a normal clean flow?
Hi Reza, thank you for all your videos, they are really helpful and I have created many flows using your videos. Would you be able to do a demo of how I could create a Power Automate Flow to calculate the number of characters in a specific question response whenever a MS Form is submitted. Currently my flow takes the Form into a List and I would like a field in this list to detail that character count (which includes all words, spaces, puntuation etc in the count). Hope you can help. Many tahnks
I make videos when I get multiple requests on a topic. Each quarter, I ask for topic suggestions on "Community Tab" of my channel. Most voted ideas get added to backlog. The topic suggestion post is currently active.
Hi Reza: Thank you for this very useful video. Also, do you have a video showing a variable holding all the items in the list having say color column = Purple? and then in the automate use that variable (selected records of the list) to do the next step like compare with another list or update it, etc. If so, can you please direct me to that link? Thanks again for your ingenuity in making things easier for all of us!
Thank You. I do not have a specific video on this use case. May be it was a part of one of my flow videos. I will recommend you check on the forums at powerusers.microsoft.com/
Thanks for the video! Question? So then what do you do with the JSON file you created? How do you use the file with all the variables in Power Automate?
It is not a file. It is just JSON data. You can use it across your flow as a variable and read data from within. You can also update its data in the flow. I uploaded a sample flow showcasing it on my GitHub repo github.com/rdorrani/Microsoft-Flow/blob/master/Expressions401-ReducenumberofVariables-SaveAPICalls_20210211210303.zip
Really really helpful video. I'm curious though, is it possible that each time a row of data in sql has been created, that a flow can take that data and initialise a variable in another flow, using the same idea you've demonstrated here?
New row in SQL has a trigger in flow. Why would you want to initialize a variable in another flow? Why not the work done by the flow that gets triggered when new row is added in SQL?
@@RezaDorrani So i have several flows which need to be set up the way they are, as it's a multi-step process which requires retrieving data using one api feeding it into a sql table, then triggering another flow to retrieve further information from another site. Then the data I need for a third table is based upon a column from the first table. At the moment, I've manually inputted initialised/setup variables which the third table uses to insert a row, however for each new record that is added, a corresponding variable needs to be added to the third sql table to search.
@@wrmbanks2260 If you need to pass the value across flows, then you need to look into child flows. docs.microsoft.com/en-us/power-automate/create-child-flows
Thanks Reza, This is very useful video and I am using the same approach in my tasks, However I am having query, how to update multiple properties. in your video you have demonstrate to update one property using setProperty however If I would like to update vName, vTitle and vCompany using one compose, is that possible?
@@RezaDorrani I have tried with multiple setProperties in one compose however it is not when I try to set to variable, it is not working. Can you please help with any example with multiple property set. Thanks in advance.
Hi Rezza , I am using setproperty in an apply to each loop and updating new updated value of the object to excel column data but after the first iteration the data resets to 0 rather than holding the previous updated value can you help me with this
I have not come across this issue 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
Hi Reza, Amazing videos as always. What would be the syntax for updating the array element within the object variable? and also the syntax from removing an array element within the object variable? Thank you,
Thanks! I did this video a while ago and covered most scenarios. Not sure if this was covered or not. I do not know the syntax by heart. It would be best to check the documentation for the functions showcased in video.
Hi again@@RezaDorrani, ChatGPT provides the following syntax. For updating. union(variables('yourArray'), { "index": 0, "value": 'new_value' }) and for removing. union(take(variables('yourArray'), indexOfElementToRemove), skip(variables('yourArray'), indexOfElementToRemove + 1)) Does it look ok to you? Thanks again,
@@mocanada304 I cannot guess here on chat without reproducing the same on flow. Chat is pure text. Looks good - Yes but that may not be the best answer. I would recommend posting your query/issue with screenshots on the forums at powerusers.microsoft.com
The flow creator is creating the AND OR conditions. docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#logical-comparison-functions
I have done very little work with PVA so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
How do you update multiple values in the object? For me my object is with empty variables at first, but if I put multiple SetProperty, SetProperty etc in the Compose Input, I get multiple Outputs with only the associated variable updated
The video is the best reference I have. 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
Hi Reza, do you have video wherein You copy the array values from one sharepoint to another? but instead of an array you convert it into a text value? Thanks in advance
Hi Reza, I came here from a video on Jon Levesque’s channel about reducing the number of variables in order to reduce the number of API calls the flow uses. In this case wouldn’t it end up using more API calls than just using lots of variables? Since using this method you only have to set up one variable but then use 2 API calls (compose, then set) every time you want to update a variable, whereas without this method you would have to set up a bunch of variables but then only use one API call to update them? This is for a large amount of updates for variables
@@RezaDorrani in my scenario I’m looping through a table with a for each loop, and incrementing four variables by four numbers in the current table row. However a number won’t always be present there, so right now it me got it set up so it checks if the value is not null then increments the variable, repeated four times. Is there a way to do something like this all in one step using these object variables?
Hello rezza , Good morning . Hope you are doing good and staying safe. Wanted to check if there is another way to declare and initialize multiple variables in one place. Creating so many variables makes the flow design very bigger and fatterand wierd to read. I have one use case where i need to send emails to owners and admins to have right no of ownership for their sites . there will be scenarios like 0 SCA and 1 owner , then send email to owners , 1 SCA and 1 or more owners , send eamil to SCA. , like that for other more scenarios. as of now I created a flow with declaring 2 string variables for Owners and admins respectively . 4 array variables for owners to store the names of owners based on their count calculated using length function . Similarly 4 variables for admins doing the same thing. Then in apply to each loop I am applying conditions based on the count and appending it to respective array variables which would then be used to send emails to respective count owners (like 1 wale or 2 wale )in last step. then in another apply each same thing is designed for admins. now when I try to combine both the outputs in my final condition to send email then I am getting warning it should be part of parent for each . Is there another way to do so without creating so many variables doing above steps . I want to make my flow simpler .with my approach I am assuming it is becoming more complex
I would have to recreate your scenario to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Thank you for the informative video. I am about to be a power automate dev following your videos:) I am stuck to a place.. In Power automate/Flow, how can we set the value of any single cell (i.e cell A2) of a table (of Excel Online for Business) to a variable?
Thank You. I do not have a video based on your scenario. There is one on excel th-cam.com/video/Kupz71dWYyY/w-d-xo.html which may help. I will also recommend you check on the forums at powerusers.microsoft.com/
Hi Reza I have a question: Is it possible to remove comma from a number value and convert that decimal number to whole number in power automate platform. For example: I want to convert 1,27.89 to 128. Here I want to remove comma after 1,2XXX and covert the decimal number 127.89 to 128. Please help
I would guess Yes but would require expressions. I do not have a video reference on this and would have to try it out myself to know more about it. I will recommend posting your query with screenshots on the forums at powerusers.microsoft.com May be someone has done something similar.
Hi Reza, can you explain how to convert a SharePoint date (string: 2011/4/25) into a number format to update an Excel field value that won't accept a date in string format? Thanks!
@@RezaDorrani I have office 365 groups that I would like to retrieve the members of each groups into a csv file. I have captured the output into a variable then parse json, used a select component after parse json get the get the columns that I want to retrieve. After the select component I have used create csv table component and then create file to store the csv into my share point document My biggest issue is that some data get created into the csv file while some data keep failing and I don’t know what is causing some records to fail nor how to make those data work
@@ThegracesOfFaith 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
I attempted to recreate your simple example and run the flow, but I got the following message: The variable 'varExpertise' of type 'Array' cannot be initialized or updated with value of type 'String'. The variable 'varExpertise' only supports values of types 'Array'. Where did I go wrong?
As per the error, you are providing data type string where the expression expects an array. 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
Trying to understand the benefits of using this method. The idea was to reduce the number of variables and complexity. But, If the variables you want to work with all require manipulation, you will need to create a compose statement for each variable anyways. So you are essentially replacing the initialize variable with a compose. So not sure if you are really reducing the flow's complexity. You are making it easier to read the variables up at the top. However, making it more complex to read the operations that are performed on variable throughout the flow. As each manipulation will require a compose and set variable. And to analyze what the operation is doing; I have to analyze an expression of each of the compose. I am new to power platform, and maybe I am missing something.
Idea was to reduce number of variables. Reducing complexity was not a claim. Complexity is high. You can update 4-5 variables in one go with a single compose vs what you could do with multiple variables. I would suggest sticking with regular initialize variable and update variable if complexity showcased in video is high.
@@RezaDorrani After working on a project for the past 2 hours (after I posted my initial comment) I realized the benefit. I'm working with a nested loop where I am incrementing 10 variables by 1. Then once one interation is done, I have to reset all variables to 0 and do 2 more iterations. That means I got to initialize 10 variables. Then increment 10 variables. Then set 10 variables back to 0. Using your method. I have 1 record variable. I increment 10 variables inside of the record variable. And then reset all variable to 0 in one compose command. At least, that is what I have conceptualized right now. Thanks. Your content has greatly helped me.
@@RezaDorrani hmm my scenario is: I have an ID that can be blank sometimes because it is a optional field from my form. Power Apps doesn't run my flow once the variable is set up as integer and the ID value is blank. I think that null expression would not work because the initialize variable step is not even triggered. I guess.
@@pedrosanteloy Now thats a different use case. Depends on how flow is being triggered. Tough to provide guidance here on chat without looking at the flow and scenario. I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com
I have an MS Form that creates or updates tables on Dataverse through Power Automate which all works fine. I have a section which requires a one to many relationship (as a repeating table) for the record I am updating. In this section the form has a set of 3 questions which are repeated should the worker have extra work and needs to enter more answers as shown in the diagram. I set up a simple JSON which brings out the first set of data but I don't know how to pick up all three. To complicate matters the user may not need to fill any of the sets if there are no extra works. Do you have a video on getting a 'one to many' records from an MS Form to Dataverse or similar? Form Main Table Multi Table Question1 ID Auto ID Field1 Field2 Field3 Foreign Key Question2 123 234 Answer1 Answer2 Answer3 123 Question3 235 Answer1 Answer2 Answer3 123 More Questions Y/N 236 Answer1 Answer2 Answer3 123 Question1 Question2 Question3 More Questions Y/N Question1 Question2 Question3 More Questions Y/N
Looks like a question related to a specific use case. This would be tough to solve on chat. I would recommend you post your query with screenshots on the forum at powerusers.microsoft.com/
How can I merge a function into an expression to compose one outcome? Goal: To return the JSON value of a property name dynamically as a simplified Switch control. E.g. outputs('monthsTableJSON').March but I want that .March or ?['March'] to be replaced with a String coming from formatDateTime(utcnow(), 'MMMM')
Not sure I understood your question. You can write multiple expressions together. Check aka.ms/learnexpressions to learn more about expressions.
3 ปีที่แล้ว +1
@@RezaDorrani Thank you, I ♥ those series, watched several times, finally I made my simple expression work, no doubts you did not understand my question fully. Was too simple and obvious. 👍 outputs('monthsTableJSON')?[formatDateTime(utcNow(),'MMMM')]
@@RezaDorrani I have 10 start and wait approval process (using parallel flow), for each i made initialize variable for comment. That why they are different response comment come from output. So i want to orgnize that 10 variable can we put this method can work? thanks for patient my english.
This is a godsend... Thanks a LOT for this. It's a brilliant approach to simplify so many big and complex existing flows we've at work. Thank you for sharing.
Thanks for watching. So happy to know this is useful.
i guess Im asking the wrong place but does someone know of a way to get back into an Instagram account..?
I was stupid lost the password. I love any tricks you can offer me
@Thatcher Collin Instablaster :)
I’m not sure how often folks leave comments on videos that they’ve seen once and then gone back the video much later. This is one of those comments. I came across this when I first came across the power platform. I’ve never been a programmer or anything like that, and this particular video was way above my ability to comprehend at that time. Today, about two years later, I will use this as a best practice. I’m guessing when it comes to leveraging values using loops, I have some experimenting to do. But I should be able to leverage the item property to get this done. Although at this time, I cannot afford to become a member of your channel, I know what I know today because of you… Thanks mate!
You are most welcome
Reza, I love your channel man. Thank you for helping out the IT community. This would be very hard for me to pick up without your videos and initiative. Much respect.
Thank you so much for your kind words. I try my best to provide valuable content and it means a lot to get such feedback.
You have inspired me to reshape my business by adding these technologies. Your lessons are very helpful. I’ve gotten myself in a bit too deep with a project for my number 1 client. I continue to search videos for answers to some of my new challenges. Nonetheless I always learn things from you. Thank You Reza
You are most welcome and thanks for watching and learning from my videos.
This is so helpful and time-saving - you point out the essentials and more in a very concise way. Thank you!
You are most welcome!
A great overview to using variables with expressions. Thanks for sharing.
Thanks for watching
Nice Explanation RD! Thank you for the video and tips
Welcome!
WOW .. Great video. Love how your flows work 1st time all the time! 😅
Thank you! Cheers!
This is Gold worth Information.. Saluting !!!
Thank You!
Reza, this video was brilliant! Thank you so much.
You are so welcome!
Thanks a lot Reza, it is also a useful tutorial on how to update object properties and arrays elements in general. Thank you again for putting this together.
You are most welcome!
Tips like these make our lives easier! ☺
Glad to hear that
This is fantastic, thank you Reza!
Most welcome!
Thanx Reza for such a beautiful explanation.....
Glad it was helpful!
Very helpful. Thank you.
Welcome
Hi @Reza... thanks for your videos... well I was curious if there are many variables in a flow can we store all of them in a single place(as we do to add all the related steps in scope), variables can not be added to scope.. so is there any why to place all in a single block.
Initialize variable actions cannot be in a scope.
This is very helpful thanks a lot Reza :)
Glad it was helpful!
Thanks 🙏🙏🙏 very interesting Reza
Most welcome
Thanks so much for this, Reza! Running into a issue and hoping you can help. I have a variable called varProfile mimicking yours. I would like to use the compose function with the 'setProperty' expression. However, I would like it to compose two var's within the json of the variable, varProfile.
For example, I would like it to set the "varApproverName" and "varApproverComments" within the variable varProfile.
I am able to have it compose both of those but I can't get it to set both as it runs into an error of "The variable 'varProfile' of type 'Object' cannot be initialized or updated with value of type 'String'. The variable 'varProfile' only supports values of types 'Object'."
Would I need to run the compose and set variable with the output twice for each value? Is it possible to do it in just one of each?
I have not come across this issue & hence not sure what the resolution is. Debugging issues here on chat is not a good option. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you for theis great video! What about the Date/Time variables. I see them in the documentation for the desktop flow but not the cloud flows. I wanted to get the max and min of two dates but there is no straightforward way of doing it.
I have not tried max and min for dates. Im sure there are expressions that can be framed for it. I would recommend checking or posting your query on forums in case someone has done something similar
powerusers.microsoft.com
Thank you Reza! I've found a way to do it through ticks() 🙂
Awesome job, you explain very well.
Thank you!
This is awesome. I watched this like 5 times.
BTW, How did you do the magnifying glass? That was nice.
Thanks for watching so many times :)
The magnifying is a feature of my software recording tool Camtasia.
very interesting, thanks for share
Thanks for watching
Excellent, easy-to-follow instructions for someone that has been desperately trying to understand what variables are and what role they play in flows. Question - is there any way to hide the initial variables that you initialize so you just see the Compose? That would make it super clean! Regardless, I really appreciate your training style and info. On to your next tutorial. Cheers!
Thank you for the amazing feedback Amy.
You cannot hide the actions inside flow.
Hope you enjoy all the videos on this channel.
Thanks Reza! However, does anyone know if it is possible to set multiple properties of a variable at once?
Possible. I believe I have a sample flow on my GitHub repo that shows that.
Check github.com/rdorrani/Microsoft-Flow/blob/master/Expressions401-ReducenumberofVariables-SaveAPICalls_20210211210303.zip
Hi Reza! Do you have any video that instead of using hard coded schema receives variables informations like a json ou collection coming from powerapps? tks!
A lot of them.
Check -
th-cam.com/video/tQCBWMR7T64/w-d-xo.html
th-cam.com/video/r3UC3TMXhlI/w-d-xo.html
th-cam.com/video/Da4do2DxmJE/w-d-xo.html
Wow! I’ll give this a try
Give it a shot
Hi Raza!
I am new to Power Automate and have been learning from your videos. I am trying to send MS forms response to Sharepoint List. Some response questions have multiple choice, so I followed the popular method of initialize an array variable, remove extra symbols from Microsoft Forms string output, split the previous line into an array, append to array variable using a formula.
It works perfectly, but now I have created multiple array variables for each multiple question in a single initiate variable action as you have described. How can I get the multiple choice response for each question from MS forms into its corresponding variable?
I do not have a video reference on this specific 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.
Excelent content!! How to learn more about expressions in power automate ? Thanks and great job!
Thank You.
For expressions check th-cam.com/video/O97IdCbfMQI/w-d-xo.html
Thank you very much, thanks to your videos I have managed to set up a workflow that works correctly from a form to the sending of a summary email.
But I still have an minor issue. I constructed a Likert-type form. And I would like to get in a variable only a certain type of value. For example. Question 1 Answer 1 Answer 2 Answer 3
My idea would be to have a variable that would store only the A3's to display in an email, but I'm interested in another idea. The long way would be to do it with conditions, but that's not very elegant when you have a lot of possibilities.
I do not have a video reference on this scenario and would have to try it out to provide guidance.
I did videos with forms (might have included likert type). Check th-cam.com/video/kbqXsKPTmZk/w-d-xo.html & th-cam.com/video/4eWGdi_C2hQ/w-d-xo.html
I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks Reza, I will do
Great idea. Love it !!!!
Thank you
Thank you
Thank you again for this video... as part of my learning I would like to do a similar video and publish it in Italian. Thank you!
Go for it!
Really superb. Is there any help link available by Microsoft for those functions?
aka.ms/learnexpressions
docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference
This video was supposed to be introducing the use of variables as per the subject. But its actually focusing more on reducing the number of variables.
To reduce also one has to use. I do show initializing and setting.
4:33- is this what I need to do to take the objects out of my arrays in Power BI? Power BI dynamic content is arrays, not objects, so every time I try and do something, it puts it in an Apply to Each, and there are just WAAAY too many loops going on in my flow, it's insane. Do I have to do this Expression thing to all my dynamic content so I can have a normal clean flow?
Check my videos on power bi and power automate.
Hi Reza, thank you for all your videos, they are really helpful and I have created many flows using your videos.
Would you be able to do a demo of how I could create a Power Automate Flow to calculate the number of characters in a specific question response whenever a MS Form is submitted.
Currently my flow takes the Form into a List and I would like a field in this list to detail that character count (which includes all words, spaces, puntuation etc in the count).
Hope you can help. Many tahnks
I make videos when I get multiple requests on a topic. Each quarter, I ask for topic suggestions on "Community Tab" of my channel. Most voted ideas get added to backlog. The topic suggestion post is currently active.
Hi Reza: Thank you for this very useful video. Also, do you have a video showing a variable holding all the items in the list having say color column = Purple? and then in the automate use that variable (selected records of the list) to do the next step like compare with another list or update it, etc. If so, can you please direct me to that link? Thanks again for your ingenuity in making things easier for all of us!
Thank You.
I do not have a specific video on this use case. May be it was a part of one of my flow videos.
I will recommend you check on the forums at powerusers.microsoft.com/
Thanks for the video! Question? So then what do you do with the JSON file you created? How do you use the file with all the variables in Power Automate?
It is not a file. It is just JSON data. You can use it across your flow as a variable and read data from within. You can also update its data in the flow.
I uploaded a sample flow showcasing it on my GitHub repo github.com/rdorrani/Microsoft-Flow/blob/master/Expressions401-ReducenumberofVariables-SaveAPICalls_20210211210303.zip
@@RezaDorrani Thank you
Really really helpful video. I'm curious though, is it possible that each time a row of data in sql has been created, that a flow can take that data and initialise a variable in another flow, using the same idea you've demonstrated here?
New row in SQL has a trigger in flow.
Why would you want to initialize a variable in another flow? Why not the work done by the flow that gets triggered when new row is added in SQL?
@@RezaDorrani So i have several flows which need to be set up the way they are, as it's a multi-step process which requires retrieving data using one api feeding it into a sql table, then triggering another flow to retrieve further information from another site. Then the data I need for a third table is based upon a column from the first table. At the moment, I've manually inputted initialised/setup variables which the third table uses to insert a row, however for each new record that is added, a corresponding variable needs to be added to the third sql table to search.
@@wrmbanks2260 If you need to pass the value across flows, then you need to look into child flows. docs.microsoft.com/en-us/power-automate/create-child-flows
@@RezaDorrani Great thanks for the link! Looks to be what I need 🤞🏻
Nice video. It save my work. Can we get the json code from a file? thanks
Possible.
Thanks Reza, This is very useful video and I am using the same approach in my tasks, However I am having query, how to update multiple properties. in your video you have demonstrate to update one property using setProperty however If I would like to update vName, vTitle and vCompany using one compose, is that possible?
By writing multiple expressions together. Possible!
@@RezaDorrani I have tried with multiple setProperties in one compose however it is not when I try to set to variable, it is not working. Can you please help with any example with multiple property set. Thanks in advance.
@@vivekanandade7049 I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
thanks - very informative!
Your welcome
Hi Rezza ,
I am using setproperty in an apply to each loop and updating new updated value of the object to excel column data but after the first iteration the data resets to 0 rather than holding the previous updated value can you help me with this
I have not come across this issue 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
Is it possible to use object variables in a loop action (sum)?
Probably possible but not something I have tried
Hi Reza,
Amazing videos as always.
What would be the syntax for updating the array element within the object variable? and also the syntax from removing an array element within the object variable?
Thank you,
Thanks!
I did this video a while ago and covered most scenarios. Not sure if this was covered or not.
I do not know the syntax by heart. It would be best to check the documentation for the functions showcased in video.
Hi again@@RezaDorrani,
ChatGPT provides the following syntax.
For updating.
union(variables('yourArray'), { "index": 0, "value": 'new_value' })
and for removing.
union(take(variables('yourArray'), indexOfElementToRemove), skip(variables('yourArray'), indexOfElementToRemove + 1))
Does it look ok to you?
Thanks again,
@@mocanada304 I cannot guess here on chat without reproducing the same on flow. Chat is pure text. Looks good - Yes but that may not be the best answer.
I would recommend posting your query/issue with screenshots on the forums at powerusers.microsoft.com
What if you have multiple vName values and you just want to select Justin Smith as an example, how would you do that?
Did this video a while ago. I would have to try it out to know how that can be done.
hello can you tell how we can use And OR opertion in condtion in powerflows
The flow creator is creating the AND OR conditions.
docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#logical-comparison-functions
any way to make these variables into global variables that can be used in PVA to carry information across multiple topics?
I have done very little work with PVA so not sure.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
How do you update multiple values in the object?
For me my object is with empty variables at first, but if I put multiple SetProperty, SetProperty etc in the Compose Input, I get multiple Outputs with only the associated variable updated
The video is the best reference I have.
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
What if you need to us the "Ask in Power Apps" feature? How would you type that?
Add compose action, select ask in Power Apps.
Then go to peek code for compose action and copy the expression formula.
Hi Reza, do you have video wherein
You copy the array values from one sharepoint to another? but instead of an array you convert it into a text value? Thanks in advance
I do not have a video on that. I would recommend to check on the forums at powerusers.microsoft.com
Hi Reza, I came here from a video on Jon Levesque’s channel about reducing the number of variables in order to reduce the number of API calls the flow uses. In this case wouldn’t it end up using more API calls than just using lots of variables? Since using this method you only have to set up one variable but then use 2 API calls (compose, then set) every time you want to update a variable, whereas without this method you would have to set up a bunch of variables but then only use one API call to update them? This is for a large amount of updates for variables
You can update multiple variables in a single compose action as well. You can stitch expressions together.
@@RezaDorrani in my scenario I’m looping through a table with a for each loop, and incrementing four variables by four numbers in the current table row. However a number won’t always be present there, so right now it me got it set up so it checks if the value is not null then increments the variable, repeated four times. Is there a way to do something like this all in one step using these object variables?
@@LimpChiken Im not sure if there is an option.
Hello rezza ,
Good morning . Hope you are doing good and staying safe.
Wanted to check if there is another way to declare and initialize multiple variables in one place. Creating so many variables makes the flow design very bigger and fatterand wierd to read.
I have one use case where i need to send emails to owners and admins to have right no of ownership for their sites . there will be scenarios like 0 SCA and 1 owner , then send email to owners , 1 SCA and 1 or more owners , send eamil to SCA. , like that for other more scenarios.
as of now I created a flow with declaring 2 string variables for Owners and admins respectively . 4 array variables for owners to store the names of owners based on their count calculated using length function . Similarly 4 variables for admins doing the same thing. Then in apply to each loop I am applying conditions based on the count and appending it to respective array variables which would then be used to send emails to respective count owners (like 1 wale or 2 wale )in last step. then in another apply each same thing is designed for admins. now when I try to combine both the outputs in my final condition to send email then I am getting warning it should be part of parent for each . Is there another way to do so without creating so many variables doing above steps . I want to make my flow simpler .with my approach I am assuming it is becoming more complex
I would have to recreate your scenario to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Excellent
Thank you
Hi Reza,
Thank you for the informative video.
I am about to be a power automate dev following your videos:)
I am stuck to a place..
In Power automate/Flow, how can we set the value of any single cell (i.e cell A2) of a table (of Excel Online for Business) to a variable?
Thank You.
I do not have a video based on your scenario.
There is one on excel th-cam.com/video/Kupz71dWYyY/w-d-xo.html which may help.
I will also recommend you check on the forums at powerusers.microsoft.com/
Awesome
Thanks
Can we set boolean in set property.
Yes. Just use true or false as expression to set its value.
Hi Reza I have a question: Is it possible to remove comma from a number value and convert that decimal number to whole number in power automate platform. For example: I want to convert 1,27.89 to 128. Here I want to remove comma after 1,2XXX and covert the decimal number 127.89 to 128. Please help
I would guess Yes but would require expressions. I do not have a video reference on this and would have to try it out myself to know more about it.
I will recommend posting your query with screenshots on the forums at powerusers.microsoft.com
May be someone has done something similar.
Hi Reza, can you explain how to convert a SharePoint date (string: 2011/4/25) into a number format to update an Excel field value that won't accept a date in string format? Thanks!
You would need to use expressions. I will recommend you check on the forums at powerusers.microsoft.com/
Can you take the variable output into a csv file?
Possible but not something I have tried
@@RezaDorrani I have office 365 groups that I would like to retrieve the members of each groups into a csv file. I have captured the output into a variable then parse json, used a select component after parse json get the get the columns that I want to retrieve.
After the select component I have used create csv table component and then create file to store the csv into my share point document
My biggest issue is that some data get created into the csv file while some data keep failing and I don’t know what is causing some records to fail nor how to make those data work
@@ThegracesOfFaith 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
@@RezaDorrani thank you 🙏
I attempted to recreate your simple example and run the flow, but I got the following message:
The variable 'varExpertise' of type 'Array' cannot be initialized or updated with value of type 'String'. The variable 'varExpertise' only supports values of types 'Array'.
Where did I go wrong?
As per the error, you are providing data type string where the expression expects an array. 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 Thanks a bunch! I will do that!
Thank you Rezza, I'm wondering how can we use variables when we have to call a soap API?
When making the SOAP call via flow you can just pick the variables from dynamic content.
Trying to understand the benefits of using this method. The idea was to reduce the number of variables and complexity. But, If the variables you want to work with all require manipulation, you will need to create a compose statement for each variable anyways. So you are essentially replacing the initialize variable with a compose. So not sure if you are really reducing the flow's complexity. You are making it easier to read the variables up at the top. However, making it more complex to read the operations that are performed on variable throughout the flow. As each manipulation will require a compose and set variable. And to analyze what the operation is doing; I have to analyze an expression of each of the compose. I am new to power platform, and maybe I am missing something.
Idea was to reduce number of variables. Reducing complexity was not a claim.
Complexity is high. You can update 4-5 variables in one go with a single compose vs what you could do with multiple variables.
I would suggest sticking with regular initialize variable and update variable if complexity showcased in video is high.
@@RezaDorrani After working on a project for the past 2 hours (after I posted my initial comment) I realized the benefit. I'm working with a nested loop where I am incrementing 10 variables by 1. Then once one interation is done, I have to reset all variables to 0 and do 2 more iterations. That means I got to initialize 10 variables. Then increment 10 variables. Then set 10 variables back to 0. Using your method. I have 1 record variable. I increment 10 variables inside of the record variable. And then reset all variable to 0 in one compose command. At least, that is what I have conceptualized right now. Thanks. Your content has greatly helped me.
@@RezaDorrani Any chance do you have a tutorial on how to set property to update multiple variables? I can't seem to figure that part out.
@@skim32 I don’t
Hello... How could I initialize a variable (integer) with null value?
You could use the expression null
@@RezaDorrani hmm my scenario is:
I have an ID that can be blank sometimes because it is a optional field from my form.
Power Apps doesn't run my flow once the variable is set up as integer and the ID value is blank.
I think that null expression would not work because the initialize variable step is not even triggered. I guess.
@@pedrosanteloy Now thats a different use case. Depends on how flow is being triggered. Tough to provide guidance here on chat without looking at the flow and scenario. I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you, Reza! I will (:
I have an MS Form that creates or updates tables on Dataverse through Power Automate which all works fine. I have a section which requires a one to many relationship (as a repeating table) for the record I am updating. In this section the form has a set of 3 questions which are repeated should the worker have extra work and needs to enter more answers as shown in the diagram. I set up a simple JSON which brings out the first set of data but I don't know how to pick up all three. To complicate matters the user may not need to fill any of the sets if there are no extra works. Do you have a video on getting a 'one to many' records from an MS Form to Dataverse or similar?
Form Main Table Multi Table
Question1 ID Auto ID Field1 Field2 Field3 Foreign Key
Question2 123 234 Answer1 Answer2 Answer3 123
Question3 235 Answer1 Answer2 Answer3 123
More Questions Y/N 236 Answer1 Answer2 Answer3 123
Question1
Question2
Question3
More Questions Y/N
Question1
Question2
Question3
More Questions Y/N
Looks like a question related to a specific use case. This would be tough to solve on chat. I would recommend you post your query with screenshots on the forum at powerusers.microsoft.com/
@@RezaDorrani Thank you Reza. I will do that.
How can I merge a function into an expression to compose one outcome? Goal: To return the JSON value of a property name dynamically as a simplified Switch control. E.g. outputs('monthsTableJSON').March but I want that .March or ?['March'] to be replaced with a String coming from formatDateTime(utcnow(), 'MMMM')
Not sure I understood your question. You can write multiple expressions together.
Check aka.ms/learnexpressions to learn more about expressions.
@@RezaDorrani Thank you, I ♥ those series, watched several times, finally I made my simple expression work, no doubts you did not understand my question fully. Was too simple and obvious. 👍 outputs('monthsTableJSON')?[formatDateTime(utcNow(),'MMMM')]
@ Great!
Genius!
Thank you Dan
👏👍
🙏
Thanks Reza
Most welcome
i used parallel flow, if i used for 10 comment for this can be?
10 comment? I did not understand your question
@@RezaDorrani I have 10 start and wait approval process (using parallel flow), for each i made initialize variable for comment. That why they are different response comment come from output. So i want to orgnize that 10 variable can we put this method can work? thanks for patient my english.
@@laminkhant8875 Im not sure about that. Something you would have to try out and see if it works.