Finding column reference number - error in Power Automate

Adele

Good evening :)

I need some help to locate the column reference number - I have a flow in Power Automate that fails because "The value for cell in column 6915777523148676, did not conform to the strict requirements for type PICKLIST.

Can anyone advise how I can identify which column has the problem?

Appreciated in advance,

Adele

sharkasits

@Adele you can get to if if you are using the API using https://api.smartsheet.com/2.0/sheets/{sheetId}/columns

It will list the columns in the sheet including the column ID and Name. I haven't seen a way to get to it in the front end though. Maybe someone else has found a way to get to it