Horvth_Csaba
Nov 28, 2022Copper Contributor
Using a variable for Excel column name in Patch function
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.