User Profile
Expiscornovus
Iron Contributor
Joined 9 years ago
User Widgets
Recent Discussions
Re: Formatting View in List based on criteria
DekkerNick1 can you replace the utcNow by the '@now' special string value? https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/formatting-syntax-reference#now Try something like below { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "additionalRowClass": "=if([$Urgentie] == 'Oplossen binnen <6 maanden' && [$Status] != 'Gereed' && (Number(@now) - Number([$Created])) > 15778800000, 'ms-bgColor-redDark', '')" }Re: Custom ASPX files are downloading, not running.
Ashley_Nicholson custom site scripts are blocked. So, aspx files wouldn't be able to run because of that setting: https://learn.microsoft.com/en-us/sharepoint/allow-or-prevent-custom-script#features-affected-when-custom-script-is-blocked When you try to allow it the custom script settings for a specific site only lasts for a maximum of 24 hours. After that time, the setting will reset to its original blocked value for that specific site. What are you trying to present in those aspx pages?Re: SharePoint Calculated Column Refuses to Return a Correct Date!
Arnie_Howes what is the setup of your fields. I assume the Last Review Date is date only? Or are you also using a time? And is the number field without decimals? Have you also tried this formula, just to see if that makes a difference? =DATE(YEAR([Last Review Date]),MONTH([Last Review Date]),DAY([Last Review Date])+[Review Frequency])Re: Add days to Calculated Columns base on Number of Months
Rowell2022 you can use the date and day formulas to add number of days. https://learn.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=office.14)?redirectedfrom=MSDN#add-dates Below is an example for your setup In this example I am using the Second Payment date if the months is less than 3 btw. Don't know what you want to use in that case? =IF([Months to Pay]>=3,DATE(YEAR([First Payment]),MONTH([First Payment]),DAY([First Payment])+60),[Second Payment])Re: This site is read only at the farm administrator's request.
mwaters1385 sounds like your site is in a lock state. I would suggest to contact your administrator to investigate this in the central administration/SharePoint Online admin centre. Below is an example for on SharePoint on-prem https://answers.microsoft.com/en-us/msoffice/forum/all/this-site-is-read-only-at-the-farm-administrators/b2611b36-3b4f-45fc-a9a6-ea11abcfa427 This is an example for SharePoint Online: https://learn.microsoft.com/en-us/sharepoint/manage-lock-statusRe: Creating a sharepoint list programatically
APinglay if PowerShell is not possible I would suggest to have a look at something like Power Automate cloud or desktop flows. Via these products you should also be able to automate some steps. You could for example read the table with list rows in table action and use Send an HTTP request to SharePoint action to create your fields in a cloud flow. Desktop flows (RPA) also has a lot of Excel actions: https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/excel and also supports Python code, https://learn.microsoft.com/en-us/power-platform/release-plan/2024wave1/power-automate/use-python-v3-power-automate-desktopRe: Add date created/entered to JSON code for SharePoint list
Hi Beth_Culpepper, What value does the date need to be, today's date? Or do you have a separate column in your list which you want to reference in your card view? And where in the card do you want to display it? Btw, do you have a link to the Github repo?Re: Delete Calendar Invite Email when RSVP through Respond to an Event Invite V2
Pablito45 & Jared Bennett, I think I have found a workaround. You can use retrieve the correct id via the eventMessage in the Graph API. https://docs.microsoft.com/en-us/graph/api/eventmessage-get?view=graph-rest-1.0&tabs=http Below is an example.
