Using a variable for Excel column name in Patch function

Copper Contributor

Hello,

I would like to provide the column name as a text input but its seems not accepted.

I've tried:
Patch(Table,Defaults(Table),{name: TextInput1.Text, TextInput2.Text: -1})
Patch(Table,Defaults(Table),{name: TextInput1.Text, 'TextInput2.Text': -1})

 

Set(column,TextInput2.Text);
Patch(Table,Defaults(Table),{name: TextInput1.Text, column: -1})

 

None of them is working.

Is it possible to use a dynamic for the column name?

Thank you. 

0 Replies