hybrid
81 TopicsNeed Help with Date Formatting for SharePoint Event List
Hello everyone, I have a requirement where I need to save data to a SharePoint event list using a modal form and display the data as cards on a webpage. However, I'm encountering an issue with date formatting. The dates are not displaying correctly. I have tried several approaches, including: Saving the date in UTC format and converting it to local time when displaying. Using ISO format for date storage and display. Despite these efforts, the dates are still not showing correctly. Has anyone faced a similar issue or have suggestions on how to resolve this? Thank you in advance for your help! $().SPServices( { operation: "UpdateListItems", async: false, webURL: webURL, batchCmd: "New", listName: "Events", valuepairs: [ ["Title", Title], ["EventDate", EventDate], ["EndDate", EndDate], ["Location", Location], ["Category", Category], ["Description", Description] ], completefunc: function(xData, Status) { EventId = $(xData.responseXML).SPFilterNode("z:row").attr("ows_ID"); if(EventId > 0){ GetEventData(); } } });239Views0likes0CommentsCan I validate a colume based on athother colum?
Hello, i have a colume "FlowIsOn" that is a boolean and true if my power automate flow i turned on. I have antoher calculated field or rather a button that starts the flow. I have discovered that you can use colum validation to block a colum if it is not validated. My question now is: Can you validate a colum based on another. So i only want the ability to press my "StartFlow" Button(colum) if the colume "FlowIsOn" is set to false.Solved789Views1like3CommentsSharePoint REST API query not returning expected results with $top and $skip
I'm encountering an issue with the SharePoint REST API where my query seems to be returning the same XML response, regardless of the use of the $top and $skip parameters. Here are the two queries I've been working with: Query without paging: http://www.arc.com/_api/search/query?querytext=%27test%27 Query with paging: http://www.arc.com/_api/search/query?querytext=%27test%27&$top=20&$skip=10 Despite using $top=20&$skip=10 in the second query, the response appears to be the same as the first query. I was expecting a different set of results, but that doesn't seem to be the case. Additional Details: I'm using SharePoint to query a list of items. The list contains more than 20 items that match the query. I'm testing these queries directly in the browser for simplicity. What I've Tried: I've attempted adding a random parameter to the URL to bypass caching. I've verified that there are more than 20 items matching the query in the SharePoint list. Any insights into why the paging doesn't seem to be working as expected would be greatly appreciated!872Views0likes1CommentSharepoint online List attachments with Graph API or REST API to download
Hi I am working a proof of concept. I am relatively new to Sharepoint In low code / automation environment I need to download the files attached to Sharepoint List. The local files will be picked up by the automation software and emailed out and the file local path will also be integrated into the company ERP solution It has to be a HTTP call which is the best technology GRAPH or Sharepoint REST, especially in terms of features and security? I have struggled to get REST API registered as an Azure APP (Graph is fine) and wonder if REST API needs a user account to authenticSolved6.8KViews0likes2CommentsHow to disable Drag and Drop feature in sharepoint online document library
Hi All, Based on project requirement, we are using custom forms while uploading documents in SharePoint Online site using SPFx. However the drag and drop feature directly uploads the document, without loading the custom form. We are looking for 2 solutions if possible: 1. How can we disable the drag drop feature in sharepoint online. Is it possible with spfx or any other workaround? 2. If a document is drag dropped, our custom form should load immediately after uploading the document, so that the purpose of creating the custom form will be served. Can this be achieved in any way..? Any lead will be helpful.4.8KViews0likes2CommentsSimple Authentication Code to Access SharePoint Site
The goal is to allow some external users that are not a part of the company to have access to a single SharePoint site using a password or Authentication code. Does anyone know of a method that is very simple for the end user? Example: User clicks on a link to either a custom web app or the SharePoint site, enters in the code which then "authenticates" and redirects to the SharePoint site homepage. The current authentication code process built into SharePoint requires too many steps to get logged in for our end users. SharePoint Built-in Authentication Process Sending the user an invitation User accepts the invitation user requests a code Once the code is entered it takes them to the myapps.microsoft.com From there they can either click on an app in myapps or go directly to the SharePoint site Any suggestions would be greatly appreciated.1.8KViews0likes0CommentsSharePoint Modern Site Pages missing features
The SharePoint admin at our company has recently created a hybrid on-prem site. After the site was created I did a migration using ShareGate where an infopath form migrated as well as 3 designer workflows. They want to continue using these for now before upgrading to PowerApps and Automate. My problem: I went to create a modern site page however a LOT is missing. For example, when updating a banner, quick links or any other image, I do not have all of the normal options. I only have "Recent", "Site", "Upload" and "From a link". I do NOT have "Stock Images" and "OneDrive". Also, I do not have the option to do collapsible sections when creating the site pages. I have tried to do a lot of research but have not found anything. I am wondering if the administrator created the site wrong or if it is a feature I need to activate, but I could not find anything. Please let me know if you need more information. Thank you!845Views0likes0Comments-2147024891, System.UnauthorizedAccessException Sharepoint Online Rest API
I am getting below error in SharePoint rest API, even though I am passing the latest Bearer Token { "error": { "code": "-2147024891, System.UnauthorizedAccessException", "message": { "lang": "en-US", "value": "Attempted to perform an unauthorized operation." } } }2.2KViews0likes1CommentCalculated formula contains a syntax error or is not supported
Hi! I've a Date and Time column Revision Date. And try to create a Calculated column Revision Date (dd mmm yyyy). It because I want to change a look of date and set to (dd mmm yyyy). So, after added a formula =TEXT(Revision Date,"dd-mmm-yyyy"), I have an Error "The formula contains a syntax error or is not supported". Could you help me please, how I can fix this problem? Thx!Solved1.5KViews0likes2CommentsSharePoint Site Plan
Hi guys, a bit new to SharePoint so I need some help for SharePoint Site architecture for multiple companies including file sharing and access. Background: Our company consists of one company with 8 "sub-companies" all with: different companies MAIN COMPANY Company abc Company xyz Company klm etc. different domains email address removed for privacy reasons email address removed for privacy reasons email address removed for privacy reasons different tenants on Azure AD different employees having rights to different files We are moving from a on-prem server to a hybrid server (365 & on-prem). Some of our applications (accounting, payroll, etc.) will be kept on the on-premise server and all files (Excel, Word, etc.) will be moved to 365, hence the SharePoint sites. What we want: We want to build a SharePoint site (Home Page) for the MAIN COMPANY and subsites for each company (Company abc, xzy, klm, etc.). The MAIN COMPANY will house: HR Documents Policies and Procedures Leave forms etc. IT Documents Policies and Procedures Other forms etc. Other Documents The sub sites for each company (Company abc, xzy, klm, etc.) should have sub folders (file sharing for collaboration) for different departments within each company: Finance Marketing Operations, etc. These should have different access permissions based on the employee level (Manager vs Clerk vs EXCO) We have the following architectural structure in mind: We would like: for all employees across all companies regardless of employee level to access the HOME PAGE as well as the content (Policies and Procedures, Training Material, etc.) create links to the subsites for each company to access files and folders to collaborate on (with certain access permissions) We would then have: HR document sharing (collaboration) in a separate site for obvious reasons IT Document sharing for the IT Department only - Optional Our Challenges: Our challenges sits with the permissions to grant as we have different domains. We would then create the MAIN COMPANY in one tenant (Azure AD) and create guest users for each company to allow file sharing across companies. We also have growth in mind (adding new companies under the MAIN COMPANY) Assistance needed: Is this the correct approach? Any other suggestions would be welcomed Can we get some videos on this on how to create something like this?1.4KViews0likes4Comments