Unanswered

Get rows from new created excel file in a sharepoint folder and move it to sharepoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Dear all,

I appeal to your knowledges today in order to solve the flow I'm building !

I need to get attachment (excel file) from email > transfert these file to sharepoint folder > create and get tables from this file > transfert these tables to sharepoint list.

The difficulty is to catch the information from a table which is unknown before the email reception and transfert it to a sharepoint list with dynamic content...

How could I move datas from a table which is unknown to SP list with dynamic content ?

Process : Receive email > move attachment to sharepoint folder > Get and create table > Get rows from table > move it to sharepoint list.

1 : Get attachments from email

Image 1.jpg

2 : Create file in sharepoint folder

Image 2.jpg

3: Create and get tables from this file :

image 3.jpg

4: List rows and move it to sharepoint list :

Image 4.jpg

Thanks a lot for your precious help !

KR,

Adrien

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

AnthonyAmador 2,557 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

What do you mean when you say unknown table? if that means that the headings its going to be different all the time, it seems complicated to do, because all the dynamic content of the table will be different and depend on the excel file, or does the excel table and the SP list have the same headings? can you explain me.

Also I want to know if the flow you share is working.

Cheers.

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

Like (0)

Report
Copy link

Link copied!

Hi Anthony,
When I say unknown table, it is because the table could be not created yet, it is about tables arriving every month (with the same Metadata/headings of course) but it is more about recognizing when table arrive in SP file.
The difficulty is to implement a system of recognizing future file in SP file and save its data to SP list.
The flow is working, but I cannot get all the datas for the step "creating item" in SP list, I can only get the ID of the file but not the data inside...
So I'm blocked at the step "creating item"...
Thank you for your help,
PS: Sorry for the delay of answering I was in vacation
Kind regards,
Adrien

Was this reply helpful? Yes No
Dea_Xiaobai 4 on at

Like (0)

Report
Copy link

Link copied!

hi @Anonymous
Have you solve your problem yet? I meet same problem with you now, hope you have fixed it already

Was this reply helpful? Yes No