cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Raeville
Frequent Visitor

Unable to update SharePoint list column - Column not found

Hi,

 

I'm trying to update a few SharePoint columns. However, it says column not found when it does exist on SP list.

 

I used the following formula:

 

Patch(Leaves, LookUp(Leaves, ID = ID), {RA_Approval_R: Approve, Roster_CalCheck: true})

 

It says 'RA-Approval_R' column does not exist. It is just a Single line of text column.

 

What could be the issue? 

 

Thanks! 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Thorpe
Super User
Super User

Have you verified that "RA-Approval_R" is the internal name of the column in SharePoint? To check, go to List Settings and click on the column name. Then on the column settings page look at URL and at the end there should be a parameter called "Field=InternalFieldName". The value of "InternalFieldName" is the internal name of the field.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Jeff_Thorpe
Super User
Super User

Have you verified that "RA-Approval_R" is the internal name of the column in SharePoint? To check, go to List Settings and click on the column name. Then on the column settings page look at URL and at the end there should be a parameter called "Field=InternalFieldName". The value of "InternalFieldName" is the internal name of the field.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

Thanks Jeff! Wasn't aware of the Internal field name...

I used this to solve the same issue I was having, but noticed that some of my Sharepoint columns required this approach, and others (in the same Sharepoint list) allowed me to use the display name of the column, not the internal name. 

All of the columns were created at the same time, so dont know what the difference between them is...

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (22,477)