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


Report
All responses (
Answers (