Hello,
I’m creating a test that uses a flow to send data entered by a Power Apps user to an Excel file in my OneDrive account. I know that using Excel as a data source is not generally recommended, but in this case it is required. The challenge is that users of the app cannot have access to the Excel file. The current set up for the test is:
1. User enters text in a text box in Power Apps on a data entry screen.
2. A submit button uses a formula for the OnSelect property that activates the flow, e.g. testflow.Run(textbox.SelectedText.Value)
3. The flow is triggered using the ‘When Power Apps calls a flow (V2) trigger’. The trigger contains a text input for the textbox entry.
4. The next step in the flow is ‘Add a row into a table’ (Excel). This step connects to the Excel file in OneDrive and maps the text value to the Excel table.
This process works exactly as expected when I test it; however when I ask a colleague to test, the flow run fails and produces the following error message:
The resource could not be found.clientRequestId: f0ee7fab-e208-4c70-ace1-36686ade0e67serviceRequestId: 6e4d6277-3b5a-4bdb-9e86-5d35a39ce8d1
Thanks very much for any assistance to fixing this error!