Forum Discussion

Chris_Clark1968's avatar
Chris_Clark1968
Brass Contributor
Nov 14, 2025

Edit a SP list column unable to enter data

Hi,

I'm trying to edit some data in a column within my SP list.   The column type is Choice.   The issue is the is not a 'Choice' field.

When created it was going to be a Choice field but when I built the Powerapp that is feeding data to this column is has become a lookup field.

So in my app the user selects Division and then the wards in the division are available for selection in the Ward field. Sort(Distinct) formula used looking at another SP list

SharePoint

PowerApp

This as caused an issue as I need to edit one some values in the Division and Ward columns in SP.

Can I amend the column values to Single line of text, without losing any of the data??

If not is there away I can amend, edit the data??

 

accessibility
Lists

1 Reply

  • DaveMehr365's avatar
    DaveMehr365
    MVP
    Jan 21, 2026

    Hi Chris_Clark1968​ 

     

    this are 2 different technologies. You can create lookups or choices in Power Apps with SharePoint text fields, so you have all the logic in Power Apps. This ist not possible in only SharePoint...

     

    You will lost the data, when you switch the field type in SharePoint. 

     

    You can create new fields, copy the values from your old choice field to the new text field and add this to Power Apps and use your new fields.

     

    Best, Dave

Resources