In SharePoint Calculated Column, A formula starts with an equal sign (=) like we do calculation in math. In create column page you will see one dedicated space for writing formula, where you will write formula for calculated column. Though you can use other formula & function in calculated column but we usually face difficulty with Dates so i am...
Continue reading...SharePoint
How to store MS Forms multiple choice to SharePoint List?
In Microsoft Power Automate Community, i have seen lots of post regarding “How to save MS Forms multiple choices to SharePoint List?”. Problem with Multiple choices is that it gives you output in array format like [“Paris”,”Berlin”,”Milan”]. We can store this output in our SharePoint List but it is not a clean output for look and feel. Today i will...
Continue reading...How to create calculated column in SharePoint List/Library?
In my previous post, where i have explained “What is a calculated column in SharePoint?” and now i will show how calculated column will be created in SharePoint List/Library. Steps- Go to your SharePoint List/Library. Click on +Add column then Click on more.. This will redirect to a create column page. Click on List/Library setting then click on create column...
Continue reading...What is a calculated column in SharePoint?
In SharePoint, Calculated column is another special type of column (metadata). it will calculate values based on other columns for the same row in the same SharePoint list or library. Calculated Column uses Excel-like syntax to calculate the new values.You can create Calculated Columns on any list or library or at the site level(and then add it to the list...
Continue reading...How to get Week number from Date in SharePoint Online?
In SharePoint Online, we know the functionality of calculated columns. Whenever we need to do some calculation based on existing columns in a list we use Calculated column. Microsoft has given very good reference for all formulas in calculated column. And trust me date column is very intriguing feature in SharePoint list. Today, I will show you how to calculate...
Continue reading...How to delete person in SharePoint Power Apps form?
I have customized SharePoint form in Power Apps. It is working perfectly except it is not patching person data when I removed person from people picker field. Then I came to point that one more thing is missed from Microsoft.
Continue reading...
