Unanswered

Prepopulate form field using input parameters

(0) Share

Report

Posted on by tarjeieo

Hi, I've search this forum and googled this quite a lot, but I cannot find a good answer to this.

I have a list and a PowerApps form for that list, let's call it "Location targets". Users will primarily use SharePoint/browser.

One of the fields in the form is "Location". I have another page where the user can select a value from the same dataset "Location". After the user selects a location, I will use that value to send the user to the NewForm for the list, and pre-populate the "Location" field with the "Location" value previously selected by the user. I'm doing this because I'm going to reuse the "Location" value also outside of the PowerApp form.

I've investigated sending parameters to the form, but it seems like this is not possible using SP forms? Custom forms - Get parameters from url.

I've also looked into if we can use localstorage/sessionstorage to set and get values, but can't find any good info on this either.

Any ideas?

Currently experimenting if we can open https://web.powerapps.com/webplayer/app?appId=/providers/Microsoft.PowerApps/apps/MYAPPID&URLPARAM=Hello in a modal dialog. Migt be good enough.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

R3dKap 1,594 on at

Like (0)

Report

Hi @tarjeieo,
Indeed it is not supported at this time.
Here is the idea if you wish to vote for it... 🙂
https://powerusers.microsoft.com/t5/PowerApps-Ideas/SharePoint-Custom-Form-quot-Param-quot-does-not-work/idi-p/126162
Emmanuel
PS: If you absolutely need to implement this, I don't see any other solution than storing the location entered by the user on the page into a SharePoint list (with 2 fields: user, location value) and in you customized form retreive the value to place it as a default value in your location field.
PS2: or you could also create a new item in the list when saving the location on the page (setting the field location with the value entered on the page) and then call the EditForm.aspx page specifying the newly created item id.

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report
Hi @tarjeieo ,

Could you please share a bit more about your scenario?

Could you please share more details about the another page that you mentioned? Is it within another different SP list?

If you want to pass parameters from a custom form in a SP list to another custom form in a different SP list, I afraid that there is no way to achieve your needs in PowerApps currently.

Note: The URL structure is different between the standalone canvas App and the SharePoint custom form

Currently, the Param() function is only available within canvas app, you could not reveice the parameters from the URL of a custom form using Param() function.

If you would like this feature to be added in PowerApps, please vote the following link:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/SharePoint-Custom-Form-quot-Param-quot-does-not-work/idi-p/126162

If the another page that you mentioned is in same SP list, I think it is not necessary to receive the parameters from the URL of a custom form. I think the Navigate() function could achieve your needs. Please take a try with the following formula:

Set the OnChange property of the Location Combo Box to following:

Navigate(TargetScreen, ScreenTransition.None, {ParamName: Value})

then you could reference the ParamName value within your target screen.

Best regards,

Was this reply helpful? Yes No
Verified answer

tarjeieo 9 on at

Like (1)

Report

We ended up sending params to the PowerApp, and hiding the "PowerApp in SharePoint-mode" with CSS. New items are therefore only added using our custom generated link to the PowerApp that accepts input parameters.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @tarjeieo, was the form you were using made with SharePoint Forms? I'm not sure if this is similar to what I'm trying to do and am very interested in what you've done. I have a customer satisfaction survey on Microsoft Forms and would like an event item on that to be prepopulated from another list we keep. Does this sound analogous to what you're doing?

Was this reply helpful? Yes No