Add column to a list

(0) Share

Report

Posted on by QuentinS

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!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

WiZey 3,023 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No