cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Farhat
Level: Power Up

Get values from excel

Dears,

I have created approval workflow. I want to add actions after approval of the request.

I want to use data connecter to excel. The table consists three columns with values - email/value1/value 2.

 

I need to check it with "emails" column, then to get data from "value 1 and value 2" rows, as a dynamic content. Therefore, as a next action to write this values to the word template (Quick Parts).

advise how can this be done?

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Get values from excel

Hi @ Farhat,

 

Could you please share a screenshot of the configuration of your flow?

 

Where is your excel file saved in?

 

I have made a test on my side, and have created a excel table as below:

Capture.PNG

 

You could refer to screenshot below to create the flow:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

Regards,
Alice Zhang

Farhat
Level: Power Up

Re: Get values from excel

My apologies for late response,

I have achieved the result  (Get a row, part) by another method.

flow2.png

 

Next, I want to use "values" as Quick Parts to create a Word document from template.

 

I found "Plumsail connector" which can do this part of workflow. But I do not want to use third-party connectors.

Is it possible to implement this in another way?

 

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,279)