I have my data stored in Excel Sharepoint and I am connecting it to Power Apps with Excel Online (Business) Connector. I want to implement Application Lifecycle Management (ALM) using solution. The scenario is when the environment is dev I want to connect Canvas Apps to Excel in Sharepoint A, and when the environment is production I want to connect Canvas Apps to Excel in Sharepoint B. I try this using environment variable or connection reference but not yet find the solution.
What is the solution for this scenario or it is not possible to do this scenario with Excel Online (Business) Connector.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.