i have a flow that opens an excel file on Onedrive and adds a couple of rows to the table. Works under my account. others cannot. they have same setup as me. We can see the file on their onedrive folder and the desktop link. they can edit the file on the desktop and save it. but when the flow runs it gets the Bad Gateway error. Ideas? i have also logged onto this machine and ran it and it works fine.
Am is missing a permission somewhere in the flow.
Forgot to mention, i know the OneDrive account is working because i have another flow that writes out a CSV file to the same folder and it works just fine. Excel is the issue here. it appears not to either find the file or the table from other users. why is that?
The issue is it was trying to edit my excel file on my one drive and not there one drive. i do not want to create a separate flow for every export Flow per project per user. how do you get around the dynamic file issue? is sharepoint the same way?
In my case, the flows, the Forms, and Excel online file are all sitting in the same account. And the same setup works for other tables in the same file where data from other forms are being populated, it just fails for two specific Forms.