Add or plus button on Microsoft Power apps form

[Inom_Norkulov]

Hello community,

I have a sharepoint list connected to Power Apps, and I want button wich will add columns from sharepoint list on the form if some user wants extra information to add. 

Below formula does not help...

Patch(
'SharePoint List',
Defaults('SharePoint List'),
{
'Column 1': "Value 1",
'Column 2': "Value 2",
'Column 3': "Value 3"
}
) 

Thank you...

[Amik]

Hi Inom,

Power Apps can only update or add rows to a table where the columns already exist in the table schema. Creating new columns in not possible. You might be aware this is easily possible using Power Automate, but this would not be practical because after the column has been created, Power Apps cannot automatically add these new columns into your form.

This is a very common requirement, and the classic solution is to create a separate “child” table with links back to your parent table. Each time you update the data source in your form, you can patch the additional information onto separate table. You can then create a collection to display the data as one table.

Alternatively, if you expect there will be a limit to the number "extra information" columns users can have, a simpler option is to add x number of "additional information" columns to your SharePoint list and dynamically hide/unhide them on your form.

best regards,

ImranAmi

[Inom_Norkulov]

Hello Imran,

Thnaks for the answer.

How to add button to add existing column of sharepoint list to show up or hide, like "+" or "-"?

Best regards,

Inom

[Amik]

Assuming you're using a Form control:

1. Add the following to the OnSelect property of your button: UpdateContext({ShowColumn1: !ShowColumn1});
2. Add the following to the Visible property of your DataCard.
   
   
   
   
3. If you want this button to show/hide your other "additional info" columns, simply follow step 2 on the data cards for those columns. Alternatively, you could create a button per the number of additional ninfo columns you have.

Not that you asked, but a simpler option is to use a Toggle control, because this makes it clearer to the user whether or not a data card is set to be displayed  or not.

Add a toggle on your form and then in the on Visible property of the data card, enter Toggle1.Value. No need for anything else

[Amik]

@Inom_Norkulov  - If I have answered your question, please mark your post as Solved to close this.

[Inom_Norkulov]

Hello Amik,

Thanks for the answer. But it did not help.

I reqeustred the from ChatGPT - How to make "Add" or "plus" button on Microsoft Power apps to add fields from sharepoint list

The answer:

To create an "Add" or "plus" button on Microsoft Power Apps that allows users to add fields from a SharePoint list, you can follow these steps:

1. Open your Power App in the Power Apps Studio.

2. Add a Button control to your screen by dragging and dropping it from the left-hand side of the screen.

3. Rename the button to something like "Add Field" or "Add Record".

4. Select the button, and in the "OnSelect" property, add the following formula:

   Patch(SharePointListName, Defaults(SharePointListName), {ColumnName1: "", ColumnName2: ""})

   Replace SharePointListName with the name of your SharePoint list, and ColumnName1 and ColumnName2 with the names of the columns you want to add.

   This formula creates a new record in the SharePoint list and sets the values of the specified columns to blank.

5. Save and publish your app.

Now, when the user clicks the "Add Field" button, a new record will be created in the SharePoint list with the specified columns set to blank. The user can then edit the record and fill in the desired values for each column.

[Amik]

"How to add button to add existing column of sharepoint list to show up or hide, like "+" or "-"?"

@Inom_Norkulov Community forums cannot support you with what you think you want in your head, but only what you describe in your post.

Glad you found a solution.