cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jon2249
Frequent Visitor

Visit Link in Excel based on User Input

I am new to PowerAutomate Desktop so please excuse me.

I am requesting the user to enter in a hotel Name in a  display input dialog. Lets Say they put in Benjamin. I would like Power Automate to copy the link in E4 and open in the browser. I was not sure if i should set the whole excel document as a variable path or if there is an easier way to do this. Thanks for your insight.

jon2249_2-1653343397507.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
MichaelAnnis
Super User
Super User

Launch Excel

Get first free row

Read from Excel C2 to C & %FirstFreeRow - 1% 'this is our list of hotels

Display select from list Dialog:

MichaelAnnis_1-1653345669510.png

Here is what the result looks like:

MichaelAnnis_0-1653345655814.png

This makes it so they can't make a bad selection.

Then, Read from Excel E & %SelectedIndex + 2% 'remember, indexes are 0 based, so Courtyard is 0, Residence Inn is 1, and so on.  So we add 2 to this index to get back to the corresponding row.  The URL for Courtyard is on E2 or E(0 + 2) where 0 is the %SelectedIndex%.

 

In my example, I selected Benjamin, Index 2, and %ExcelData2% brought back www.benjaminhotel.com:

MichaelAnnis_2-1653346049491.png

Then, just Launch Chrome with %ExcelData2% and you should be good to go.

 

Best of luck!

 

View solution in original post

2 REPLIES 2
MichaelAnnis
Super User
Super User

Launch Excel

Get first free row

Read from Excel C2 to C & %FirstFreeRow - 1% 'this is our list of hotels

Display select from list Dialog:

MichaelAnnis_1-1653345669510.png

Here is what the result looks like:

MichaelAnnis_0-1653345655814.png

This makes it so they can't make a bad selection.

Then, Read from Excel E & %SelectedIndex + 2% 'remember, indexes are 0 based, so Courtyard is 0, Residence Inn is 1, and so on.  So we add 2 to this index to get back to the corresponding row.  The URL for Courtyard is on E2 or E(0 + 2) where 0 is the %SelectedIndex%.

 

In my example, I selected Benjamin, Index 2, and %ExcelData2% brought back www.benjaminhotel.com:

MichaelAnnis_2-1653346049491.png

Then, just Launch Chrome with %ExcelData2% and you should be good to go.

 

Best of luck!

 

jon2249
Frequent Visitor

Michael,

You are amazing. I spent way too long on this and would have never been able to come about this. I obviously have a lot to learn and will continue to review Youtube Videos. I cant thank you enough!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Top Solution Authors
Top Kudoed Authors
Users online (1,813)