Unanswered

Read excel online(SharePoint or OneDrive) and format content as table using flow

(1) Share

Report

Posted on by ginnaskuttery

Hi,

Is there any way to read Excel content (not table formatted) from SharePoint or OneDrive and then format the content as table after removing few rows.

Is this possible?, so far i got that MS flow cannot interact with excel without table formatted content. Is there any option available to interact with excel online without table formatted data?

Thanks

Ginnas

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-alzhan-msft on at

Like (0)

Report

Hi @ginnaskuttery ,

The answer is no, as you said, Microsoft flow could only interact with excel table.

I suggest that you could format the excel content to table firstly an then you could delete the rows in the excel table which you don't need.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
ginnaskuttery 14 on at

Like (0)

Report

Hi Alice,

Thanks for the reply,

So the conversion of excel content to table formatted needs to be done manually right? hope there is no way to do through flow.
Create table action was always giving me error while i am trying.

Thanks
Ginnas

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @ginnaskuttery ,

I suggest that you could format the content to table manually.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
VamsiGogineni 10 on at

Like (0)

Report

Hello,

Did we get any updates to read data from excel online without formatting it to a table or the situation is still the same?

Thanks,
Vamsi

Was this reply helpful? Yes No