cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ahmadbutt
Level: Powered On

Is it possible to copy a SharePoint item to a Excel file?

I want to copy this data to a Excel file. If I use export to Excel, I only get the Titel. See picture 2..

forms.PNGforms1.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Is it possible to copy a SharePoint item to a Excel file?

HI @ahmadbutt 

 

I think your view is not saved. The "Alle items*" has a *. Please save it and try again. 

 

All data that you see on the view will be exported to Excel, but since the view is not saved, it will export based on the previous view.

 

Makes sense?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Is it possible to copy a SharePoint item to a Excel file?

Hi @ahmadbutt 

 

When you press "Export to excel" what you're doing is exporting a query that will link directly with the items in SharePoint. The data is still in SharePoint; what you're doing is fetching it on the fly. 

 

By your screenshot, the view only contains the "Titel," that's why the information displayed in Excel only includes that data. To show all the data, you need to build a view with the data you want to export so that excel can fetch it.

 

Don't forget that this information is fetched from SharePoint. If you want to keep data in Excel, save it to keep the data snapshot at the moment.

 

Makes sense?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

ahmadbutt
Level: Powered On

Re: Is it possible to copy a SharePoint item to a Excel file?

@manuelstgomes Uhm I don't understand it.. I see the data but not in Excel if I 'export to excel'... So it is not possible to see the exact same data as shown in the picture below?1e.PNG2e.PNG

Super User
Super User

Re: Is it possible to copy a SharePoint item to a Excel file?

HI @ahmadbutt 

 

I think your view is not saved. The "Alle items*" has a *. Please save it and try again. 

 

All data that you see on the view will be exported to Excel, but since the view is not saved, it will export based on the previous view.

 

Makes sense?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

View solution in original post

ahmadbutt
Level: Powered On

Re: Is it possible to copy a SharePoint item to a Excel file?

@manuelstgomes Thank you for helping me out!😀

Super User
Super User

Re: Is it possible to copy a SharePoint item to a Excel file?

My pleasure @ahmadbutt . Glad we managed to figure out the issue 🙂

 

Cheers

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,133)