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

[Anonymous]

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.

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

[v-micsh-msft · Accepted solution]

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

[Anonymous]

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]

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]

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