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

"x-ms-apim-tokens" header was not found

Good morning,

 

I recently had an issue with a flow that I made and that has been running for over a week now with no issues.

 

The problem seems to be related to the Google Sheet Insert Line function and the error message  I get is the following:

"O cabeçalho "x-ms-apim-tokens" não foi encontrado." which translates to "The "x-ms-apim-tokens" header was not found."

 

Because of this issue I no longer can use the Google Sheet Inser Line functionality and the Flow that has been running no longer works for this step.

 

I assum this issue has to do with the token that is needed for Flow to access the google sheet but I've tryed clearing and reseting Flow's permissions to the google account that has the file and nothing seems to work.

 

 

 

Flow apim-token.png

 

 

Also the reason why I'm using google sheet instead of online Excel sheet is because Excel online seems to block Flow's access to the file when someone else is editing the shared file whereas Google sheet allows.

 

 

What can I do to fix or work around these issues?

 

Thank you for your time,

Best regards

Daniel Nunes

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: "x-ms-apim-tokens" header was not found

Hi @Anonymous,

 

I tested it from my side and the Insert Row (GoogleSheet) works from my side.

Have you tried to delete and then add it again for the Google Sheet Insert Row action?

Add it again should make it work.

Meanwhile, please also check the following blog:

Rebinding Deleted or Broken Connections in an Existing Flow

If issue insists, please post back.

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: "x-ms-apim-tokens" header was not found

Hi @Anonymous,

 

I tested it from my side and the Insert Row (GoogleSheet) works from my side.

Have you tried to delete and then add it again for the Google Sheet Insert Row action?

Add it again should make it work.

Meanwhile, please also check the following blog:

Rebinding Deleted or Broken Connections in an Existing Flow

If issue insists, please post back.

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Anonymous
Not applicable

Re: "x-ms-apim-tokens" header was not found

Hello,

 

I tryed deleting and adding back again several times with no apparent effect.

Hours latter it started working again "by it self".

Either the deleting and adding again fixed it but only took a while to settle or the issue that was preventing it was fixed or somehow passed.

 

It would be interesting to know more about this to know if it's something that can be avoided.

But for now I gess I'll settle with the problem being fixed.

 

Thank you for your time

Best regards,

Daniel Nunes

DavePotts_BritE
Level: Powered On

Re: "x-ms-apim-tokens" header was not found

I've just hit the same problem with X-MS-APIM-Tokens. I was calling "Get my profile (V2)". Any information available on how to stop this happening in the future?

DavePotts_BritE
Level: Powered On

Re: "x-ms-apim-tokens" header was not found

I've just come across https://support.microsoft.com/en-us/help/4477072/best-practices-updating-a-flow-used-by-a-powerapp including this quote:

 

 

Once a PowerApp is published it is always recommended to make copies of Flows used by the PowerApps to make any updates.  Any update to a Flow referenced by a live PowerApp has the potential to break existing users.  Do not delete or turn off the existing Flows until all users have been upgraded to the new published version of the PowerApp.  

Ouch!

 

Here's how I fixed my problem:

  1. Took "My Flow" and used save as to create "My Flow v0.2"
  2. Edited the canvas app
  3. In the app updated the flow connection to the v0.2 version
  4. Saved the new app version
  5. Published the app version
  6. Turned on the v0.2 flow

 

 

 

Helpful resources

Announcements
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 Kudoed Authors (Last 30 Days)
Users online (4,739)