Denis Molodtsov Zerg00s

Auto-generated request IDs with a success screen

Adding a Submit button, a generated X-00000 request ID, and an in-place success panel to a customized SharePoint list form. New-item form only.

What you end up with: the user fills the form and clicks Submit. The item saves, gets an ID like M-00005 written to its Title, and a success panel replaces the form showing that ID. Editing an existing item is untouched: no Submit button, no new ID.

1. Prerequisites

A SharePoint list with a Title column and a choice column (here RequestType, with values Onboarding, Access, Misc).
The list form customized in Power Apps: Integrate → Power Apps → Customize forms.

SharePoint Onlye App + Python Authentication Tutorial

Create a new App Principal (TODO: can we automate it?)

https://TENANT.sharepoint.com/_layouts/15/appregnew.aspx

Grant tenant-wide permissions. See full list of permissions.

https://TENANT.-admin.sharepoint.com/_layouts/15/appinv.aspx

<AppPermissionRequests AllowAppOnlyPolicy="true">

	# ================================================================================================== #
	# Prerequisites
	# ================================================================================================== #
	# Install-Module SharePointPnPPowerShellOnline -Scope CurrentUser
	# Install-Module -Name Az -Repository PSGallery -Force -Scope CurrentUser
	# ================================================================================================== #


	# ================================================================================================== #
	# Parameters

	// Get SharePoint List Fields in a table
	function getListSchema(listName) {
	var siteUrl = _spPageContextInfo.webAbsoluteUrl;
	var endpointUrl = `${siteUrl}/_api/web/lists/getbytitle('${listName}')/fields?$filter=Hidden eq false`;

	fetch(endpointUrl, {
	method: 'GET',
	headers: {
	'Accept': 'application/json;odata=nometadata',
	'Content-Type': 'application/json;odata=verbose',

	{
	"info": {
	"_postman_id": "7f9a258e-feee-40a7-827f-760caa441e43",
	"name": "Cognitive Search API Reusable",
	"schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json",
	"_exporter_id": "641744"
	},
	"item": [
	{
	"name": "Create SharePoint Data Source",

	SELECT
	last_user_update
	FROM
	sys.dm_db_index_usage_stats
	WHERE
	database_id = DB_ID('BOP') AND
	OBJECT_ID=OBJECT_ID('TempUsers')

	document.addEventListener('DOMContentLoaded', function() {
	var linksToHide = document.querySelectorAll('a.link-to-hide');

	for (var i = 0; i < linksToHide.length; i++) {
	var linkText = linksToHide[i].textContent \|\| linksToHide[i].innerText;
	if (linkText === 'Links' \|\| linkText === 'Liens') {
	linksToHide[i].style.display = 'none';
	}
	}
	});

	$registryPath = "HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System"
	$keyName = "EnableLUA"
	$desiredValue = 0

	try {
	if (Test-Path $registryPath) {
	$currentValue = Get-ItemProperty -Path $registryPath -Name $keyName -ErrorAction Stop
	if ($currentValue.$keyName -ne $desiredValue) {
	Set-ItemProperty -Path $registryPath -Name $keyName -Value $desiredValue -ErrorAction Stop
	Write-Host "The value of '$keyName' has been set to $desiredValue."

	# Load user32.dll
	Add-Type -TypeDefinition @"
	using System;
	using System.Runtime.InteropServices;

	public class User32 {
	[DllImport("user32.dll", SetLastError=true)]
	public static extern bool SetCursorPos(int x, int y);

	[DllImport("user32.dll")]