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 / Sharepoint and Powerapps
Power Apps
Unanswered

Sharepoint and Powerapps

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

 

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

    @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.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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
    Super User 2024 Season 1 on at

    @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.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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
    Super User 2024 Season 1 on at

    @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. 

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!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard