cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

COLLECTIONS: Sharepoint Calculated Columns?

I have a Calculated-type column in a Sharepoint custom list set to:

=DATE(YEAR(lastServiceDate),MONTH(lastServiceDate)+maintDuration,DAY(lastServiceDate))

WIth `Date and Time` set as the results in the column settings. 

I'm collecting it in PowerApps with `ClearCollect(colName, sharepointList)` (nothing special)

The calculated column is populated in the Sharepoint list but remains blank in the collection. 

Is this a known issue or..?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: COLLECTIONS: Sharepoint Calculated Columns?

Maybe it was just a temporary thing. Now i'm able to Collect Sharepoint calculated-type columns without issue. 

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: COLLECTIONS: Sharepoint Calculated Columns?

Hi @ericonline ,

As far as I know, calculated column is read-only in PowerApps.

So you could only view it in PowerApps.

That's the reason why you can not save it to collection.

Here's a doc about it for your reference: (Please read the Known issue part)

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-onlin...

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User
Super User

Re: COLLECTIONS: Sharepoint Calculated Columns?

Hello @v-yutliu-msft , thank you for the reply. 

It is interesting to me that collecting a read-only field from Sharepoint is not possible. Good information.

Highlighted
Super User
Super User

Re: COLLECTIONS: Sharepoint Calculated Columns?

Maybe it was just a temporary thing. Now i'm able to Collect Sharepoint calculated-type columns without issue. 

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,709)