SharePoint Designer
22 TopicsSharepoint Designer 2013 Looping and Looping Emails
I am trying to automate a process within my business and would like to see if this would even be possible in the way that I have envisioned. One of the things my team handles. Is our businesses domain estate. Our domains have a listed "Business owner" from inside the business. Every month we need to reach out to those business owners where a domain is coming up for expiry to ascertain if the respective domain is to be renewed or not. I have setup a SharePoint list, key fields being the domain, expiry date, 60 days from expiry and 30 days from expiry. I was looking to run a few daily workflows that check on the 60 days and 30 days column and send an email to the business owner to attain renewal status (Renew yes/no). One of the things is, we have multiple domains with the same business owner. So I would like to try and refrain from sending a person multiple emails per domain and try and collate all domains expiring around the same time in to one email. So, I would like to try and loop through my list, locate the domains expiring within 60 days take all the domains with the same business owner and email that person at once, listing each domain in the email. I don't know if I have used the correct process. But at the moment, I have the following: Stage 1 If CurrentItem: 60 Days remaining equals Today Loop: 1 The content of this loop will run repeatedly while: CurrentItem:Email Group equals Group 1 (i have gone through my list and added Group 1, 2, 3, etc.. where we have domains listed against the same business owner. So, all domains by Joe Blogs has Group 1, all domains by John Doe are Group 2, etc..) Build Domains Dictionary (Output to Variable: Domains) Then Build Expiry Dictionary (Output to Variable: Expiry) Then Email CurrentItem: Business Owner Email Address I will then do another loop for Email Group equals Group 2, then Group 3, etc.. The point where I am stuck, is trying to build the email and ensure that I list each domain and the expiry date in an eligible way. Rather than just listing the string of domains as a string and then the expiry dates as a string, with no real correlation between what domain has which expiry date. Any input would be appreciated! Few things to note: I have to use SharePoint Designer 2013. The SharePoint list i am working with does not have access to be used with PowerAutomate 😞 Thanks for taking the time to read all this!471Views0likes1CommentSharePoint & SharePoint Designer help.
Hello I an working on my office site. I want to create appointment bookings for vehicle maintenance. I have a list created & it's connected to a calendar. I want to show the available appointments for the month above the form, and cross out the appointments that have already been booked to prevent double booking. I only want to have 2 appointments a day and only appointments Monday through Friday. I will also need to change the number of appointments a day from two to one of someone goes on vacation or out sick. Once the appointment is created I will need s email to be sent out to the mechanics and the person who created the appointment showing confirmation of the booking.628Views0likes0Commentsedit with microsoft office sharepoint designer link is not whowing in edge
Hi, We can edit the sharepoint sites in the browser itself clicking on the menu "edit with microsoft office sharepoint designer" this option is coming fine in IE 11. where as we access sharepoint application in edge - we dont see that option. could you please let us know how to enable that in edge647Views0likes0CommentsThe Business Data Connectivity Metadata store is currently unavailable. (External SharePoint List)
I'm trying to create an external SharePoint list to a SQL Table (Done this before). However, when trying to complete the step of External Content Type I am having no luck Connecting to SharePoint Online through the Designer tool then navigating to External Content Types is not working for me. I first get: The Business Data Connectivity Metadata store is currently unavailable. Then I get the following when clicking "External Content Type": The HTTP Service located at https://<org>.sharepoint.com/_vti_bin/BDCAdminService.svc is unavailable. This could be because the service is too busy or because no endpoint was found listening at the specified address. Please ensure that the address is correct and try accessing the service again later. (The remote server returned an error: (503) Server Unavailable.Solved11KViews0likes5CommentsSharePoint Designer 2013 Site Workflows in SharePoint Online Site
I have try to edit my existing sharepoint 2013 site workflows, but i'm getting below error. Error: "Failed to load the workflow definition for the workflow" I have try reinstall my designer and clear the cache, but it's not working. Kindly anyone please suggest the solution for this issue.723Views0likes0CommentsSharePoint custom theme toggles to a default Blue after a published site page refresh.
I have created a SharePoint subsite and applied a custom theme to it. The page looks good until I publish it. After it is published, once I refresh the page, it quickly toggles to a default blue theme. The theme was created using the custom PowerShell script as below, $themepalette = @{ "themePrimary" = "#e81a2b"; "themeLighterAlt" = "#fef5f6"; "themeLighter" = "#fbd8db"; "themeLight" = "#f8b6bb"; "themeTertiary" = "#f1707b"; "themeSecondary" = "#eb3342"; "themeDarkAlt" = "#d11726"; "themeDark" = "#b01320"; "themeDarker" = "#820e18"; "neutralLighterAlt" = "#f8f8f8"; "neutralLighter" = "#f4f4f4"; "neutralLight" = "#eaeaea"; "neutralQuaternaryAlt" = "#dadada"; "neutralQuaternary" = "#d0d0d0"; "neutralTertiaryAlt" = "#c8c8c8"; "neutralTertiary" = "#595959"; "neutralSecondary" = "#373737"; "neutralPrimaryAlt" = "#2f2f2f"; "neutralPrimary" = "#000000"; "neutralDark" = "#151515"; "black" = "#0b0b0b"; "white" = "#ffffff"; } Add-SPOTheme -Identity "ThemeName" -Palette $themepalette -IsInverted $false846Views0likes0CommentsBooking System - SharePoint
I created a Booking System using List of Sharepoint, the requirments are as follow Booking Date: This is set to select the desire Date but not today Date or Past Date "I added the Enforce unique values and add the Column validation for it =[Booking Date]>TODAY() with the message to appear as "The date entered cannot be today or in the past." Booking Time: This is set as (Dropdown List) Morning: 07:00am-03:00pm Evening: 04:00pm -11:30pm All day: 07:00am- 11:30pm Now the requirement is If someone wanted to book Lets say on 31-12-2021 can able to book Morning and if someone/Same Person wanted to book on same day evening time can be done but the Uniqe Value of booking date is the issue, it dont allow double booking and if i removed this uniqe value then many ppl can book at same Day and time. And if someone click one All Day even then no one can book Morning and Evening. If anyone knows how please support, Validation or Java Script. Kindly provide the full details im new to this please. Thanks Inadvance.1.4KViews0likes0CommentsInfoPath replacement in SharePoint 2016
We are in process of migration from SharePoint 2010 to SharePoint 2016. In our environment we have a lot of InfoPath forms. I know we can migrate the InfoPath forms from SharePoint 2010 to SharePoint 2013 and then to 2016. Given that InfoPath will be deprecated, we don't want users to create more InfoPath forms as this will be difficult for any future migrations. Are there any alternative in SharePoint 2016 from Microsoft for InfoPath forms? We would avoid using third party tools. Thanks in advance for your help!Solved26KViews0likes11CommentsUnable to edit or open Workflows
I am trying to see and edit workflows on our SP Online site (backend SP 2013) but all I can see is that they exist. When I try to open them up in SharePoint Designer 2013 I get this: I am using 64 bit SP Designer 2013. I can't seem to install any patches because it says it effects nothing installed on my machine yet I clearly have it installed and I clearly have issues addressed in the patches. I have already seen a post like this (and others on the web) about the patch but apparently I can't use that. Is there another fix? How else can I edit these workflows?4.2KViews0likes3Comments