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 (3)

Answers (0)

PowerDeveloperTP 379 on at

Like (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 36 on at

Like (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 11,959 Super User 2026 Season 1 on at

Like (0)

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