Cannot connect to SharePoint document library

[AIUYM19]

I'm building a flow that needs to collect data from an Excel file stored on SharePoint. When I add the "Get a row" action to my flow and put in the SharePoint site's URL, I receive the following error in the Document Library field...

"Could not retrieve values. The dynamic invocation request failed with error: InvalidAuthenticationToken."

I checked the connection on that step, and it's using my credentials. When I use a browser window, I can view the document library just fine using the same credentials. What's stopping the flow from connecting?

[Gopala_Krishna]

@AIUYM19 

Can you please try creating a new connection and check once if that helps in resolution of the issue.

Also can you please try using the List Rows Present in a table (Excel Business) action and check if you are able to successfully fetch the details from the file, if you get the same error then there is issue with connection and as suggested you can create a new connection for the same connector.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

if the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved

[AIUYM19 · Accepted solution]

I tried again this morning, and it let me see the file list. This issue seems to have solved itself. I didn't do anything differently than I did yesterday, and now it will connect to the SharePoint site.

I'll just stop there before I go into another anti-Microsoft rant...