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: ruclips.net/video/xWFz-S96XGo/видео.html 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 Gonzalo. Great question. You can do numerical operations like this: %YourNumericalVariable1 + YourNumericalVariable2% or %YourNumericalVariable * 25% etc 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): ruclips.net/video/xWFz-S96XGo/видео.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): ruclips.net/video/xWFz-S96XGo/видео.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): ruclips.net/video/xWFz-S96XGo/видео.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 😎😍
Thank You, Anders. Your presentations are very interesting.
It's my pleasure, MCN 😊
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 🙌😍
Great video from Anders. Keep up the great work.
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: ruclips.net/video/xWFz-S96XGo/видео.html 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) 😔
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
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): ruclips.net/video/xWFz-S96XGo/видео.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): ruclips.net/video/xWFz-S96XGo/видео.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): ruclips.net/video/xWFz-S96XGo/видео.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.