Integrate<\/code> then PowerApps<\/code> and Customize forms<\/code>:
\n![\"\"](\"https:\/\/blog.kodono.info\/wordpress\/wp-content\/uploads\/2022\/11\/integrate.png\")
<\/a><\/p>\nOnce PowerApps has open the form, you need to do several things.<\/p>\n
1. Load the ID<\/h2>\n
We first need to make sure the form will load the required item when we pass the ID<\/code> URL parameter:
\n![\"\"](\"https:\/\/blog.kodono.info\/wordpress\/wp-content\/uploads\/2022\/11\/form_mode_item-1024x442.png\")
<\/a><\/p>\nFrom the SharepointForm Advanced Settings<\/b>, we change the DefaultMode<\/b> to check if we have the ID<\/code> parameter, and if we don’t have it, then it should be a New Form, otherwise an Edit Form:<\/p>\nIf(IsBlank(Param(\"ID\")), FormMode.New, FormMode.Edit)<\/pre>\nFrom the SharepointForm Advanced Settings<\/b>, we change the Item<\/b> section to check if we have the ID<\/code> parameter, and if we have it, then we do a lookup in our list to find the data:<\/p>\nIf(IsBlank(Param(\"ID\")), SharePointIntegration.Selected, LookUp('NAME OF THE LIST',\u00a0ID = Value(Param(\"ID\"))))<\/pre>\nAdd a SUBMIT button<\/h2>\n
With PowerApps, there is no button to save the changes! We’ll add a button in the form:
\n![\"\"](\"https:\/\/blog.kodono.info\/wordpress\/wp-content\/uploads\/2022\/11\/save_btn-1024x274.png\")
<\/a><\/p>\nIn the button’s properties, we change the onSelect<\/b> to be:<\/p>\nSubmitForm(SharePointForm1)<\/pre>\nBe aware that the page will stay with the form after clicking on the button. You could want to close using the Exit()<\/a> function, but the user will be redirected on office.com \u2026 I’d recommend to use Launch()<\/a> by redirecting your users to a page:<\/p>\nSubmitForm(SharePointForm1); Launch(\"https:\/\/tenant.sharepoint.com\/sites\/MySite\/\");<\/pre>\nSet field’s value based on URL parameter<\/h2>\n
We can finally set the field’s value based on the parameter in the URL. Select the INPUT zone of the field, and in the Default<\/b> section we use the below formula:<\/p>\nIf(IsBlank(Param(\"Title\")), ThisItem.Title, Param(\"Title\"))<\/pre>\n![\"\"](\"https:\/\/blog.kodono.info\/wordpress\/wp-content\/uploads\/2022\/11\/title_value-1024x281.png\")
<\/a><\/p>\nHere my field is called “Title” so I decided to use a parameter called “Title” as well.<\/p>\n
Link to the form<\/h2>\n
We cannot use the NewForm.aspx<\/b> or EditForm.aspx<\/b> to access this form, but we need a special link.<\/p>\n
Go to your list settings<\/b>:
\n![\"\"](\"https:\/\/blog.kodono.info\/wordpress\/wp-content\/uploads\/2022\/11\/list_settings.png\")
<\/a><\/p>\nThen go to the form settings<\/b> (it’s from there that you can decide to keep PowerApps or use the original Sharepoint Forms), and click on See versions and usage<\/b>:
\n![\"\"](\"https:\/\/blog.kodono.info\/wordpress\/wp-content\/uploads\/2022\/11\/form_settings.png\")
<\/a><\/p>\nYou’ll get the App Id<\/b> from this page:
\n![\"\"](\"https:\/\/blog.kodono.info\/wordpress\/wp-content\/uploads\/2022\/11\/app_id.png\")
<\/a><\/p>\nNext, you’ll use the App Id<\/b> to forge the URL: https:\/\/apps.powerapps.com\/play\/providers\/Microsoft.PowerApps\/apps\/APP_ID<\/b>
\nWith our example, the URL will be: https:\/\/apps.powerapps.com\/play\/providers\/Microsoft.PowerApps\/apps\/c6f23ac1-dcbd-4daf-925e-2701ab241ca0<\/a><\/p>\nYou can now pass the URL parameter: https:\/\/apps.powerapps.com\/play\/providers\/Microsoft.PowerApps\/apps\/APP_ID?Title=Hello%20World<\/b>
\nAnd an ID to retrieve an existing item: https:\/\/apps.powerapps.com\/play\/providers\/Microsoft.PowerApps\/apps\/APP_ID?Title=Hello%20World&ID=2<\/b><\/p>\nHow to use it with a LookUp column?<\/h2>\n
If you want to auto-select a LookUp field using an URL parameter, you need to do a few things\u2026<\/p>\n
First, we need to add the related table. To do so, click on Data<\/b> in the left navigation bar and search for SharePoint<\/b>:
\n![\"\"](\"https:\/\/blog.kodono.info\/wordpress\/wp-content\/uploads\/2022\/11\/datasource_sharepoint.png\")
<\/a><\/p>\nSearch for the table and add it.<\/p>\n
Second (optional) step: click on the Lookup field in the form and change the Items<\/b> to show a list of options \u2013 if no “Lookup” ID in the URL, then we use the default list of options:
\n![\"\"](\"https:\/\/blog.kodono.info\/wordpress\/wp-content\/uploads\/2022\/11\/items_options-1024x218.png\")
<\/a><\/p>\nThe below formula permits to retrieve the “ID” and “Title” from the distant list, base on the “Lookup” parameter, and to rename the result as {Id:\"ID\", Value:\"Title\"}<\/code>:<\/p>\nIf(IsBlank(Param(\"Lookup\")), Choices([@'CURRENT LIST NAME'].COLUMN_NAME), RenameColumns(ShowColumns(Filter('DISTANT LIST NAME', ID = Value(Param(\"Lookup\"))), \"ID\", \"Title\"), \"ID\", \"Id\", \"Title\", \"Value\"))<\/pre>\nThird, click on the Lookup field in the form and change the DefaultSelectedItems<\/b> to select the item from the list of options:
\n![\"\"](\"https:\/\/blog.kodono.info\/wordpress\/wp-content\/uploads\/2022\/11\/default_selected_items-1024x204.png\")
<\/a><\/p>\nThe below formula returns an empty selection with {Id:\"\", Value:\"\"}<\/code> when no URL param, otherwise it returns the first record for our lookup:<\/p>\nIf(IsBlank(Param(\"Lookup\")), {Id:\"\", Value:\"\"}, First(RenameColumns(ShowColumns(Filter('DISTANT LIST NAME', ID = Value(Param(\"Lookup\"))), \"ID\", \"Title\"), \"ID\", \"Id\", \"Title\", \"Value\")))<\/pre>\nAnd finally, we can pass Lookup=ID<\/b> in the URL to select the related item in the other list<\/p>\nHow to deal with new fields?<\/h2>\n
If you add a new field to your list’s settings, you’ll have to edit the form in PowerApps, and then edit the fields and add the new one:
\n![\"\"](\"https:\/\/blog.kodono.info\/wordpress\/wp-content\/uploads\/2022\/11\/add_field-1024x239.png\")
<\/a><\/p>\n