cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yojie
Frequent Visitor

Creating Flow to extract data from Sharepoint list to Excel

Hi!

I am trying to create a monthly report which extracts the data from a Sharepoint list to an Excel Workbook. I managed to extract all the data except for the Multi-line field.. it is appearing as null, when in fact it contains data.

yojie_0-1632392367130.png

 

 

yojie_1-1632391992286.png yojie_0-1632391877961.png

Am I missing any required setting? Thank you in advance to Anyone who can assist/comment on this issue 🙂 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
eric-cheng
Solution Sage
Solution Sage

Hi @yojie ,

 

Do you have Append changes to existing text enabled for your column?

 

If so, have a look at this blog.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

View solution in original post

eric-cheng
Solution Sage
Solution Sage

Hi @yojie ,

 

Can you please try the HTML to text action and see if it removes all the HTML syntax? 

 

The blog outputted into a webpage which is why the HTML is formatted nicely.

 

ericcheng_0-1632477247267.png

 

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

 

 

View solution in original post

5 REPLIES 5
eric-cheng
Solution Sage
Solution Sage

Hi @yojie ,

 

Do you have Append changes to existing text enabled for your column?

 

If so, have a look at this blog.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

View solution in original post

yojie
Frequent Visitor

Hi Eric,

Yes, I have enabled the Append to existing text. Thank you for this, i will check out this blog and update if it solved my problem 🙂

 

Thanks once again!

yojie
Frequent Visitor

Dear Eric,

I have tried the suggested solution, it works in some extent. The problem is that i populate this view into an Excel sheet and it is showing as below, which is not user-friendly:

yojie_0-1632476303592.png

I was hoping that it would look the same as per the blog:

yojie_1-1632476467835.png

 

Would you be able to advise if there are any additional formatting i can do prior to populating it to Excel via Add row?

yojie_2-1632476652579.png

 

Thank you in advance for any recommendation you may have 🙂

eric-cheng
Solution Sage
Solution Sage

Hi @yojie ,

 

Can you please try the HTML to text action and see if it removes all the HTML syntax? 

 

The blog outputted into a webpage which is why the HTML is formatted nicely.

 

ericcheng_0-1632477247267.png

 

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

 

 

View solution in original post

yojie
Frequent Visitor

Thank you eric! This worked!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Users online (1,225)