Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Sharepoint and Powerapps

(0) ShareShare
ReportReport
Posted on by

Hello,

I'm trying to make a powerapp based on someone filling out a form to get a subscription service for our company. My sharepoint list has calculated columns in it, and it does not resonate with powerapps when I try displaying the data. Does anyone have any solutions?

luveevee618_0-1636588697089.pngluveevee618_1-1636588718272.png

 

  • Drrickryp Profile Picture
    Drrickryp on at
    Re: Sharepoint and Powerapps

    @Anonymous 

    You will need to have an edit form to enter the data into the SharePoint list.  A display form can be used to show the field in a record.  Galleries and data tables are useful to show the data in the entire list and to select the record you wish to work with. Forms are used to edit or display the information in a single record. 

  • Re: Sharepoint and Powerapps

    thanks! So does the field have to have a gallery? It can't be a display form? And is there a way to only show one column instead of all of them?

  • Drrickryp Profile Picture
    Drrickryp on at
    Re: Sharepoint and Powerapps

    @Anonymous 

    1.jpgIn the screenshot on the left, a calculated value for profit is shown in the bottom. The formula in red is the Default value of the text input box.  The gallery shows the Order number for the item selected.  In this case, the first item in the gallery is selected.

  • Re: Sharepoint and Powerapps

    Hello! Do you think you can do a screenshot of the process? It'll be easier for me to follow along if I have a visual. Thanks for all your help!

  • Drrickryp Profile Picture
    Drrickryp on at
    Re: Sharepoint and Powerapps

    @Anonymous 

    Yep, don't use calculated columns in SharePoint, Stick with number type and do the calculation in PowerApps and save it to the number column.

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard