Unanswered

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

All responses (3)

Answers (0)

Sort by

UshaJyothiKasibhotla 229 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @VIncent_AZK

Use Display input dialogue and give the required details

User input is the text that user typed and you can change the name as you required.

You can set the variables automatically.

Hope this helps,

Usha.
VIncent_AZK 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Usha

Thanks but is there a way to upload data from the below. I only know how to manually enter a table cell by cell which is very time consuming if my table is big.
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@VIncent_AZK

Where is your data currently right now? Is that exists in some excel file or please give me more background on the same?

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 🚀