cancel
Showing results for 
Search instead for 
Did you mean: 

SharePoint Custom Form - "Param" does not work

The "Param" function DOES NOT WORK on SharePoint custom forms inside of SharePoint itself (which is where they are designed to run!!!!).

 

I created a form, with a custom Data Card with two label controls - one with a Text property set to "ParamValue:", and the other with the "Text" property set to:

Param("Param")

 

Published the form, browsed to my list, and then put a "Param" query string parameter in the URL, like this:

 

https://<tennant>.sharepoint.com/<site>/Lists/<MyList>/AllItems.aspx?Param=Hello

The customized form simply does not retrieve the param value:

 

Param1.PNG

 

Looking at the browser source when I browse to the SharePoint list, I can see that the form is embedded in an iframe.  So I mashed up a URL based in the information I found in browser source, and browsed to the customized form using a similar URL:

 

https://web.powerapps.com/webplayer/app?appId=/providers/Microsoft.PowerApps/apps/<AppIdGoesHer>&Param=Hello

The parameter value was picked up fine:

 

Param2.PNG 

 

This means that if we want to pass information to a PowerApps form from another part of SharePoint (e.g. from a page added to SharePoint or a custom Document Set page), we either have to:

  • Browse to the form using the "web.powerapps.com", by looking at the source of the SharePoint list page to get the App ID.  This will be confusing for the user.
  • Use JavaScript in a ScriptEditor web part to pop up the form in a SharePoint modal dialog using SharePoint's built in javascript, again using the iframe URL.   This works OK, however there's not way to close the dialog from inside PowerApps.  The only thing you can do is create a custom "Submit" button, and then browse to another screen informing the user that their item has been submitted, so that can click the "X" button on the dialog.  Again, not ideal.

Having the "Param" function not work in a SharePoint custom form seems to be a big gaping hole.  Can this be fixed please?

Status: New
Comments
Kudo Collector

Please also see: https://powerusers.microsoft.com/t5/PowerApps-Ideas/SharePoint-quot-New-Item-quot-customized-form-we... - Need the ability to be able to have parameters work inside of SharePoint, whether that be in the PowerApps web part, or as a form that "slides out" anywhere in SharePoint (i.e. not just against a list where the form has been customized!!!)

New Member

Making the "Custom Form" a Cavas App seems like such over kill. 

Frequent Visitor

Same here - any solution as yet?

New Member

Same issue here

Frequent Visitor

I just discovered this is an issue after planning to use this approach for a solution for a client. Are there any updates to this issue? Anyone have a "trivial" workaround. I feel like this is a major oversight on very common functionality.

New Member

Has anyone figured this one out? 

I'm trying to do the exact same thing,  I need to pass a parameter from a URL to my newform

Frequent Visitor

@chrisfromwa I ended up creating a canvas app instead of sharepoint custom form. Works fine in canvas.

Frequent Visitor

This is because the custom forms in SharePoint embed the PowerApp inside of an iframe. The iframe is unable to parse the URL from the hosting page. Instead of relying on a custom canvas app, I stayed with the EditForm, but used Power Automate (Flow) to look up values that i needed from other SharePoint lists. This approach creates a very heavy dependency on Flow and you are limited to what connectors you can use depending on your license. So far it has gotten me what I need, your mileage may vary.

Helper I

@test12311 , can you please give more details on how flow can solve this? My requirement is to retrieve the ID passed to the sharepoint List custom form. Param("ID") does not retrieve it.

 

https://<tenant>.sharepoint.com/Business%20Development/Lists/Registered%20Programs%20List/newform.as...

Frequent Visitor

Hi @SwapnaNethi,

 

If you are able to use a blank canvas app then your solution should work. However if you are using the SharePointIntegration this approach will not work. When using SharePointIntegration I created LookUp columns in my source and destination lists so that they are related to each other. I populate the destination list item using a PowerApps triggered Flow from my PowerApp button, and use the "Create Item" action to populate the properties of the destination item. My requirements were very unique so I don't know if this will work 100% of the time.

 

Thanks,

@test12311