Auto populate form fields when the end user selects a specific field on a modern SP list

Harry N Nomikos 1,311 Reputation points
2022-03-30T10:48:51.64+00:00

Hi Team

Is it possible to have certain columns auto-populate when the end user selects a specific field in a modern SP list form.

As an example, If the end user selects "New Recruit" under the "Request Type" field it will then auto populate the below 3 fields to reflect;

Field Name: "Resource Type" and for it to select: "Contractor"
Field Name: "Vacancy Reason?" and for it to select "New Position"
Field Name: "RPS attached*" and for it to select: "Yes"

I don't have access to power-apps so I'm trying to find a work-around

Cheers,
Harry

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,952 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 48,176 Reputation points Microsoft Vendor
    2022-03-31T12:23:33.013+00:00

    @Harry N Nomikos

    As a workaround, you could create a automated flow to update item field when end user selects "New Recruit" in the "Request Type" field.

    Here is the example:

    188763-image.png
    188660-image.png
    188791-image.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.