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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,712)