Pass in paramater via URL, data not loading

[kvmo]

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

[v-xida-msft]

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

[kvmo]

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

[v-xida-msft · Accepted solution]

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

[kvmo]

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