Answered

Creating Flow to extract data from Sharepoint list to Excel

(0) Share

Report

Posted on by yojie

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.

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

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

eric-cheng 5,171 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
yojie 31 on at

Like
a
(0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
yojie 31 on at

Like
a
(0)

Report
Copy link

Link copied!

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:
I was hoping that it would look the same as per the blog:

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

Thank you in advance for any recommendation you may have 🙂

Was this reply helpful? Yes No
Verified answer

eric-cheng 5,171 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

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

Was this reply helpful? Yes No
yojie 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you eric! This worked!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Would you mind sharing the whole flow chart? Might help me in my creation of my own.

Was this reply helpful? Yes No