User Profile
Akshadaks
Copper Contributor
Joined Jul 18, 2023
User Widgets
Recent Discussions
Re: SharePoint list with calculated column to work out SLA based on days and hours
I have user a workaround for that. Created another column for adding the public holidays manually and that gets added to the SLA calculation. There are still issues with it though. E.g. if the request is received outside business hours, the SLA should actually start from the next day's business hour and not based on the creation date/time. I wonder if there is a way to keep another list with business hours and Power Automate to check if the request received is within that range, if yes, then blank, if no, then to consider the next business day and starting hour for calculation.Email reminder after 3 days based on the date and status
Dear Team, I have 2 columns in SharePoint, based on which I want to check the values and send the email reminder to the user. Columns: "Date - Draft entry submitted" - Populates date and time Please note it is in New Zealand Date time "Draft - Not Submitted" - Status column SharePoint Local setting is in New Zealand Date and time I have designed the below flow to trigger the notification when the date in column "Date - Draft entry submitted" is 3 days before todays date. Details on Convert time zone part: Filter query details: Applied in "Get items with filter"" Date_x002d_Draftentrysubmitted ne null and Status eq 'Draft - Not Submitted' Condition details: formatDateTime(item()?['Date_x002d_Draftentrysubmitted'],'dd-MM-yyyy') is equal to formatDateTime(addDays(utcNow(), -3), 'dd-MM-yyyy') Status value is equal to Draft - Not Submitted The flow is working but only the issue is with the date and time. For example; If today's date is 21/02/2025 Flow will send email to the user where the values are below; 18/02/2025 and time in AM only 17/02/2025 and time is in PM only I don't want it to consider the time part. It should only be triggered for all the records that are with values 18/02/25 (AM and PM both). Request for assistance. Also, for some reason my account is locked for the power platform community where I wanted to post this. Can someone please help unlock my account on the power platform community. RegardsCreate notification reminder based on date and status
Dear Team, I am trying to create a Power automate flow on sharepoint list based on the below requirements. Requirement: GIVEN I have created an item in a “Draft Not Submitted” status WHEN the date created column "Date - Draft entry submitted" for the item is 3 days before today’s date THEN trigger a reminder notification to the creator after 3 days Details: SharePoint internal column names "Status" "Date_x002d_Draftentrysubmitted" I have created the following flow In "Get Items" > Filter Query I have used - Date_x002d_Draftentrysubmitted eq '@{formatDateTime(addDays(convertTimeZone(utcNow(), 'UTC', 'New Zealand Standard Time'), -3), 'dd-MM-yyyy')}' and Status eq 'Draft - Not Submitted' This is because the Local setting is set for NZTA and the date format in the SharePoint column is in "dd-MM-yyyy" In "Condition" I have used - formatDateTime(item()?['Date_x002d_Draftentrysubmitted'],'dd-MM-yyyy') is equal to formatDateTime(addDays(convertTimeZone(utcNow(), 'UTC', 'New Zealand Standard Time'), -3), 'dd-MM-yyyy') Then there is another condition to check the status Dynamic "Status/Value" is equal to "Draft - Not Submitted" But the about flow is not working. Not sure what I am doing wrong. Request for your help. RegardsSharePoint list with calculated column to work out SLA based on days and hours
Dear Team, I am trying to figure out how to calculate SLAs based on the data captured in the SharePoint list. I have a basic understanding of the lists. I have captured the SLA numbers in SLA column where I used 0.5 to show 4 hour SLA. Details: SLA = 4 hours, 1-2 days, 2-5 days Expected Completion Date = =[Date Received]+SLA+ROUNDDOWN(SLA/5,0)*2+IF(WEEKDAY([Date Received])+MOD(SLA,5)>=7,2,0)-ROUNDDOWN(WEEKDAY([Date Received])/7,0)+IF(AND(MOD(SLA,5)=0,WEEKDAY([Date Received])=1),-2,0)+IF(AND(MOD(SLA,5)=0,WEEKDAY([Date Received])=7),-2,0) Result = =IF([Date Completed]="","",IF([Expected Completion Date]>[Date Completed],"Pass","Fail")) Issue: The problem is that I am not able to add 4 hours to the "Date Received" and not able to populate correct date under "Expected Completion Date" Also, not able to include public holidays in the calculation. Is there a way to include public holidays while calculating the "Expected Completion Date"? Your assistance is greatly appreciated. RegardsRe: Sharepoint column value (status) based on other multiple column values
Also with the code that I used, I am only able to use 2 types of statuses, but wondering if more than 2 status (results) could be achieved based on different combinations of selects. e.g. When Column1 = Yes Column2 = No Column3 = Yes Column4 = Yes Status (Result) = Approved (Conditionally) AND When Column1 = Yes Column2 = No Column3 = Yes Column4 = No Status (Result) = Rewrok required Hope that clarifies.Re: Sharepoint column value (status) based on other multiple column values
Hi SvenSieverding , Thanks for taking time and replying to the issue. I will give it a try with your method which seems way better than what I did already. 🙂 I used the below code in the Format Column section (screenshot below). "txtContent": "=if([$Column1] == 'No', || [$Column2] == 'No', || [$Column3] == 'No', || [$Column4] == 'No', || [$Column5] == 'No', || [$Column6] == 'No', || [$Column7] == 'No', || [$Column8] == 'No', || [$Column9] == 'No', || [$Column10] == 'No', || [$Column11] == 'No', || [$Column12] == 'No', || [$Column13] == 'No', || [$Column14] == 'No','Rework', 'Approved')" "txtContent": "=if([$Column1] == 'No', || [$Column2] == 'No', || [$Column3] == 'No', || [$Column4] == 'No', || [$Column5] == 'No', || [$Column6] == 'No', || [$Column7] == 'No', || [$Column8] == 'No', || [$Column9] == 'No', || [$Column10] == 'No', || [$Column11] == 'No', || [$Column12] == 'No', || [$Column13] == 'No', || [$Column14] == 'No','Rework', 'Approved')" However, because of this I was not able to populate the result for the new entry into and email (below screenshot for reference). As the container is applied by Power Automate automatically to entire records. Not sure why, is it because the "Result" column is created in Sharepoint and other columns are populated through Microsoft Forms? Not sure if I explained it clearly but let me know if it can be achieved some how. What I want is basically, based on the 14 (Yes/No) columns a "Result" column to show particular status and then trigger an email (only for the new/modified entry) including "Result" field to be sent to the user. Your help and support is greatly appreciate. RegardsSharepoint column value (status) based on other multiple column values
Dear Team, I have a very basic knowledge of SharePoint and therefore requesting for help for the below scenario. I want to create a column on a sharepoint list to show the status (Approved, Rejected) based on the values from 11 other columns that are (Yes/No). If all 11 column values are "Yes" then status to show result "Approved" and if any value in those 11 columns in "No" then status to show result "Rejected" Please let me know how I can achieve the above with possible syntax. Request for assistance. Regards
