User Profile
Jake_Hembree
Brass Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Using Modern Script Editor web part to copy text from a div container in SharePoint Page
I'm creating a page in SharePoint that will consist of various templates. I don't want to use mailto links because these templates will vary on who they are sent to and I want to person to review them before using them. My goal is to create a quick copy text button on the page for that body of text. In some cases it will be 3 or 4 paragraphs. I found some relatively basic code that uses a copy text function. I'm not very savvy when it comes to JavaScript and I only know enough to know that this is possible if I use the Script Editor. What I did was inspect the element of the body of text/section of the page so I can get the code needed and plug it and modify the copy text code that I found. I've added the code and images for reference below. Can anyone help me with this? Thanks in advanced. This is the code for the copy text button that I found: <!DOCTYPE html> <html> <head> <meta name="viewport" content="width=device-width, initial-scale=1"> <style> .tooltip { position: relative; display: inline-block; } .tooltip .tooltiptext { visibility: hidden; width: 140px; background-color: #555; color: #fff; text-align: center; border-radius: 6px; padding: 5px; position: absolute; z-index: 1; bottom: 150%; left: 50%; margin-left: -75px; opacity: 0; transition: opacity 0.3s; } .tooltip .tooltiptext::after { content: ""; position: absolute; top: 100%; left: 50%; margin-left: -5px; border-width: 5px; border-style: solid; border-color: #555 transparent transparent transparent; } .tooltip:hover .tooltiptext { visibility: visible; opacity: 1; } </style> </head> <body> <input type="text" value="I need help!" id="myInput"> <div class="tooltip"> <button onclick="myFunction()" onmouseout="outFunc()"> <span class="tooltiptext" id="myTooltip">Copy to clipboard</span> Copy Template </button> </div> <script> function myFunction() { var copyText = document.getElementById("myInput"); copyText.select(); copyText.setSelectionRange(0, 99999); navigator.clipboard.writeText(copyText.value); var tooltip = document.getElementById("myTooltip"); tooltip.innerHTML = "Copied"; } function outFunc() { var tooltip = document.getElementById("myTooltip"); tooltip.innerHTML = "Copy to clipboard"; } </script> </body> </html> This is code of the web element from the SharePoint page: <div class="ControlZone ControlZone--clean a_c_50a7110f" data-automation-id="CanvasControl" id="1212fc8d-dd6b-408a-8d5d-9f1cc787efbb"> <div class="ControlZone--control"> <div data-sp-feature-tag="Rich Text Editor" class="rte-webpart rte--ck5 rte--read-ck5 uniformSpacingForElements" data-sp-feature-instance-id="1212fc8d-dd6b-408a-8d5d-9f1cc787efbb" dir="auto"> <div data-automation-id="textBox" class="ck-content rteEmphasis root-153"><p>This is the area I want the copy template button to copy from.</p></div> </div> </div> </div>Gallery view formatting to group in columns
I'd like to know if their is a trick or JSON view formatting I can change so I can group all the items on a list in gallery view are grouped vertically by a certain list value (in this case the region which is a choice field). The image I attached helps explain what I mean. I like the exact card width used because 6 options across works perfectly actually.SharePoint Sync Issues
The Issue: Recently our team has experienced issues with only one of our many lists. Our Team (modern) Calendar that is made from a modern list. When we attempt to open an item on the list, it opens up the form as blank. We noticed that when this happens, if we create a new item, it never syncs to the list/calendar. Eventually it will give us a prompt from the view drop down that says "Items with sync issues".I've attached a screenshot of the calendar where I had previously added a test event to the 28th. The workaround: Only when we clear our cookies will this error go away. But shortly after (within an hour) it will give us blank forms again and our entries won't sync. Again we have to use incognito in Chrome or clear our cookies. Clearing cache alone doesn't fix it and none of our Chrome extensions appear to affect this problem. The circumstances: It's important to note that our SharePoint site uses had roughly 20 different lists but of those lists, only 5 of them have a lot of entries. Between all of our lists, my best estimation is around 4500 items. More than half of these lists have custom JSON added to them and there's well over a 1000 items with single images attached to them. Is it possible that the sync issues are coming from data limitations? If so, how can I confirm that?Automatically change FROM address based on subject line
I work on a team that uses our distro group as the FROM address line under certain scenarios. We send these emails out that always start with "Social Media Escalation - " followed by some other text that describes that unique situation. In these situations, we have a list of contacts in SharePoint that I've created a mailto link for that provides the proper contact and pre-populates the"Social Media Escalation - " subject line. I would like to know if there's a way that the FROM address changes automatically when the"Social Media Escalation - " subject line is being used. I'm never changed the FROM address field at any of my previous jobs so I don't know if the "Justification Required" is a default dialog box or something my company has done specifically but it's important to note that I have to select from three different options when it appears. We use "Previous label no longer applies" option when this prompt comes up (See screenshots for more details). I doubt there's a way to incorporate that in a mailto link but I'm very open to some trick that works. I don't know much about using VBA in Outlook but willing to do that as well. I'm pretty familiar with Power Automate but do not want to use that as a solution if possible. My assumption is if there is a way to do this, it's likely using Outlook VBA. Does anyone have any ideas or tricks they can share?Sync live or Catch Up Button for Excel
For training purposes, I need to share an Excel document with two other team members and see what their updates are live as they do them. Because I'm using an image for the Excel background and the online version doesn't support the background, I've shared the Excel Document with them using the Excel app. At one point, I could see what changes they made live, but stopped shortly after starting. I see they have the document open at the top. I was told about the "catch up" button but don't see it and couldn't find anything online on how to enable it. I've had all of us try using the save button but that didn't make a difference. One of the other team members had this message pop up but she wasn't doing anything to prompt this to come up. Me and the other team member haven't seen this ourselves. Does anyone know of how to get the document from the app to sync live or possibly know how to get a background image to appear for the online version? Thanks in advanced.Adaptive Cards in Teams using "Only show when" option
Visible/Hidden I've got an MS flow that sends an Adaptive Cards based on the date on the list. When the Adaptive card is sent, I want three separate images to be visible/hidden based on a multiple choice column(Checkboxes (allow multiple selections)). When I use the Adaptive Card Designer, I see the option that says"Only show when" and a checkbox that says "Initially visible". I want to know how to configure those settings so the social media icons (images) I see on the card are based on that platforms column. Optional but would also like: It would be ideal if the icons were aligned based on availability. For example Facebook is the center icon, but it Twitter and Instagram were the only ones chosen, I wouldn't want a big gap in the center. Or if Facebook and Twitter were the only options chosen, I wouldn't like having the gap on the far left. At this rate, I'd be happy to at least know how to get the basic functionality of visibility/hidden so if there isn't an easy way to do this, that's fine. I've attached some images including the entire flow if that's helpful. Thank you so much for any help! JakeAdaptive Cards in Teams using "Only show when" option
Visible/Hidden I've got an MS flow that sends an Adaptive Cards based on the date on the list. When the Adaptive card is sent, I want three separate images to be visible/hidden based on a multiple choice column(Checkboxes (allow multiple selections)). When I use the Adaptive Card Designer, I see the option that says"Only show when" and a checkbox that says "Initially visible". I want to know how to configure those settings so the social media icons (images) I see on the card are based on that platforms column. Optional but would also like: It would be ideal if the icons were aligned based on availability. For example Facebook is the center icon, but it Twitter and Instagram were the only ones chosen, I wouldn't want a big gap in the center. Or if Facebook and Twitter were the only options chosen, I wouldn't like having the gap on the far left. At this rate, I'd be happy to at least know how to get the basic functionality of visibility/hidden so if there isn't an easy way to do this, that's fine. I've attached some images including the entire flow if that's helpful. Thank you so much for any help!
