
Hey to all,
I'm facing a problem with my App / Flow combination which I think is related to the connectors in my Power App.
Let my explain where I'm at: In my app, I have an attachment control which I'm using to upload an excel file to a sharepoint library. I build it using this great tutorial here by Shane Young: https://www.youtube.com/watch?v=3QaiM8SeWfM
Everything shown in the video works just fine, meaning my file upload to sharepoint is working.
Now i want to expand the logic a bit and this is where I run into my problem:
The file that is going to be uploaded will always be the same excel template, just with different entries in a table. I want my Flow to not only upload the excel file to sharpoint, but also read the contents of th table in the Excel file. This is why I added an 'list rows present in table' activity in my flow right after the file is uploaded.
But as soon as I added the new activity to my flow, the whole flow was not working anymore. I didn't even trigger anymore. In PowerApps I'm getting the following error message:
InvokerConnectionOverwriteFailed -
Could not find any valid connection for connection reference name 'sharedexcelonlinebusiness' in APIM tokens header
As far as I understand, there is a problem while establishing the Apps connection to Excel (Business). The app itsself does not yet have a connection to ExcelOnline yet btw. But I will not be able to set up a static connection to a file anyway, since the file I wanna connect to is uploaded just before hand.
Any Ideas on how to solve the problem are appreciated! Is what I'm trying to archive even possible?
Kind regards
Felix