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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,688)