Skip to main content

Notifications

Community site session details

Community site session details

Session Id : UzOUHGXyvdl7F8tVpsnkt5
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,312 Super User 2025 Season 1 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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 191 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 104

#3
stampcoin Profile Picture

stampcoin 80

Overall leaderboard
Loading started