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 / Fill in sharepoint col...
Power Apps
Answered

Fill in sharepoint column with formulas in power apps

(0) ShareShare
ReportReport
Posted on by 81

I created a sharepoint list with 3 columns that don't need to be filled in throughout the form, but they are calculated with the values from the other columns that do need to be filled throughout the form.

The columns only updates when I edit the form, not when I create it.

 

I added the datacards as invisible in the form. FE i also want to show the department of the person I selected, so I use ThisItem.medewerker.Department as default value, but It's not showing up until I edit the form.

Sarah_cool_0-1674829660564.png

Sarah_cool_1-1674829677811.png

Sarah_cool_2-1674829694119.pngSarah_cool_3-1674829803348.png

 

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

    @Sarah_cool 

    If you want the Items to show up in a new form, you will need to base your calculations on the actual numbers being input as the Default property of the control so something like DataCardValue1.Text + DataCardValue1.Text

    As far as your question regarding department, see http://powerappsguide.com/blog/post/show-office-365-profile-detail-in-form for more information 

  • Verified answer
    Sarah_cool Profile Picture
    81 on at

    @Drrickryp , there is no .text property, so how do I do this?

    I want to fill in the title using the column Medewerker (this is a person's field) and property display name combining it with a date field that has to be chosen in another column.

    So how do I do this?

    Sarah_cool_0-1674928072653.png

     

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @Sarah_cool 

    Perhaps @WarrenBelz can help with that.  I don't use complex field types when I design my apps.

  • Verified answer
    Sarah_cool Profile Picture
    81 on at

    I found it.

    Office365Users.UserProfile(DataCardValue2.Selected.Email).Department

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @Sarah_cool 

    Congratulations!  Smilegif.gif

     

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