Above is the issue that I faced when trying to Export to Excel from Sharepoint List.
I tried to "Repair Office" but nothing happened.
I read an similar questions and the answers is to Repair Office. Did not work for me.
SharePoint OpenDocuments Class is not shown in the Internet Options -> Programs -> Manage Add-Ons
Are you trying to work with PowerApps? I believe what you see is an Microsoft office issue, and needs to be looked up in the Microsoft office support portal - https://support.office.com/
Please let me know if this is a powerapps issue and I would be happy to help you.
You can use flow to do this.
There's a preexisting template you can use which once a week exports the content of a sharepoint list into an Excel .csv https://emea.flow.microsoft.com/en-us/galleries/public/templates/79095f001ee911e79dc3835964ea3218/co...
If you want it to run on demand rather than weekly, change the trigger from recurrence to a button.
Is it a fresh version of the CSV you are trying to import? If its the same one that you originally tried to open it maybe saved with the incorrect coding. Try creating the CSV again from fresh and then importing from text. If that doesn't work then sorry, I'm out of idea but hopefully, someone else can help. Good luck.
@JohnFairhall Thanks for your help,
ACtually It was my mistake. I click and downloaded the file from Excel online into xlsx format
I did it successfully,
The question now though is how to allow export data only input by the current user of the PowerApps.
Based on what I know, there is no option available in PowerApps to allow exporting data into Excel, or into SharePoint list.
You could take use of user() function to filter out the table loaded in PowerApps.
If here you would like to export filtered items from SharePoint list to Excel, then you may take a try with the Export to Excel feature in SharePoint, which allows to export the filtered View from SharePoint list:
Export to Excel from SharePoint (Edited, it seems you have issue using this feature)
Or you may take a try with some powershell scripts.
Adding a thread for reference:
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications