Answered

set multiple variable from Single selection from

(0) Share

Report

Posted on by VIncent_AZK

Hi Community

I am setting up a monthly RPA flow, including creating files, pasting into excels, saving files into different folders, by Month.

I want to use a pop-up dialog (after user Clicked Run the RPA) to select the period (202401, 202402 or etc)the file is run for. After the user's input, the 3 variables will be set up automatically matching the selections (Below table, like an excel Vlookup on Col A, for Col B, C, D).

How do I do to set the three yellow variables by clicking the 202401, 202402 list?

I am pretty new to RPA and have no programming experience. I currently do this manually (without a dialog) by "Set variable" three times manually.

Appreciate your help!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (2)

Sort by

CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@VIncent_AZK

You can use "Display input dialog" or "Display select date dialog(if need to select any date as input)" to get your input from runtime and save into different variables and perform the above mentioned process.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
VIncent_AZK 25 on at

Like
a
(0)

Report
Copy link

Link copied!

I want to only enter input once, i.e. 202401 and then be able to trigger the automate creation of the three variables for the corresponding period.

I am currently creating the variables one by one but it is not sufficient, because the user of the flow will only want to enter the period, not the three variables.

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@VIncent_AZK

So all input value. Example 202401 have only one row in excel or it has multiple rows as well?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Verified answer

CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@VIncent_AZK

Please follow the below approach:

Code(Copy and paste the below code into your power automate desktop):
Variables.CreateNewDatatable InputTable: { ^['Input Data', 'File Name', 'Excel cell Column', 'Folder Name'], [202401, $'''Headcount File - Jan 24''', $'''A''', $'''01 Jan -24 Headcount Doc'''], [202402, $'''Headcount File - Feb 24''', $'''D''', $'''02 Feb -24 Headcount Doc'''] } DataTable=> DataTable Variables.RetrieveDataTableColumnIntoList DataTable: DataTable ColumnNameOrIndex: 0 ColumnAsList=> ColumnAsList Display.SelectFromListDialog.SelectFromList Title: $'''Select Input''' Message: $'''Select Input''' List: ColumnAsList IsTopMost: False AllowEmpty: False SelectedItem=> Selectednumber SelectedIndex=> SelectedIndex ButtonPressed=> ButtonPressed LOOP FOREACH CurrentItem IN DataTable IF CurrentItem[0] = Selectednumber THEN SET FileName TO CurrentItem[1] SET CellColor TO CurrentItem[2] SET FolderName TO CurrentItem[3] END END

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
VIncent_AZK 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot. Can I just confirm where can I enter the code you have provided?

Because when I open Datatable, it give me this only so can not paste in your code.

Was this reply helpful? Yes No
Verified answer

NathanAlvares24 1,714 Moderator on at

Like
a
(3)

Report
Copy link

Link copied!

Hi @VIncent_AZK !

@Deenuji meant to copy-paste that code onto your flow under a subflow.

Here are more detailed instructions on how to copy-paste it onto your flow:
1. Go to your flow

2. Copy this code (given in red)

3. Right click on your subflow (or main) and select Paste from the options

Voila!!!

Output:

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@NathanAlvares24 - Thanks

@VIncent_AZK - Please follow Nathan above guidance and let us know in case if you facing any issues.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No