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
Solved! Go to 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
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
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
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?
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:
Hi All,
Until now this still ocorruing ๐
The solution is "Save as" and delete the previous flow.
@v-micsh-msft do you have a official resolution from staff to this? it's so boring ๐
Best Regards,
Gustavo Moraes
Gustavo Moraes, o astronauta brasileiro do Flow!
Join digitally, March 2โ4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
2 |