Skip to main content
Community site session details

Community site session details

Session Id : LH+Z3hmk4oVh52U0vW9Dry
Power Apps - Building Power Apps
Answered

Prepopulate form field using input parameters

Like (0) ShareShare
ReportReport
Posted on 20 Feb 2019 09:46:59 by 9

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.

  • Community Power Platform Member Profile Picture
    on 06 Jul 2023 at 23:31:56
    Re: Prepopulate form field using input parameters

    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?

  • Verified answer
    tarjeieo Profile Picture
    9 on 05 Mar 2019 at 07:24:29
    Re: Prepopulate form field using input parameters

    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.

  • v-xida-msft Profile Picture
    on 21 Feb 2019 at 03:13:40
    Re: Prepopulate form field using input parameters

    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.

    NoteThe 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,

  • R3dKap Profile Picture
    1,594 on 20 Feb 2019 at 10:00:36
    Re: Prepopulate form field using input parameters

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473