Unanswered

Help with Locking a Column After a Selection is Made

(0) Share

Report

Posted on by Vincebk

Good morning, all. Sorry if this has been asked in the past, but I can't seem to get the right answer for this. I created a list in Teams with multiple users to sign up for shifts. I want to lock the participant tab once a user signs up. Could someone help me with this?

Categories:

Building flows

Power Automate Desktop

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

PowerDeveloperTP 453 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Vincebk

Could you please provide more details, as you mentioned to lock participants tab?

Is it a column in a list? is it like do you want to make the column non editable when you meant by locking?

Thank you

Was this reply helpful? Yes No
Vincebk 38 on at

Like
a
(0)

Report
Copy link

Link copied!

The Participant column was made so that a user can go in and select their name. I would like that column to be non editable once a user inputs their name.

Was this reply helpful? Yes No
Ellis Karim 12,163 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
I think is a SharePoint question.

See this video which shows how to customise SharePoint list forms: (1243) Make SharePoint Forms 10× Better with JSON (Sections, Read-Only & Conditional Fields) + Claude AI - YouTube

If you do set the Participant column to read only using this method, you won't be able make any corrections (edits) to it later. In edit mode, the Participant column won't be displayed because it is read only.

So, you may want to make the Participant column read-only based on the value of another column (e.g. if columnX = <some value>, set the Participant column to read only).

This is just a rough example, based on the content of the above video. This JSON configures a SharePoint form with two sections. In the fieldsettings, the Participant field becomes read-only only after the item has been saved (assigned a SharePoint ID) and if it contains a selected person.

{ "sections": [ { "displayname": "Section 1: User Input Form", "fields": [ "Title", "Notes (optional)", "Authors", "Phone Number", "Participant" ] }, { "displayname": "Section 2: User Input Form", "fields": [ "Invoice Number", "id_grp_mng_User", "FruitChoice", "Startdatum", "Actions", "Run Flow" ] } ], "fieldsettings": [ { "name": "Participant", "readonly": "=if([$ID] > 0 && [$Participant.email] != '', 'true', 'false')" } ] }

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
Vincebk 38 on at

Like
a
(0)

Report
Copy link

Link copied!

I would like to lock the participant tab after a participant is inputted. For example, we are going to offer shifts and ask employees to sign up for these extra shifts. I would like the Participant section to be locked after a participant selects a shift to avoid confusion or the ability other employees to remove the initial participant and input their name.

Was this reply helpful? Yes No
David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Based on what you describe, I believe you will need to customize the SharePoint list form with Power Apps. You can get to that from the list menu:

You can then set up rules to achieve what you need. If you need help with that and don't get an answer here, I suggest you post the question in the Power Apps forum: Microsoft Power Platform Community Forum Thread.

We do not use this feature as it is far more complicated than it needs to be. Instead, I can easily achieve this with a simple rule by customizing the form with Nintex. Once the form is submitted, a rule can prevent the field from being edited. I could even set the rule so that only certain people can edit the value after it has been submitted. Nintex has extra costs associated with it and you can learn more at Nintex Forms for Office 365. PlumSail forms is another potential solution that allows you to customize SharePoint list form and add rules: Build public web forms for any website or customize modern SharePoint forms

If you don't want users to edit the values in grid view, you can disable edit in grid view in the list settings under advanced settings.

Was this reply helpful? Yes No