User Profile
Kaptain_1959
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: Removing digits from a number in a Sharepoint List
The data is imported from a CSV file that is downloaded from our Sage accounting software. The currents sharepoint list has hundreds of entries so my first thought is to use a calculated column in the sharepoint list. I know how to accomplish this in excel.1.5KViews0likes0CommentsRemoving digits from a number in a Sharepoint List
I have a sharepoint list with a column called "Cust Po Line#". When data is imported into the cells of this row the source data shows the data as 100000000, 200000000....1000000000, etc. I need to remove 8 zeros from the end of every number. Can this be accomplished in sharepoint. So, end result would be 100000000 would be 1 and 1000000000 would be 10.1.6KViews0likes3CommentsRe: Problem Getting formula for date and time calculation to work properly
Thanks, I have tried to also getting todays date and time using a power automate flow and changing the date from UTC time to Central Standard time, (convertFromUtc(utcNow(), 'Central Standard Time'). This seems to fix the day issue but hours are still incorrect. This flow fills in the TodaysDate Column in Sharepoint.861Views0likes0CommentsProblem Getting formula for date and time calculation to work properly
I have the formula below in a Sharepoint column to calculate the amount of time that has passed since a file was created. The formula is not returning the proper number of days - calculating one more day than it should. =IF(OR(ISBLANK(Created),ISBLANK(TodaysDate2)),"",IF(AND((WEEKDAY(TodaysDate2,2))<(WEEKDAY(Created,2)),((WEEKDAY(Created,2))-(WEEKDAY(TodaysDate2,2)))>1),(((DATEDIF(Created,TodaysDate2,"D")))-(FLOOR((DATEDIF(Created,TodaysDate2,"D"))/7,1)*2)-2),(((DATEDIF(Created,TodaysDate2,"D")))-(FLOOR((DATEDIF(Created,TodaysDate2,"D"))/7,1)*2)))&" days, "&TEXT(MOD(TodaysDate2-Created,1),"hh "" hrs, "" mm "" mins"""))1KViews0likes2CommentsMoving items from one list to another using power automate
I have written a flow which would move and item in the Sambo Open Item Detail to Sambo Closed Item Detail when the Open/Closed column is populated with a "C" and then deletes the item from from the Sambo Open Item Detail. The "delete" from Sambo open Item Detail is working but the item is not being copied into the Sambo Closed Item Detail. Very new to using power automate any help would be much appreciated.
Groups
Recent Blog Articles
No content to show