In a nutshell, how would our team build a simple app that will work this way:
A user clicks on a hyperlink in a web page (phone, tablet or desktop Windows, Android or IOS.)
Clicking the hyperlink returns data from data source to the user via email or popup in a browser. The “WHERE” clause in the query is in the hyperlink.
Prefer not to require our many users to install an app.
Do you want to launch a webpage or an app by clicking a Hyperlink?
If yes, may I suggest you use Launch function in your app? Please refer to this documentation for more details about Launch function:
And I have seen a thread about Launch function, hope it can also be a reference for you:
I don't think i described it very well. This hyperlink would not be in an PowerApp app. It would simply be a hyper link on an ordinary web page.
the requirement is this: The system will return a query result to the user when she clicks the hyperlink. The query will filter the result from the database based on a parameter in the query. The only action required of the user is to click the hyperlink. The return value could come in an email or a web page with the query results in the web page.
PowerApp and the Common Data Service are appealing because they are simple and available.
We are also looking at Access or possibly Azure SQL.
We're just looing for the best tool at this point.
Thanks for your clarification. When your user clicks the Hyperlink on a Web page, you want the system return a query request to the user.
But I guess that it is not possible to do this currently. Please consider this as a new addition and create a request on the PowerApps Ideas Forum, hope PGs will take it into consideration in the future releases.
The link of PowerApps Ideas Forum is:
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand