Application Command Line Argument

(0) Share

Report

Posted on by mamouth

Hi everyone

In my script I run an application launching my VPN.

In the command line argument, I currently have CONNECT in place, which successfully launches the VPN.

However I would like the script to randomly choose between a series of predefined text commands, specifically locations.

For example CONNECT UNITED KINGDON, CONNECT FRANCE etc.

What is the best way to create a dynamic input for the command line argument? I tried creating list etc, doesnt seem to work

Thanks much

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

I would:

Create List (add all locations to the list) to %Locations%
Set random whole number between 0 and %Locations.Count - 1% to %Rand%
Then, where you need it in your command line, use %Locations[Rand]% to pull the random location.

If that doesn’t work, then do the same logic in Excel, have one cell be the random number and the cell next to it being a vlookup formula. Then you can read the value from the vlookup cell.

good luck!

Was this reply helpful? Yes No
mamouth 8 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the prompt answer @MichaelAnnis
for some reason, the command doesnt run when the input is not just plain text. i.e. the minute the input is coming from a list it's a no go, even if i only put one 'Connect' argument in the list of testing sake..

i'll spend more time on it tomorrow
Thanks

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

@mamouth, once you get it from the list try by using the Trim text action which will typecast it to a text format as well as remove any unwanted characters if there may be any at the start or end.

Hope you are taking care of adding a space between the CONNECT and the location name.

Was this reply helpful? Yes No
mamouth 8 on at

Like (1)

Report
Copy link

Link copied!

Thanks @VJR and @MichaelAnnis
Ultimately I used a combination of both solutions - Using the rand function in excel + vlookup for generate a random input for the command line.

Was this reply helpful? Yes No