cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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
Community Support

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

New Member

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Top Kudoed Authors
Users online (7,349)