Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Adding Calculated Columns to Static Table

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I have a table imported from an excel spreadsheet to which I want to add three columns.

 

The issue I'm having is that the third column is calculated off the other two.

 

When I try to add them all in the Items formula using AddColumns I can't get the third to access the first two as they dont' exist yet (at least that's what I think is happening).

 

Is there a way to add columns outside of Items?

 

 

Cheers

 

  • Lewkir Profile Picture
    Lewkir on at
    Re: Adding Calculated Columns to Static Table
    Thanks for the help, Drrickryp, unfortunately I'm not sure this will fully work with what I'm trying to do as I need to reference items in a gallery in one of the calculations without it being prompted by the user. useful info to know though which might come in handy in the future. cheers
  • Drrickryp Profile Picture
    Drrickryp on at
    Re: Adding Calculated Columns to Static Table

    You can do it with th OnSelect property of a button or in the OnVisible property of the screen containing the gallery. The syntax is

    ClearCollect(colDatasource, Yourdatasource)

    The Items property of the datatable or gallery would be  

    AddColumns(colDatasource,”formulaname”,calculation,”formulaname2”,calculation2,etc.)
  • Lewkir Profile Picture
    Lewkir on at
    Re: Adding Calculated Columns to Static Table
    Hi Drrickryp, Sorry I'm still fairly new to powerapps. Where would I actually type the code? I'm guessing you mean use the collect function as described here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect but I'm uncertain where I would write this. Thanks for the response.
  • Drrickryp Profile Picture
    Drrickryp on at
    Re: Adding Calculated Columns to Static Table

    Hi @Lewkir,

    Please try creating a collection from your static datasource and then add the calculated columns. You should be able to display the results in a gallery or datatable as well as shaping the collection by filtering, sorting, renaming columns, etc. The main advantages are that you can create collections from very large datasources, all functions will work regardless of delegation, and they will be lightning fast.

    The disadvantage is that you won’t be able to save them unless you create another datasource to save them to.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard