Ravi Magham

Printing Date Format in  Power Automate (Flows) I was trying to format print the date and found multiple ways to print Date perticularly Month for my requirements. please find various  Month Format  formatDateTime(triggerBody()?['Test_x0020_Date_x002F_Time'],'MM/dd/yyyy') Output 12 /11/2020  formatDateTime(triggerBody()?['Test_x0020_Date_x002F_Time'],'MMM/dd/yyyy')   Output  Dec /11/2020  formatDateTime(triggerBody()?['Test_x0020_Date_x002F_Time'],'MMM/dd/yyyy') Output    December /11/2020  Surce https://sharepains.com/2018/11/12/formatdatetime-flow-power-automate/     The formatting options for formatDateTime, that you can use here are listed in the following table. Any of the format specifiers can be used in any kind of combination. FORMAT SPECIFIER DESCRIPTION EXAMPLES “d” The day of the month, from 1 through 31. More information:  The “d” Custom Format Specifier . 2009-06-01T13:45:30 -> 1 2009-06-15T13:45:30 -...

Get Email User Name, email from SharePoint person field in list  you can get user name and email from person field is the group or person coloumn Create PersonGroupCol - person or group field If you are not going to use those email address values later (you don't need to save emails in column) and you just want to show the email in SharePoint list view then you can also achieve it using JSON column formatting. Create one single line of text column (Email, Name) Hide it from list forms (make it  Hidden  from content type settings). Then use below JSON code to format the column: { "$schema" : "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json" , "elmType" : "div" , "txtContent" : "[$ PersonGroupCol . email ]" } For User Name { "$schema" : "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json" , "elmType" : "div...

Remove special characters  from the SharePoint list column using calculated column =REPLACE([FirstNameLastName],SEARCH(" & ",[FirstNameLastName]),0,"") or =IF(ISERR(SEARCH("&",Title,1)),Title,REPLACE(Title,SEARCH("&",Title,1),2,""))  Source https://social.technet.microsoft.com/Forums/sharepoint/en-US/42391d83-a6eb-480f-b84a-3d43ef4f5e40/calculated-column-to-remove-amp-and-space-quotamp-quot?forum=sharepointgeneralprevious https://social.technet.microsoft.com/Forums/office/en-US/74d8022b-03f4-4ccf-9bfc-a3075a2f9202/multiple-replace-on-calculated-column?forum=sharepointgeneralprevious

Excel Data Get the last character in excel cell l using formula - like  to remove special character =RIGHT(A1,LEN(A1)-(LEN(A1)-1)) Extract all but last one characters from string Select a blank cell and type this formula =LEFT(A1,LEN(A1)-1)

SharePoint fixed table header  for SP 2010  https://sharepoint.stackexchange.com/questions/157621/sharepoint-fixed-table-header/164330#164330

Shortcut to open Instead of going to the Edit Properties form of the page, we can easily open the WebPart Maitenance page by just adding the following query string to the page URL ?contents=1 So, if your page URL is 'http://rams/pages/default.aspx' then after appending the query string it should look like '  http://rams/pages/default.aspx?contents=1 ' Source: http://www.spdeveloper.co.in/tipsntricks/pages/opening-webpart-maintenance-page.aspx https://support.office.com/en-us/article/open-and-use-the-web-part-maintenance-page-eff9ce22-d04a-44dd-ae83-ac29a5e396c2