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', '')" }458Views0likes1CommentRe: SharePoint Search Query exclude specific pages based on custom field value
Tamras1972 my first suggestion would be to double check what the internal name of the field is. You can find that in the library settings. Below is an article on how to find the internal name of your custom status field: https://elliskarim.com/2021/12/20/finding-the-internal-name-of-a-sharepoint-column/ This way you can find which one you would need to add to a mapped property. My suggestion would be to use one of the RefineableString ones from Microsoft for the mapping.989Views1like1CommentRe: SharePoint Search Query exclude specific pages based on custom field value
Tamras1972 you can use for example the ContentType, ContentTypeId or contentclass properties. Try something like: contentclass:STS_ListItem_WebPageLibrary Did you mapped the crawled property of your custom Status field to a mapped property in the search schema? If that is the case you should also be able to use it in your query builder.869Views0likes3CommentsRe: 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?1.6KViews0likes1CommentRe: 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])215Views0likes0CommentsRe: 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])634Views0likes6CommentsRe: 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-status2.6KViews0likes0CommentsRe: If statement in SharePoint
JasonM123 can you move the closing parentheses of the and function directly after the second expression? https://support.microsoft.com/en-gb/office/and-function-78956048-53c7-484a-ab0b-6e70d7f03400 AND(logical1,logical2) Try something like =IF(AND([Item Type]="Prospect",[FLW - Business Days Remaining]>2),"2","Not return 2")396Views0likes1CommentRe: 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-desktop439Views0likes0CommentsRe: 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?3.9KViews0likes2CommentsRe: 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.Re: Sign Out Button is Blank
Igor Biche, it's not a big issue at the customer at the moment. So it's not worth going to premier support for this. But if I find a solution I will definitely update this thread :) Btw, is social Technet forums still used? I thought those were deprecated?2.1KViews0likes1Comment
Recent Blog Articles
No content to show