Skip to main content
Community site session details

Community site session details

Session Id : kP/yVBLkeTT1WJP2ilUapn
Power Apps - Building Power Apps
Answered

Sharepoint List Calculated

Like (0) ShareShare
ReportReport
Posted on 21 Jun 2022 23:44:12 by 72

I am having a sharepoint List an I am trying to create a calculated Column for some automated inputs based on other columns. 

I have about 15-20 columns but in the Calculated section under my Formula Intern Column I am unable to seee all my columns. 

Any ideas or suggestions on how I can bring in new columns into the input sections?

 

 

 

 

  • Verified answer
    v-bofeng-msft Profile Picture
    on 24 Jun 2022 at 06:11:04
    Re: Sharepoint List Calculated

    Hi @ATUFAILHAASAN ,

     

    If we try to create a new calculated column on the All Field Types List, we only see the valid type fields listed where we can insert them into the Formula.

     

    The field types that cannot be used in Calculated Columns are:

    • Choice (Checkbox)
    • Multiple Lines of text
    • Person fields (including the Created By and Modified By fields)
    • Hyperlink
    • Lookup
    • Managed Metadata

    In addition, If you still have questions about this issue, I suggest you refer to @365-Assist 's suggestions to the SharePoint forums for help.

     

    Best Regards,

    Bof

     

  • 365-Assist Profile Picture
    2,316 Moderator on 22 Jun 2022 at 00:33:28
    Re: Sharepoint List Calculated

    You would probably get a better response if you post this in the SharePoint Community forum.  Welcome to the SharePoint group. (microsoft.com)


    ---------------------------------------------------
    Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

    Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
    Twitter: https://twitter.com/assist_365

    Regards
    Darren Lutchner - 365 Assist

     

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473