Unanswered

Pass parameters from URL to datasource when app form submitted

(0) Share

Report

Posted on by Shaebert

107

Hello, I have a Power App form that requests certain information. However, I want to combine this with other data I already have from a customer. To do this, I was looking to create a URL with a parameter that could be passed to the data when a form is submitted.

This parameter would be an ID type field. I would want this field hidden/not visible to those when submitting the form. When they submit the form, I want the ID to be passed into a SharePoint list column.

I am just a beginner with powerapps, so any help would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

SebS 4,822 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Shaebert

Let's say you have a URL

https://apps.powerapps.com/play/e/YOUR-APP-ENVIRONMENT-ID/a/YOUR-APP-ID

You can pass the parameter like this:

https://apps.powerapps.com/play/e/YOUR-APP-ENVIRONMENT-ID/a/YOUR-APP-ID?costumerID=15

The user will click the URL to open your app with Form

Two things need to happen.

1. You need to capture the costumerID

2. you need to direct the user Automatically to the Form Screen if it's not the home Screen 🙂

Now, to do the first operation, simple in the App.OnStart, you need to capture this ID

Set(costumerID,Param("costumerID"))

Param is a function that can retrieve specific data from a URL in simple terms.

now, to direct the user to a specific Screen, you need to use the App.StartScreen property.

in this property, you only point the user to a specific screen based on condition, so in your example, it will look like this:

If(!IsBlank(costumerID), FormScreen)

FormScreen should be the name of the screen on which the form is displayed.

Now to pass costumerID to SharePoint using the form. If you have already a column in SharePoint, what will store it:

in the default property of DataCardValue of field, what should Store costumerID use the global variable costumerID

and make the visibility of the whole Data Card false so that user will not see the field.

Now each time the form is filed by a user who accesses it from the URL will contain the costumerID

this method is called Deep linking.

hope it helps

Was this reply helpful? Yes No
Sunil Kumar Pashikanti 2,097 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Shaebert ,

Let's achieve your goal step by step:

Create a URL with Parameters:

You can create a URL with parameters that include an ID field.

The URL will be used to open your Power App form and pass the ID as a parameter.

The format of the URL will be: https://apps.powerapps.com/play/providers/Microsoft.PowerApps/apps/<APP_ID>?<PARAMETER>=<VALUE>

Replace <APP_ID> with your actual Power App ID.

Replace <PARAMETER> with the name of your parameter (e.g., recordId).

Replace <VALUE> with the actual ID value you want to pass.

Hide the ID Field in the Form:

In your Power App form, add a hidden input field (e.g., a TextInput control).

Set the default value of this field with the ID that is passed from the parameter in the URL.

Make sure to set the Visible property of this fi eld to false so that users won't see it.

Retrieve Parameter Value from the Web URL:

To extract the value of the recordId parameter, you can use the Param("recordId") function.

This function retrieves the value of the specified parameter from the URL.

TextInput.Text = Param("recordId")

Submit the Form and Pass the ID to SharePoint:

When users submit the form, use the Launch function to open the URL with the parameter.

Use the hidden input field value (the ID) as the parameter value.

In your SharePoint list, create a column to store this ID value.

In the Power App, use the Patch function to create a new item in the SharePoint list, including the ID value.

Example Code:

Here's an example of how you can use the Launch function to open the URL with the ID parameter:

Launch("https://apps.powerapps.com/play/providers/Microsoft.PowerApps/apps/<APP_ID>?recordId=" & HiddenIDField.Text, New)

Replace <APP_ID> with your actual Power App ID.

Replace HiddenIDField with the name of your hidden input field.

Remember to adjust the control names, column names, and other details according to your app and SharePoint list. You're on the right track, and I hope this helps you achieve your goal!

For more details, you can explore the official Microsoft Learn tutorial on passing parameters to Power Apps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

@SunilPashikanti

Was this reply helpful? Yes No