Forum Discussion
nfeng11
Jan 11, 2023Copper Contributor
"referenceerror: promise is not defined" when trying to refresh a Sharepoint List connection
We have an Excel report that pulls Sharepoint List data on refresh. It works fine for people except one user - he gets the following little window popup when he tries to refresh.
If I click TECHNICAL DETAILS, it says "referenceerror: promise is not defined".
If I click GO BACK TO SITE, it tells me that internet explorer 11 is not supported and gives me an option to update browser, which leads to installation of Edge, but Edge and Chrome are already installed.
The troubleshoot link does not work, brings up another popup saying "help seems to be broken".
The connection to the Sharepoint List is created by going to the list and click Export to Excel, which downloads a query file, and I load the query into the Excel file.
My research says that the error is related to IE not supporting Promise, but I haven't seen anyone mention seeing this in Excel. In an attempt to replicate the issue, I set default browser on my PC to IE and refreshed the report, it did not give me the error.
Do you guys have any ideas? I can think of a work around, but I want to try to resolve this first, in case it happens again in the future.
- peiyezhuBronze ContributorI set default browser on my PC to IE and refreshed the report, it did not give me the error.?
Do you mean other PC works but only your system reports "referenceerror: promise is not defined" ?- nfeng11Copper ContributorNot mine, it happens on another user's PC. We have many reports that pull Sharepoint List data this way, and I have never seen it error out like this.
I was suspecting that it was caused by IE being the default browser, so I set default browser to IE on my system and see if the error happens on mine, which did not.- peiyezhuBronze Contributorset default browser to IE on my system and see if the error happens on mine, which did not.???
i can not test on myside.
if u have found IE can not support promise,one way is to change to Chrome or Firefox on client side.
alternatively,
//import this js on server side or apply below javascript as browser plugin
<script src="https://cdn.polyfill.io/v2/polyfill.min.js"> </script>
or
<script type="text/javascript" src="https://cdn.polyfill.io/v2/polyfill.min.js?features=es6"></script>
refer to:
https://www.cnblogs.com/marvelousone/p/11190726.html