Unable to patch dropdown values to sharepoint list

[VijaiSurya]

I am trying to patch a certain dropdown selected value onto a SharePoint list to a column which takes in data type of single line of text. 

So in the On Select property of my Gallery, I have the following code

Patch(coll, ThisItem,  {Driver: inp_Driver.Selected, 'Free Text': inp_FreeText.Text, 'Reason Code': inp_Reason.Selected.Value})

The collection gets patched patched onto my SharePoint list through a button which has the following code on the OnSelect property:

If(vEdit,Patch('Clayton Plan Sequence',coll);Notify("Data Patched",NotificationType.Success));
Select(bldata);
Set(vEdit,!vEdit)

The element in select is a button and this code seems not relevant but I'm just putting it just in case

Clear(coll);
ClearCollect(coll, 'Clayton Plan Sequence')

All other columns are getting patched except the 'Reason Code' column. Can someone tell me why? I have no formula errors but the data just doesn't get patched.

[poweractivate · Accepted solution]

@VijaiSurya 

That is because your 'Reason Code' column might actually be called something like Reason_x0020_Code internally.

To check for sure, navigate to:

https://YourSubdomainHere.sharepoint.com/sites/YourSiteNameHere/_api/web/lists/getbytitle('YourListNameHere')/fields?$filter=Hidden%20eq%20false%20and%20ReadOnlyField%20eq%20false

and check the information there, especially pay attention to what it says for<d:EntityPropertyName> and <d:InternalName> for each column.

If you see a strange difference in the name like _x0020_ for spaces, such as like Reason_x0020_Code - you need to use Reason_x0020_Code instead of Reason Code in your formula.

Check also some more info about basic SharePoint REST operations here

See if above helps you @VijaiSurya .

[VijaiSurya]

@poweractivate 

Your suggestion worked but now the Free Text column the same issue. And I checked for the answer the same way. The column name is now  "Action_x0020_Taken". Any idea what to do since my collection column name is very different from my SharePoint list

[BCBuizer]

Hi @VijaiSurya ,

Please use the below article to find the internal name of your SharePoint columns and adjust the column names of your collection to match those:

https://tomriha.com/what-is-sharepoint-column-internal-name-and-where-to-find-it/#:~:text=Where%20to...'.