web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / add additional columns...
Power Apps
Unanswered

add additional columns to a collection

(0) ShareShare
ReportReport
Posted on by 356

Hello community,

 

On the first site of my app, I create this collection by clicking a button as follows:

ClearCollect (
col_KEA;
{
User: lb_log_1.Text;
GB: lb_log_2.Text;
VKB: lb_log_3.Text;
Email: lb_log_4.Text
}
) ;;
Navigate (scr_site_2)

 

On page 2 now I have input fields.

Now I enter values ​​in these input fields. If I now click on a button, I would like the data from the input fields to be added to this collection as columns.

 

I thought it would go like this:

 

AddColumns (col_KEA;
{
Company name: inp_01_01_Firmierung.Text;
Street: inp_01_02_Strasse_Hausnr.Text;
ZIP: inp_01_03_PLZ.Text;
Location: inp_01_04_Ort.Text;
Tel: inp_01_05_Tel.Text;
Mobile: inp_01_06_Mobil.Text;
Fax: inp_01_07_Fax.Text
}
)

 

But that's wrong.


What am I doing wrong or what is the right way?

 

The goal should be that I only have one data record in the collection, but at the end this one data record has about 50 columns. And this data record is then written to a SharePoint list at the very end.

Thank you for your help.

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @RoScha 

    AddColumns is a function that returns a table altered with the columns you add.  So, in your formula, you are doing nothing with the output of the AddColumns.

    AddColumns does not alter the referenced datasource (a collection table in your case), it just returns the results with the added columns.

    However, your AddColumns is NOT correct.  You are not adding columns in that formula, you are adding a record.

     

    What is it that you are trying to achieve?  And, is there any reason you need a collection for the values you are referencing...that you already have!?

  • RoScha Profile Picture
    356 on at

    Hello @RandyHayes ,

     

    well I have little experience with the PowerApps. I am still at the very beginning. The app I am currently trying to program is about developing a form in which data is entered.
    The problem is: this form is filled out directly at the customer and it is known that in Germany the mobile Internet is not available everywhere. That's why I can't connect this app directly to a SharePoint list to save the data directly when entering it there. Because if the employee has no internet on site, he can't save the data either.

    Now I know that a collection remains stored in the cell phone until the app is closed.

     

    And therefore my idea: the app will have 5 pages. On each page information about the collection and the one record will be added and when all 5 pages are completely filled, a mobile internet connection exists, then this data should be saved in a SharePoint list.

     

    This is my idea. But what idea would you have @RandyHayes ?

     

    Best regards

    RoScha

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard