Unanswered

Fill in sharepoint column with formulas in power apps

(0) Share

Report

Posted on by Sarah_cool

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@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

Was this reply helpful? Yes No
Verified answer

Sarah_cool 81 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Sarah_cool

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

Was this reply helpful? Yes No
Verified answer

Sarah_cool 81 on at

Like (0)

Report

I found it.
Office365Users.UserProfile(DataCardValue2.Selected.Email).Department

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@Sarah_cool

Congratulations!

Was this reply helpful? Yes No