cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kvmo
Level: Powered On

Pass in paramater via URL, data not loading

Hi,

 

I'm working with PowerApps (new enough to it) and I'm working with passing in parameters through the URL

e.g.

https://web.powerapps.com/apps/[APP GUID]?ID=123

ref: http://itgroove.net/mmman/2017/10/17/how-to-pass-parameters-into-a-powerapp-2/

 

I have created an app that loads customers from a on-premise database table (which maybe has @100K rows)

When I pass in the Id as the parameter in the url, the app loads but doesn't load the required customer.
It sits in a state, with 'Getting your data ..." on the screen, and no errors are reported.

When I create a smaller dummy table, with 100 rows approx., and pass in the Id, the app opens and displays the correct customer.

 

Is there an performance issue with PowerApps when it has to search a large table?
Is there a way to debug this and see what's going on? Or is there a better way to do this?

 

Thanks for your help

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Pass in paramater via URL, data not loading

Hi @kvmo,

 

For your first question, if you want to launch an app in a Gallery control via a URL with parameters included, I think the Launch function could achieve your needs. 

 

You should type the following formula within the OnSelect property of a control within your Gallery control:

Launch("https://web.powerapps.com/apps/aa10a046-23er-42d1-9xxx-183e811aaca8","Phone_x0020_No_","123456789")

More details about the Launch function in PowerApps, please check the following article:

Launch function

 

For your second question, it is possible to have two DetailForms on a same screen. You should connect each DetailForm to a difference data source.

 

Then if you want to pass two parameters in the URL from a Gallery control, please type the following formula within the OnSelect property of a control within your Gallery control:

Launch("https://web.powerapps.com/apps/aa10a046-23er-42d1-9xxx-183e811aaca8","param1","abc","param2","abc")

 

Set the Item property of the first DetailForm control to following formula:

LookUp(datasource1,columnName=Param("param1"))

Set the Item property of the second DetailForm control to following formula:

LookUp(datasource2,columnName=Param("param2"))

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Pass in paramater via URL, data not loading

Hi @kvmo,

 

Could you please share a screenshot of your app's configuration?

How do you display your customers records within your app? Could you please share more details about the formula?

 

Please check if you have used Param() function to receive the ID parameter from the URL that you provided within your app. 

 

If you want to use the parameter passed from a URL within your app, you must use the Param() function to receive the passed parameter. 

 

More details about setting URL parameters for an app, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/embed-apps-dev#set-uri-parameters-for-y...

 

More details about the Param function in PowerApps, please check the following article:

Param function

 

In addition, please check and see if the following blog would help in your scenario:

https://sachinbansal.blog/2018/06/17/powerapps-canvas-app-how-to-pass-parameter-in-app-url-display-d...

 

 

Best regards,

Kris

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kvmo
Level: Powered On

Re: Pass in paramater via URL, data not loading

Hi Kris,

 

Thanks for your reply.

I display the data in a DetailsForm.  Can a power app be launched in Gallery control by passing in a parameter via url?
I found what I was doing wrong. I was searching on a field with a space in the column name (Phone No_)
I needed to insert "_x0020_", instead of the space  (Phone_x0020_No_)
Url: https://web.powerapps.com/apps/aa10a046-23er-42d1-9xxx-183e811aaca8?Phone_x0020_No_=123456789

Is it possible to have 2 DetailForms on a screen. Each connected to a different datasource
Then pass in 2 paramaters in the Url

i.e. https://web.powerapps.com/apps/aa10a046-23er-42d1-9xxx-183e811aaca8?param1=abc&param2=abc

Then have the first DetailsForm Item lookup its datasource on param1 and the second DetailsForm lookup its datasource on param2?

then display the data side by side

thanks for your help

Highlighted
Community Support Team
Community Support Team

Re: Pass in paramater via URL, data not loading

Hi @kvmo,

 

For your first question, if you want to launch an app in a Gallery control via a URL with parameters included, I think the Launch function could achieve your needs. 

 

You should type the following formula within the OnSelect property of a control within your Gallery control:

Launch("https://web.powerapps.com/apps/aa10a046-23er-42d1-9xxx-183e811aaca8","Phone_x0020_No_","123456789")

More details about the Launch function in PowerApps, please check the following article:

Launch function

 

For your second question, it is possible to have two DetailForms on a same screen. You should connect each DetailForm to a difference data source.

 

Then if you want to pass two parameters in the URL from a Gallery control, please type the following formula within the OnSelect property of a control within your Gallery control:

Launch("https://web.powerapps.com/apps/aa10a046-23er-42d1-9xxx-183e811aaca8","param1","abc","param2","abc")

 

Set the Item property of the first DetailForm control to following formula:

LookUp(datasource1,columnName=Param("param1"))

Set the Item property of the second DetailForm control to following formula:

LookUp(datasource2,columnName=Param("param2"))

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

kvmo
Level: Powered On

Re: Pass in paramater via URL, data not loading

Thanks Kris for your reply

Another question about passing in paramaters

If I need to pass in parameters from outside into a PowerApp with a space (in the parameter)
e.g. https://web.powerapps.com/apps/[APP GUID]?Name=Tom Smith

How do you pas in the parameter 'Tom Smith'?

Thanks for your help

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,639)