Hey Gonzalo. Great question. You can do numerical operations like this: %YourNumericalVariable1 + YourNumericalVariable2% or %YourNumericalVariable * 25% etc Kind regards, Anders
Anders - an excellent video. Particularly impressed with lists. For some unknown reason the Display input dialog doesn't work on my pc. Could be a settings issue.
is it possible to only see the variables that is in the active sub-flow that I have open? like to have local variables so I don't see everything else that is not important outside the sub-flow.
Hey Roni Mrov. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
How can I include a list as variables in the "Add item to list" action? Specifically, I want to use the following format: `%{[%ID%, %Name%, %Description%]}%`.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
I have what I think is a more complex need - using a date variable to pass to PowerPoint to do a Find/Replace of text in the file and then save the new file with a new name based on month. formatDateTime(subtractFromTime(utcNow(), 1, 'month'), 'MMMM yyyy') is the variable I'm trying to use Send Keys action to do the Find/Replace, but I can't figure out how to pass it as the resulting month/year. It only pastes into PowerPoint as the literal text of the variable. Is it possible to do what I want it to do? I'm using a Send Keys like '{LControlKey}{H}' VariableName1 '{Tab}' VariableName2 '{Alt}{A}{Return}' Is it possible to get the Find/Replace action in PowerPoint to type the month name 2 in the past and 1 in the past?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Got it. Set Variable action, the variable is the list that you created earlier in your code. The value is: %[CustomFormData['T1'], CustomFormData['T2']]% So you add %[ then you put the variable names with commas between them, then you close with ]%
@@andersjensenorg Just noticed the syntax i used in my question, is the same one that I used in the solution. Not sure what happened the first time around, but I was able to get it working :) Thanks for the video.
If this video helps you, then you can help this channel and me a lot by giving it a thumbs up. Thank you 😊
List variables - that was an excellent performance. Well done you!
Hey Quinton - thanks a ton for the nice message 😎😍
Amazing Anders! Thanks for sharing your knowledge
My pleasure, Fernando - thanks for the nice comment 🙏😊
Amazing Stuff, this will help me a lot in my automation journey. Thnaks
Very nice to hear, Syed 🙌😍
Thank You, Anders. Your presentations are very interesting.
It's my pleasure, MCN 😊
Great video from Anders. Keep up the great work.
What about sum, rest, multiply and all the other math operation on Numeric Variables?
Hey Gonzalo. Great question. You can do numerical operations like this: %YourNumericalVariable1 + YourNumericalVariable2% or %YourNumericalVariable * 25% etc Kind regards, Anders
Anders - an excellent video. Particularly impressed with lists. For some unknown reason the Display input dialog doesn't work on my pc. Could be a settings issue.
Hey Quinton. Thanks a lot for the nice words. That's strange 😣 What's the error message?
Change in "If function ButtonPressedDisplayMessage". they work
is it possible to only see the variables that is in the active sub-flow that I have open?
like to have local variables so I don't see everything else that is not important outside the sub-flow.
It would be nice, if you could define the scope for your variables, but not possible in PAD (yet) 😔
Good tutorial. Thanks!
Hey Roni Mrov. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 5000+ RPA developers networking and solving problems: ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
how can I get an excel file from Power Automate WEB with Power Automate Desktop?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
How can I include a list as variables in the "Add item to list" action? Specifically, I want to use the following format: `%{[%ID%, %Name%, %Description%]}%`.
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
I have what I think is a more complex need - using a date variable to pass to PowerPoint to do a Find/Replace of text in the file and then save the new file with a new name based on month.
formatDateTime(subtractFromTime(utcNow(), 1, 'month'), 'MMMM yyyy') is the variable I'm trying to use Send Keys action to do the Find/Replace, but I can't figure out how to pass it as the resulting month/year. It only pastes into PowerPoint as the literal text of the variable. Is it possible to do what I want it to do? I'm using a Send Keys like '{LControlKey}{H}' VariableName1 '{Tab}' VariableName2 '{Alt}{A}{Return}' Is it possible to get the Find/Replace action in PowerPoint to type the month name 2 in the past and 1 in the past?
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Please help add multiple variables to a list. %[OtherList['something'], OtherList['somethingelse']]% is not working
Got it. Set Variable action, the variable is the list that you created earlier in your code. The value is: %[CustomFormData['T1'], CustomFormData['T2']]% So you add %[ then you put the variable names with commas between them, then you close with ]%
Thanks a lot for coming back with the answer, Alfredo 😊
@@andersjensenorg Just noticed the syntax i used in my question, is the same one that I used in the solution. Not sure what happened the first time around, but I was able to get it working :)
Thanks for the video.