
Hi,
I have an app with :
_A Datepicker
_A text entry named TextComment
_A Gallery with a list of names with checkboxes attached to them wich is linked to a list names AGENT_LIST with only 1 column named "AgentName"
_A button
I would like to add a column to the AGENT_LIST list with the date from datepicker as a title and the text entry as the content, but only for the names where the attached checkbox is active.
I tried to use the AddColumn function but i get multiple errors.
Here's what I tried :
AddColumns(
Filter(
AGENT_LIST,
CheckBoxAgent.Value = true
),
{
Text(DatePicker1.SelectedDate, "[$-fr-FR]dd/mm/yyyy"),
If(CheckBoxAgent.Value, TextComment.Text, "")
}
)
Any ideas ?
Thanks!
Hello @QuentinS ,
What you're trying to do is impossible.
"AddColumns" requires three parameters:
- The datasource
- The name of the new column (must be a string)
- The value of the new column
As the name must be a string, you can't reference a control to name the column