cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

How to import excel data to sharepoint?

Please let me know which is the best forum to post this question, I'm sorry for the inconvenience, I don't know a better forum, but I do wish to later use this data on flow.

 

I have been trying to load the data of an excel file through:

In Internet Explorer: site > Settings icon > Add an app > Import Spreadsheet

http://sharepoint.handsontek.net/2018/01/03/fix-most-common-issues-with-sharepoint-import-spreadshee...

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_sharepoint-mso_win10/how-to-create-a-dro...

But unfortunately I get an unexpected error...

 

Here I found a suggestion on what to do:

https://answers.microsoft.com/en-us/msoffice/forum/all/import-from-spreadsheet-app-an-unexpected-err...

So I went ahead and made sure that the website is trusted and tried again, but still the same problem.

 Unexpected Error.png

I have also tried to load this data through excel export, explained here:

https://support.office.com/en-us/article/export-an-excel-table-to-sharepoint-974544f9-94bc-4aa8-9159...

WBS-List.pngWBS-List 2.png

 

Can't connect to server.png

 I got this error saying that: 

"Cannot connect to server at this time. Your list cannot be published"

I found a workaround on this website:

https://support.microsoft.com/en-us/help/838703/you-receive-a-cannot-connect-to-server-at-this-time-...

but this implies that I have to make the site public, but that is a big no no.

 

Are there any other ways to do this?

Any help would be appreatiated.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: How to import excel data to sharepoint?

I just realized that the website I was using was not correct. I was using the link to a specific folder on sharepoint, instead of just using the website link.

I was using

https://xxxxx.sharepoint.com/projects/16091/SiteAssets/Forms

 

instead of

https://xxxxx.sharepoint.com/projects/16091/

 

thanks everyone for the help.

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: How to import excel data to sharepoint?

Hi @Anonymous,

 

If you want to import the data from the Excel table into the SharePoint list, you could use Get rows to get all the rows in the table, then configure Create item action to add the value of the corresponding field to the item.

This is the import operation of data that Flow can implement.

As for your mention of these problems, there is no way for me to rebuild here. It seems that there is no suitable method to solve it through Flow.

And the document I can find is almost the same as yours. I am afraid that I can't provide a suitable workaround to help you.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

Re: How to import excel data to sharepoint?

Hi @v-bacao-msft

Thank you for your suggestion, it might be useful in the future.


@v-bacao-msft wrote:

Hi

If you want to import the data from the Excel table into the SharePoint list, you could use Get rows to get all the rows in the table, then configure Create item action to add the value of the corresponding field to the item.

 


 

I think I may be getting lost from my real objective and I apologize again for this not being the correct forum for this question. I have posted it on:

https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-import-excel-data-to-sharepoint/df0d07...

which is a more suitable forum.

 

Want I want to do is to be able to use the data from an excel file column in the drop down menu of a column on a sharepoint library, so that when the user is requested to fill this field, he has to choose from the options on the drop down menu.

This seemed to answer my question... https://answers.microsoft.com/en-us/msoffice/forum/msoffice_sharepoint-mso_win10/how-to-create-a-dro...

however, I still can't load the excel.

Later on i'll be applying some flows to the documents, but these will not change the WBS value.

WBS.png

 

WBS drop down.png

 

 

Highlighted
Anonymous
Not applicable

Re: How to import excel data to sharepoint?

I just realized that the website I was using was not correct. I was using the link to a specific folder on sharepoint, instead of just using the website link.

I was using

https://xxxxx.sharepoint.com/projects/16091/SiteAssets/Forms

 

instead of

https://xxxxx.sharepoint.com/projects/16091/

 

thanks everyone for the help.

View solution in original post

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Users online (6,541)