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

Notifications

Announcements

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,297 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard