We can automatically generate this by using Microsoft flow or Power automate.
So let us create the flow.
Step-1:
Go to https://flow.microsoft.com and sign in with your Office 365 credentials.
Step-2:
Next click on Create from the navigation and then select Automated flow like below:
The Flow name and in the choose your flow’s trigger select When an item is created like below:
Next, select the SharePoint site address from the Site Address dropdown like below. Once you select the SharePoint site, it will auto-populate the lists in the List Name dropdown. Select your List.
Next, click on + Next step. And then search for variable in choose action and add a Initialize variable select Type as String and in the value click on “Add dynamic content”.
write the below expression and change as u r formula
concat(‘Sale List-‘,triggerBody()?[‘Job Tittle’]?[‘value’],’-‘,triggerBody()?[‘ID’])
Now, we need to update the list column value with this value coming in the variable. For this click on + New Step and then you can choose Update item flow action.
Site Address: Select the SharePoint site
List Name: Then Select the required list, in this case the same Jobs list I have selected.
Id: From the Dynamic content select the list item id column.
Title: From the Dynamic content select the list item Title column
Description: From the Dynamic content select the list item Description column
Job Tittle: From the Dynamic content select the list item JobTittleValue column
JobID: From the Dynamic content, select the variable that we have created before.
Save the flow and by this step, we created our flow successfully, that will auto generate SharePoint list column value.
Note: Don’t enter anything for the JobID column, this column value will be updated by the Microsoft flow. You can also remove the list column from the New form or edit form in the SharePoint list.
