Forum Widgets
Latest Discussions
Add button to Sharepoint list to generate an email draft with selected users' emails in bcc
I'm currently trying to replicate in Sharepoint 365, via power automate, a functionality that I had developed in a JS snippet in the old sharepoint 2013 on a Email ditribution list page. My snippet code was this: <input onclick="SendMailToSelcted();" type="button" value="Send E-Mail"> <br> <script language="javascript" type="text/javascript"> function SendMailToSelcted() { var items = SP.ListOperation.Selection.getSelectedItems(); var ctx = SP.ClientContext.get_current(); var web = ctx.get_web(); var currentListGUID = SP.ListOperation.Selection.getSelectedList(); var list = web.get_lists().getById(currentListGUID); var rows = new Array(); for(var i = 0; i < items.length; i++) { var row = list.getItemById(items[i].id); ctx.load(row); rows.push(row); } ctx.executeQueryAsync(function () { var ids = ''; for (var i = 0; i < rows.length; i++) { var r = rows[i]; ids += r.get_item('cs6w') + ';' ; } document.location='mailto:' + '?bcc=' + ids ; }, function(sender, args) { alert('Request failed. \nError: ' + args.get_message() + '\nStackTrace: ' + args.get_stackTrace()); }); } </script> This snippet is no more allowed in my actual SP365. The functionality was: once selected different users out of the sharepoint list (with email address availble on their records), when a button at the top of the list is clicked(snippet), an outlook email draft should be created with all selected users' emails filled in "bcc" field. The user has to edit each time that generated email draft with subject and text and send it. I'm now not aware how to replicate it in Sharepoint 365 List through power automate and its flows. Any suggestion is really appriciated! Thanks MaxMassiFENov 14, 2024Copper Contributor22Views0likes1CommentDifference between two SharePoint Sites
I am struggling to understand the difference between the two different versions of “team sites” in SharePoint. I understand that a communications site has “https://froneri365.sharepoint.com/sites/” prefix. Furthermore, my understanding was that the team site had the prefix “https://froneri365.sharepoint.com/teams/” That is if I create communications site from the SharePoint admin panel, I get/sites/ prefix, if I create 365group first, and then create a team using that group, I get a SharePoint site with /teams/ prefix. However now when I got my hands on and export of SharePoint sites from our tenant, and I have some sites that have /sites/ prefix, but have “Team site” as a Template attribute, while others have “Communication site” as an attribute. What is the difference between these two “/sites/” sites? My main concern is permission management, and converting the sites to hubs. And what is the difference between the two sites with "Team site" template attribute but with different prefixes, one with /teams/ prefix and the other with /sites/ prefix Mind you I have no access to the SharePoint admin portal, so I cannot create SharePoint sites via the admin portal, only via Office365 group. Thank youPetersDaveNov 13, 2024Copper Contributor21Views0likes2CommentsDifferent (conditional) background colors in a list - Microsoft List vs. Sharepoint Group
Hi, I have created a Microsoft List that uses conditional row formatting to mark entries that have been changed within the last 31 days with a light blue background color. This is the JSON for it: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "additionalRowClass": { "operator": ":", "operands": [ { "operator": "<", "operands": [ "[$Age]", 31 ] }, "sp-css-backgroundColor-BgLightBlue sp-field-fontSizeSmall sp-css-color-BlackText", "" ] } } This works fine, as long as I view the list from within Microsoft Lists. I have also added the List to our SharePoint Group Site, but the the background color here does not look the same. Instead, it is much darker and seemingly the "palette" of usable colors is much smaller. I tested some other nuances by changing the 'sp-css-backgroundColor' to BgGold, BgLightBlue20 and BgLightGrey but always ended up with a much darker background color when displaying the List from the Sharepoint Group. Does anyone know if there is some parameter in the Sharepoint Group settings that I can change to make the Group display the colors correctly, or any other way to solve this? Thanks. Best regards Patrick List View from within Microsoft Lists: List View when embedded in Sharepoint Group:Pati_ANov 13, 2024Brass Contributor78Views0likes1CommentProblems with sharepoint synchronization
hello!! I'm having some synchronization problems related to SharePoint. At my work, we use a very heavy spreadsheet, with about 50~80mb, where several people work at the same time via SharePoint... This usually causes some expected problems such as delays in calculations or fatal errors, but recently there has been a specific error that has been happening sometimes. During the week, one of the 6 people working on the spreadsheet can simply become a "ghost". They can see who is online in the spreadsheet working with them and the others can also see them online... But any and all changes they make will be visible only to them, not only in the desktop version of the application but in the browser version as well, as if they were working on a local version of the file, but online... We tried to do some things like: * clear the %temp% folder * clear the specific Excel folder in %appdata%/microsoft/excel * check for files that need attention in "Open new file -> Documents that need attention" * Unsynchronize the Excel application OneDrive/SharePoint from the computer, delete all local files and sync again * Change the Excel cache option in "Options -> Save -> Cache" to delete every time the file is closed and also clear the cache But none of this works, the only thing that seems to work to fix the error for the specific person is for someone who is not having this problem to create a copy of the Excel file in SharePoint and rename it... After that, the person's changes appear again for the rest, fixing the error. The worst part of this problem is that it has no indication or warning. Recently, members of my team lost days of work because they had become "ghosts" and their changes were not being saved, only when indicated by other members who were also working on the same spreadsheet or constantly checking the Excel version via browser can you be sure that your changes are being saved. I would like to know if anyone has experienced this and how to solve this error Thank you for your attention!!20Views0likes0CommentsContent Type Document Template Limits
I have a power user that has created a Content Type in their site with an Excel File Template. This has been working for a long time. The template was last updated in January 2024, but now suddenly the users that are using the New Menu on a List Webpart cannot create new documents using the template. I've reviewed the template, and the document is 95MB. Are there any known limits to how large a document template can be for a content type?SolvedMLWakemanDSMNov 13, 2024Brass Contributor51Views0likes1CommentList toolbar randomly missing
I have a site there the list toolbar randomly doesn't appear 50% of the time. Refreshing the page usually loads it correctly. There are several lists and libraries on this same site. The issue is happening for all of them. First image is where it's suppose to be. Second image is what it's suppose to be. There is no custom formatting involved here. It's also happening in three different browsers I've tried (Chrome, Edge, Firefox). I've also noticed that some of the other list formatting doesn't show as well for the choice columns. Thanks for your help!gsreddin51Nov 13, 2024Copper Contributor404Views1like4CommentsSharepoint Excel not automatically syncing responses from MS Forms until opened
The recent MS Forms update done messed up the syncing of SP Excel wherein responses from MS Forms are being synced to. My dataset in Power BI is currently connected to the SP Excel containing the MS Forms responses and even though the scheduled refresh for the dataset is pushing through, it is not displaying the latest records unless I open the SP Excel and a "Syncing.." status will appear. Only then will I be able to refresh the dataset in Power BI containing the latest records. What would be the best workaround to update the Excel file in Sharepoint automatically once a response in MS Forms is added?JaizeNov 13, 2024Occasional Reader18Views0likes0CommentsShare link not created when sending to users
I've noticed a change in how links are created, specifically when the option to send a link is selected. It looks like a bug to me, not a feature. Has anyone seen documentation, updates or known issues about this? Steps: Share a selected file using 'People you specify' or 'People in [your org]' Add users Select Send User is emailed standard email and link to document User is added to 'Manage access' under people and given direct access No link is created under "Links" Happening on multiple Australian tenants. When created using 'Copy link' or 'Send link in Outlook' the link is created under the 'Links' tab in Manage access - as per normal behaviour.MattBurrNov 12, 2024Iron Contributor34Views1like3CommentsNested Dynamic Filtering on web parts does not work
I created a Sharepoint page and added an MS list web part, which I use as a "filter" selection. Then, I added a second MS list to display the main list of content items, configured with Dynamic filtering based on selecting the "filter" list. Then, I added a Document library web part, which is again configured with Dynamic Filtering based on the selection of the second content item list. Unfortunately, when you select an item from the "filter" list and then select an item from the second "content" list, the document library does not update based on the selection. HOWEVER.. If I select an item from the second "content" list without selecting an item from the "filter" list, the document library updates and shows the filtered content correctly. Any idea why it would not work and how to fix this? Seems like it should work367Views0likes14CommentsSwapping a root site, but maintaining a list
Hi all, We are swapping our dated root site for a modern site. Our current root site was created back in 2016, and uses SharePoint classic. We plan to swap for a modern site and launch with a fresh look for our organization's intranet. I understand when swapping a root site, the initial root site's site collection is archived. Including lists. We have an expansive IT Intake list on our current root site, which includes workflows that send email approvals, as well as Jira integrations. We still use this IT Intake list. Is there any way to preserve the IT Intake list and/or migrate it, its workflows, and content onto the new root site without losing any data or duplicating our efforts? I have seen that you can extract the list and import it to a new list, but this is not ideal. As a note: we cannot use third-party migration tools at this time. Thanks!BDaniel1015Nov 12, 2024Copper Contributor14Views0likes0Comments
Resources
Tags
- SharePoint Online17,453 Topics
- Document Library2,972 Topics
- Lists2,915 Topics
- Sites2,383 Topics
- Admin2,149 Topics
- SharePoint Server1,956 Topics
- Permissions1,872 Topics
- files1,593 Topics
- developer1,478 Topics
- Microsoft Lists1,398 Topics