SharePoint List Calculated Columns

(0) Share

Report

Posted on by PVLove

299

Hello All!

I have just started working with SharePoint lists in Power Apps. I'm trying to convert a SP 2007 list with calculated columns into a SharePoint list form in Power Apps and not having much success. My question is, are SharePoint list's calculated columns not supported in Power Apps, especially from a list created in SP 2007? Thank you in advance for your assistance!

PVLove

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

That depends on what you mean by supported. yes they do show up in Power Apps, but they can be a problem if you try to use them for filtering or sorting. What problem are you having?

Was this reply helpful? Yes No
PVLove 299 on at

Like (0)

Report

Thank you for the quick response! The calculated columns are not populating the 'Next Award Date' (a Single line of text column) with the date required for the issuance of a safety award, which are generated at 3-months, 9-months, 15-months, 24-months, 26-months, 48-months & 60-months. The list is functioning as expected in SP 2007, but the formulas are not working in the SharePoint Online list. The formulas for the calculated columns are below. I can send screenshots if you need them. Thank you for your help and patience.

DisplayNextDate
=IF([Next Award Date]="","",[Next Award Date])

Month
=MID([Next Award Date],6,2)

Year
=LEFT([Next Award Date],4)

HireDateAsDate
=IF(LEN([Hire Date])=10,(CONCATENATE(MID([Hire Date],6,2),"/",RIGHT([Hire Date],2),"/",LEFT([Hire Date],4))),"")

NextAwardDateAsDate
=[Next Award Date]

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Where are you inserting the formulas you list? Are you putting these into Power Apps? or into calculated columns in the list?

Was this reply helpful? Yes No
PVLove 299 on at

Like (0)

Report

Hi PStork1,

I have the formulas in the list. Now, here's the stupid question. Do I need to put them in Power Apps as well; Power Apps doesn't read them in the form?

PVLove

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report
Looking further at the formulas. I think you are trying to do something in SharePoint that isn't supported anymore. You can generate the value of a calculated column using a formula in that column. But you can't generate a value in another column based on a formula in a calculated column. And I think that is what you are trying to do. The way calculated columns work in SharePoint is that the [Next Award Date] column would be a calculated column, not a single line of text. And it would have a formula like:

=IF(LEN([Hire Date])=10,(CONCATENATE(MID([Hire Date],6,2),"/",RIGHT([Hire Date],2),"/",LEFT([Hire Date],4))),"")

You could also populate the column by using Power Apps to update the value.

Was this reply helpful? Yes No
PVLove 299 on at

Like (0)

Report

Thank you so very much. Now I can stop beating my head against the wall. I will try your suggestion and see if I can make that work.

PVLove

Was this reply helpful? Yes No