Charles
  • Member for 6 years, 5 months
  • Last seen more than 4 years ago
  • London, United Kingdom
Office 365 & Azure AD
Accepted answer
3 votes

An Azure AD instance is already setup in the background for each Office 365 tenant. Essentially what's meant with Signing Up is getting an Azure account so that you can access to further settings of ...

View answer
How can I fiter a list using url parameters?
Accepted answer
2 votes

/AllItems.aspx?FilterField1=MyField&FilterValue1=XYZ

View answer
SP13: Adding Shading to Custom List
Accepted answer
2 votes

I suggest you use the default style and change .ms-alternating instead. If you prefer .ms-listviewtable { width: 100%; } makes it look exactly like shaded view with the added bonus of having the ...

View answer
Display total number of items in a view
2 votes

Have you considered grouping the table with the Status ? Which would then show total number of items for each group. If you prefer to do it as you suggest, yes it can be done using JQuery. You need ...

View answer
Best practice for a new site - Sites or Subsites?
2 votes

Separate site versus subsite decision is really about permission management. By default subsites assume permissions from their parent site. So if you are likely to have some common permission settings ...

View answer
SharePoint Designer 2013 make a contract due date workflow
1 votes

I developed few solutions having a similar requirement. Best method I found was the following: A create/modify workflow on contracts which sets a Reminder Date field for Due Date - 30 days Then a ...

View answer
Sharepoint 2013 application design - list 11500 items per month
1 votes

1) I think SharePoint list can do it. Assuming you would need SharePoint for approvals themselves, there is no reason to break it into two platforms. 2) I would put them all in the same list. In any ...

View answer
How can I retrieve data from excel workbooks stored in SharePoint
Accepted answer
1 votes

I tested this quickly, it works just fine and I guess it is what you are looking for (access to Excel table using ODATA): https://mysite.sharepoint.com/intranet/_vti_bin/ExcelRest.aspx/MyLibrary/...

View answer
Auto drop value everyday
1 votes

SharePoint 2013 workflow with "Pause 1 day" as the last action and calling itself as the next stage works very consistently. I was skeptical at first that it might have broken at some point, running ...

View answer
Where to Start? SharePoint Dashboards/Live Reporting
1 votes

I used this library to produce pivot tables on few occasions. It is handy but not very impressive looking I must admit. Taking into account that you are on Office 365, I highly recommend you to look ...

View answer
workflow stages not persistant
Accepted answer
1 votes

Workflow just runs and completes without maintaining any state information. On these kind of requirements I create a choice field, called State or Status. Let's say "Stage 1", "Stage 2", "Stage 3" as ...

View answer
How to show an alternative web structure when browsing a SharePoint site?
1 votes

What we use for this kind of requirements is to run a JavaScript code in the master page to get user's department and redirect it to the relevant hierarchy. Department vs Department Home Page URLs are ...

View answer
Sharepoint 2013 - Filter list view based on the site name, without code
1 votes

Few points to highlight Invoices list sits on the top level site and you try to display the same list under each supplier's own site. There is an approach called "Re-purposing a list or library" to ...

View answer
Filter List View / CQWP/ DVWP by Current Users Department
0 votes

There is a solution I used few times but it's not the most elegant one. It is possible to create list views filtered on a Person field based on whether the current user is a member of a group or not. ...

View answer
Making an dynamic <And><Or> Caml Query
0 votes

CAML queries only accept two conditions for logical operators. So you can do <And> <Eq>...</Eq> <Eq>...</Eq> </And> but not <And> <Eq>...&...

View answer
Linking List via unique Number
Accepted answer
0 votes

If there is a one-to-one relationship (i.e. one scoring entry for each master entry) it is easy. A workflow running on scoring item changes can update master list by looking up with Issue ID. If ...

View answer
! Disable one choice from choice list!
Accepted answer
0 votes

Can't think of a solution without using some amount of coding. An elegant way to handle your requirement is to get Product Types from one list, Product Names from another list (which is linked to ...

View answer
create item for the list From Another Workflow
0 votes

Three options; Use 2010 workflows instead of 2013 if the activities you need included in 2010. This is a limitation that applies only to 2013 workflows. Make Create Workflow a 2010 workflow and ...

View answer
Email Notification for SharePoint list when minimum amount of entries have been reached
0 votes

You can make a REST API call to get the number of total items in your list. One of the sites I found explaining how to do this is this You actually need to implement only the first 5 actions of this ...

View answer
Workflows and ISBLANK statement
0 votes

I think this can be done in a simpler fashion; effectiveDate is a date field and emailSent is a Yes/No field with default No A workflow which runs on Item Change and Creation If effectiveDate is ...

View answer
Workflow in 2013 will not start when an item is created
0 votes

Two approaches I use for this kind of requirements; You can use 2010 workflows if all the functionality you need is included. Alternatively most of these kind of requests can be reduced to single ...

View answer
Tracking multiple list entries for individual users
0 votes

In this kind of situations I use a Courses Attended list. When user updates the Registration list a workflow does the following: Checks if user exists in the Courses Attended list. It is assigning ID ...

View answer
How come the URL of my new web application doesn't resolve?
0 votes

Either a DNS issue, please check if ping thenewsite works from a command prompt on another workstation. Or it may be the case that IIS is configured to accept web requests by headers (url names) ...

View answer
SharePoint 2013 Designer Workflow - Create item with multiple choice field
Accepted answer
0 votes

This works fine when I test it. Below is how I did to let you compare. Might be a good idea to test it in isolation on your SharePoint to eliminate other potential issues. Create a list called Test ...

View answer
How to get filtered sharepoint list item using REST API
0 votes

I think it needs to be https://MySiteName/_api/web/lists/getbytitle('MyList')/items?$select=Title,ID,Status&$filter=Status eq 'Completed'

View answer
"The file has been modified by..." error, when the workflow starts automatically
0 votes

When you upload a document, first screen uploads the document, second screen (if there are any metadata to be set) lets you populate the meta data. First form essentially initiates a create action, ...

View answer
Task workflow not firing on task created by information management policy
0 votes

Is it not possible to run a workflow as Information Management Policy action, get that workflow to create the task and change notification text as required ? When you create a new task, you get a "...

View answer
How do I add leading zeros to a variable in Sharepoint 2010 site workflow?
0 votes

I tend to use a sandboxed custom workflow action for this kind of requirements. You can simply write an AddLeadingZeros custom action and use it in your workflows. I appreciate this requires Visual ...

View answer
Workflow: Add Person from text to Display Name
0 votes

Does it work as it should be when you later run that workflow manually on the items that did not update ? If yes, try to put a Pause 1 min at the beginning of your workflow which runs at document ...

View answer
SharePoint designer workflow getting suspended, when we reassign the task
0 votes

As mentioned in the error message, issue is an input string is not being in a correct format. Assuming that you are assigning task to another user (not to another workflow as in the question), issue ...

View answer