Recent Requests

Working on migrating a client from SharePoint 2007 to SharePoint Online. The current SharePoint 2007 has about 10 workflows that interact with 7 different SharePoint lists that all need to be migrated to Logic Apps. All the workflows and lists are part of a single process and are interconnected to each other. Requires a good understanding of SharePoint 2007 workflows as well as Azure Logic Apps. The current process is loosely documented, but the details of the existing workflows are not, so it will be using the documented process as well as digging into the existing workflows and understanding what’s going on. A document showing the outline of the entire process as well as screenshots of the 2007 workflows can be found here – https://intelligink.sharepoint.com/:w:/t/tea/EWox5RRIkx5Imz2bunb8KCQBAjlxgOJX6lFuqf7Odnm34A?e=Cih3uu

Budget: 3,000.00 USD - 4,000.00 USD

Deadline: March 12, 2019

Tags: Azure Logic Apps, microsoft flow, SharePoint 2007, SharePoint Online, SharePoint Workflow

We are looking for someone to write an article every month for our website: www.axioworks.com. Our product is used to export data from SharePoint lists to SQL server tables, making it easy to use the data in SSRS, Power BI, integrate it with other systems, etc. so the target audience for the articles should be BI/Reporting/Data Analysts and Developers. The article is aimed at SharePoint users rather than admins, so no articles on how to configure permissions, deploy a new farm, etc. The main goal of these articles it to add regular relevant content to our site, with the aim being to attract traffic. We will provide the topic for the articles but suggestions will be very welcome. As an example, these are the titles of our last four articles:

• SharePoint Online vs On-Premise: which one to go for?
• How some major companies adopted SharePoint in their LOB
• Comparison of BI Tools: Power BI vs Cognos vs Crystal Reports vs SSRS
• SharePoint as a Corporate Data Warehouse: Pros and Cons

The article should be 800-1000 words long and the content unique, not published partially or entirely anywhere else. If you wish to link to it from other sites, ask for our approval first. If the article states specific facts, list the references of those facts in the article. Keep a neutral point of view. If you are interested in this job, could you please provide a couple of examples of articles you have written. The next article is needed for mid-Mar. So that you are aware, we plan to try different freelancers, so this is not a regular monthly job for one person – at least initially.

Budget: 100.00 USD - 150.00 USD

Expected delivery: 30 days

Deadline: March 20, 2019

Tags: Reporting, SharePoint, SQL, Technical writer

We would like to move our current knowledge, policies and procedures article to SharePoint Online in order to take advantage of centralized search. We currently utilize Confluence. We are hoping to be able to build a fairly simple KM system in SPO via the SharePoint Framework. The first draft of requirements can be found here: https://wreim.sharepoint.com/:w:/s/InformationTechnology/ESi5XLdbAgFDtGistuwZJvYB4ggGvfvAbM_bozu1sp-OFA?e=wfEN5f

Deadline: April 16, 2019

Tags: knowledge, management, SPFX, spo

THIS JOB HAS BEEN FILLED, NO MORE APPLICATIONS WILL BE ACCEPTED, THANKS.

We are looking for feedback on trying our Windows desktop application, a tool that exports data from SharePoint lists to SQL Server tables. For details about the product visit: http://www.axioworks.com/sqlist/ In particular, we need you to do the following:

1. download the free trial of our application from here: http://www.axioworks.com/sqlist/try-sqlist/;
2. install it on your machine;
3. export 4-5 (or as many as you like) SharePoint lists to a SQL Server database;
4. provide feedback on the whole experience.

Important: We don’t want you to spend more than 30 mins on steps 1 to 3. If you encounter difficulties and cannot complete all three steps in that time, we want to know why in your feedback. Assuming another 30 mins to write your feedback, the whole job should not take more than an hour from beginning to end. Note that we are not being strict on the time you spend on this job because we want to save money, but rather because we want to know whether the experience was smooth and you were able to evaluate our product in that period of time. Here is a guideline of what we’d like in the feedback:

• In a few words, what did you think of the entire process, from downloading and installing the trial to running the product?
• A summary of the environment you tested on (the version of SharePoint and SQL, types of authentication used);
• How many lists/document libraries did you export and how many items did each contain?
• Were there any things you found confusing?
• Did anything go wrong at any stage? If so, what was it and how did you get past it?
• Did you find our documentation helpful?

Positive and negative feedback will be appreciated, so be honest. We are interested in any comments and suggestions you think are useful. Note: we will not provide a SharePoint site of SQL Server database for you to use; you will need to use your own (as a real user of ours would do – SharePoint On Prem and Online, and SQL On Prem and Azure are supported). We expect you to be knowledgeable in both. Disclaimer: Send your feedback to [email protected] You must keep the feedback confidential and not circulate it or make it available to anyone.

Budget: 150.00 USD - 150.00 USD

Expected delivery: 7 days

Deadline: February 28, 2019

Tags: SharePoint, SQL server

We are looking for a developer to create a straightforward app using PowerApps and possibly a little bit of MS Flow. The app will replace a visitor sign in book that is currently at an unmanned reception area. The app must be Android and iOS compatible but will mainly be used on a tablet. Information required from the visitor:

• Welcome screen – branded skin
• Name (mandatory)
• Company
• Vehicle Registration
• Person Visiting (mandatory) – alert sent to a staff member to advise them that a visitor is waiting? Either by text or email using MS Flow? Staff have iOS phones.
• Check In Time (mandatory)
• Departure Time (mandatory)

Once this information has been entered the visitor will be shown a Visitor Health and Safety Notice that they must read and sign/or a submit button. Once this has been completed a visitor pass can be printed out with the visitor name and other details. If printing isn’t possible using PowerApps, is it possible for the app to generate a visitor number that will then correspond to a pre-printed stock of badges that the visitor can choose from? Alternatively, is it possible to have pre-printed badges with barcodes that can be scanned into the app to register the badge number and complete a quick check out? A daily log of all visitors and their information should be able to be viewed for fire evacuation purposes. All information will be stored on the tablet and cleared on a daily basis. We don’t require to store lots of visitor data as it means we have to account for it and go through more data compliance procedures. We use Office 365 and SharePoint. I look forward to proposals as we are eager to implement an electronic sign in process.

Expected delivery: 30 days

Deadline: March 7, 2019

I need some help figuring out how to do something. I’m working on a solution for inviting external users to SharePoint sites and adding them to security groups. I am using PnP and Power Shell to run the commands. It’s starts by the my client adding a record (the new external user) to a SharePoint list which triggers a flow. The flow does an HTTP Request to an Azure function that sends out an invitation. This works well and is working fine. The tricky part is that if you add the external user to a security group _before_ the user actually _accepts_ the invitation then it will send them a second invite. We don’t want this. I have code that can be run via power shell that will show that the user does not exist _until_ the user accepts the invitation. So what I want to do is after the invitation is sent, we need to check say every 30 minutes to see if the user has accepted the invitation by running the power shell code. Once that happens, it trigger the second part (another Azure Function) that adds the external user to the appropriate security groups.

Budget: 100.00 USD - 300.00 USD

Expected delivery: 5 days

Tags: Azure Function, Timer