cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Farhat
Regular Visitor

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
v-yuazh-msft
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

Farhat
Regular Visitor

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
Register for a Free Workshop.png

Register for a Free Workshop

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

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,807)