Hi Everyone,
Using Power Apps, I have created an MS Flow that uses the Post and Get methods to invoke an HTTP request with an Entra ID (preauthorized) and generate an SSRS report. Although everything is working well, I'm currently having trouble passing URLs from the Canvas app to Lunch in a new tab. Verifying MS Flow by clicking on the compose output URL, which opens a new tab containing the report. Our current problem is not storing files on any external platforms, such as OneDrive, SharePoint, etc. We intend to use Power Apps and MS Flow. The primary purpose is to download the SSRS report to the client.
Is there a way to get the URL from the second screenshot into Power Apps via Power Automate?
Are you available for teams call?
@SudeepGhatakNZ , I tried to initialize the variable and set this variable, but still not work. Please see the variable responses.
Workflow.run part:
@Krunal1 ,
Move the expression in a variable and see if renders the url properly.
Provide the output of the variable to the Respond action.
Check the output of the flow run to make sure it is passing the url correctly.
Can you also show me the Workflow.Run part in your PowerApps?
Thank you for your suggestion @SudeepGhatakNZ, but I tried it's not work out. I pass as string in MS flow to Canvas side. Please see the below screenshot. I think Compose URL is dynamically generated is there is way capture this URL and pass to power Apps side.
You should be able to return the Download link as a string using Respond to Power App action.
You can then use the Navigate function to open the url in a new tab.