SharePoint List Calculated Columns

[PVLove]

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

[Pstork1]

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?

[PVLove]

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]

[Pstork1]

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

[PVLove]

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

[Pstork1 · Accepted solution]

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.

[PVLove]

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