sharepoint online – Programmatically remove external user access to a folder / document in a document library

Here is the script. Not tested You can also add subpages in another foreach.

string WebUrl = "";
string UserLoginName = "i: 0 # .f | membership |";

public static void RemoveUserPermissions (String SiteUrl, String UserLoginName)
using (var ctx = new ClientContext (SiteUrl))
var Web = ctx.Web;
var Lists = Web.Lists;
ctx.Load (ctx.Web);
ctx.Load (lists);
ctx.ExecuteQuery ();

Console.WriteLine (string.Format ("Remove user {0} from site: {1}", UserLoginName, SiteUrl));
var User = Web.SiteUsers.GetByLoginName (UserLoginName);
Web.RoleAssignments.GetByPrincipal (User) .DeleteObject ();
ctx.ExecuteQuery ();

foreach (var list in lists)
var UniqueListPerm = List.HasUniqueRoleAssignments;
ctx.Load (UniqueListPerm);
ctx.ExecuteQuery ();
if (UniqueListPerm)
Console.WriteLine (string.Format ("Remove a user from the list or library: {0}", UserLoginName, List.Title));
List.RoleAssignments.GetByPrincipal (User) .DeleteObject ();
ctx.ExecuteQuery ();

CamlQuery camlQuery = new CamlQuery ();
camlQuery.ViewXml = "";

var Items = list.GetItems (camlQuery);
ctx.Load (elements);
ctx.ExecuteQuery ();
foreach (var article in articles)
var UniqueItemPerm = Item.HasUniqueRoleAssignments;
ctx.Load (UniqueItemPerm);
ctx.ExecuteQuery ();

if (UniqueItemPerm)
Console.WriteLine (string.Format ("Removing a user from library {0} and item: {1}", List.Title, Item.Id));
Item.RoleAssignments.GetByPrincipal (User) .DeleteObject ();
ctx.ExecuteQuery ();

Is it possible to manage a SharePoint Online site through PnP templates in Source Control with automated deployments?

This is a pretty common workflow that I've used in several projects. The templates can be safely redeployed to the same website. However, look for templates that upgrade existing websites. The templates will not remove anything. Therefore, you may need to supplement the upgrade process with some PNP PowerShell if you make changes (rather than adding stuff, as the template will do).

I had a project that used the templates in one version, but that was a bit restrictive. Instead, I had to move the templates for another project to the blob store, and an Azure Automatio runbook, which was essentially a powershell script that downloaded the template and applied it with Apply-PnPProvisioningTemplate.

That way, we could add parameters to the script that were set at runtime through the runbook.

The beauty of this approach is that we can attach the runbook via flow to a SharePoint list that manages the websites to which the template will be applied.

The easiest ways to make money online – other ways to make money

earn excel

Many people think that they want to start their own business, but they take their feet back because of high investment. Whether you're setting up a large showroom, a manufacturing company, or just a small shop, you'll need a good sum of money to invest in rent, rental, buying products, workers, and so on.

However, today in this Internet era, you do not need everyone to start your business. All you need is a laptop with a good internet connection and some basic computer and Internet skills. You have to think like? Here I have an answer to your question. I think you need to know about Drop Shipping. If not, then stay with this blog post until the end. I'll take you from the bottom of the process of starting a drop shipping business.

This business model does not require a lot of money, but if you are creative, you will succeed. Drop Shipping is a very popular business model in the US, but it is a new concept here in India. Many people earn good money with it. Drop Shipping is booming in India for 4-5 years, so you have good business opportunities here.

What is Drop Shipping?

It is a fulfillment method. Drop Shipping is a business model in which the seller (you) does not have to store any products in your store. You have a contract with a supplier / wholesaler who sends the product directly to the customer instead of you. Is not that great? In this online business, you do not have to maintain inventory, headache stockpiling, no big investments, no tensions.

Basically, you only have to market the product. When you receive an order to send the shipping and ordering details to your Drop Shipping supplier or wholesaler, he will take care of the rest of the process. It's a great way to make money online.

How does it work?

Do we understand that in steps

First, find a product from a supplier, whether it's eBay, Alixpress, or any other drop shipping company.
Now you can find the product you want to sell in your online store. For example, you sell a keyboard for £ 500
Now a customer buys the product from you. He goes to your webshop and buys a product from you.
The next step is that you accept this order and send it to the supplier. You pay 200 € to your supplier.
Now the supplier has the order, which he sends directly to your customer
You are a network. The profit is 500 € – 200 € = 300 €.
What happens here is that you are not just handling one single inventory that you are currently doing, namely marketing the product and winning customers for it. That's all you have to do.

How to start?

Now you know what it is and how it works. The next question is: How do I start? You can also make money online. Here I have a process for you step by step. Follow these steps and you are good to go. Many people stayed here because of the information lake. There is a lot of information you can find on the internet, but most miss you.

1. Find products for sale

The first step in building your online drop shipping business or other business is choosing a niche. Niche is like a category, that is, you select a product category in which you want to do business. There are many categories on the market such as clothing, electronics, appliances, kitchen appliances, cosmetics, etc. Choose any one.

You can not dive into all the niches that end up with a big failure, especially at the beginning. Take an example from Amazon when Amazon started. Amazon was just a website that sold books. Then they slowly analyzed the market needs and started with different categories. Today it is the largest online shopping website in the world.

How do you find the niche that is perfect for you? Here are some tips to help you choose a niche.

Choose the niche according to your interest. If you happen to choose a niche that you are not interested in, you will soon lose interest in the business and lead to failure. So make sure you choose the niche you're interested in.
If you are not clear with your interest and do not get any idea for your niche, do some market research that can assist you with Google. Use the Google Keyword Planner and Google Trends, which are free tools from Google. Search your keyword on your product and see how many people are looking for this product. This will help you in choosing your niche.
You can also check the bestselling products on Amazon.
A selected niche with a product with a higher price. If you sell a product of $ 500 and you only get a profit of $ 200 on another side, assuming you're selling a $ 3000 product, then you have a chance of a high profit margin of more than $ 500 both require the same effort to sell.
Avoid products that are big, because choosing large products will increase your shipping costs and reduce your profit on this product. Also pay attention to the size.

2. How do I find drop shipping wholesalers?

Now it's time to find a trusted dropshipping provider, or a total seller or manufacturer who can deliver dropshipment to you. There are many who can do drop shipping, but you need to find the most reliable and reliable drop shipper you can trust. After all, you will not be touched to see what product he delivers to your customer.

If it is not reliable and sends a broken product to your customer, it definitely affects your business. Here are a few things to keep in mind when choosing a drop shipping supplier.

He has a good brand image in the market. Your supplier must have a good image in the market. Here's the point: Do a full background check of your supplier.
Make sure that the product is within 2 or max. 3 days. If it takes more than 3 days, your customer may cancel the order because users can not wait. You have more options in the market.
Do you deliver the product safely? How do you package the product? Which courier services do you use?
Most important point costs. Calculate what price you pay your drop shipper and at what price you sell to your customer so you can make a good profit.
If the supplier has all the qualities I mentioned above, he is the right person to contact.

How do you find

In 2018 there are too many drop shipping companies in India. But still, you do not get any, then I have some methods to look for.

Help from Google to find. Just go to and search for the keyword "Drop Shipping companies in India" or "Drop Shippers in India". You get a list of many companies.
Another way to find directories. You get a list of drop shippers in directories like HotHaat, India mart, Just dial etc …. You can also search for directories on Google.
On Facebook, Instagram and Google, you'll find numerous ads for drop shipping companies. This way you will also find a drop shipper for you.
You can also find Drop Shipper through online shopping websites like Amazon, Flip Kart, eBayetc and so on. Go to seller account and find contact information. Or the link to the website.
Reference, this is the best option to find a supplier. Contact someone who knows or has done so.

3. Where to sell?

There are many ways you can sell your products online. But all options are not for everyone. If you are new to this industry and do not want to invest, you have another option. If you have enough money and want to invest, you have other options.

If you do not want to invest money, you can sell on unorganized marketplaces, eg.

Facebook – Yes, you can sell products on Facebook and earn money. There are three ways to sell on Facebook.
Buying and Selling Facebook Groups – On Facebook, there are too many groups where you can sell your products. Just join these buying and selling groups and add your products. If you are interested, you will contact you.
The second option for sale on Facebook is the Facebook page. You can add products to Facebook pages where you can add your products, sell them, and order people there.
The third option is my personal favorite Facebook marketplace. It is something like Amazon and other ecommerce websites. It's the best option on Facebook to sell your products. Get more orders than Facebook groups and pages here.
You can also sell on sites like OLX and faster. You can list your products on these sites for free, but with a limit. When you reach your free limit, you will be asked to pay for the listing. So I can not recommend you, but you can use the free offers.
If you have some money to invest, I recommend that you choose these options.

Create your Shopify shop. Shopify is a platform where you can create and sell your ecommerce store, whatever you want to customize your store. They also provide you with some tools like analytics and much more. However, this is not free, it costs a monthly subscription. Shopify have three levels
Basic Shopify – $ 29 per month
Shopify – 79 USD per month
Advanced Shopify – $ 299 per month
You can start with the baseline and as you get bigger, you can upgrade your plane to an advanced flight.

Start your own ecommerce website with your brand name. If you want to build your brand value in the market, this is the best way. But here you need some money to invest in a domain name, a hosting plane and many other things.
4. Create a plan

Yes, you need a plane and a strategy to focus on your business and your customers. Every company needs a plane and without a plan they fail. In this industry you can not survive without a great airplane. For example, you need to know exactly how to re-engage your customer, how to get it back into your webshop, how to create a brand, how to manage your time, and how to grab the attention of your target customers.

It's very hard to create your own brand, it's hard to get the first customer, and it's difficult to retain the previous customer. Run an airplane by stopping it for a while. Analyze if it works or not? If you do not recognize the vulnerabilities, try to fix them and create another one, you can succeed.

Advantages and Disadvantages of Drop Shipping

Every business has always something good and something bad. You must have known about it. Here I would like to point out some advantages and disadvantages of Drop Shipping.


Low startup costs
Simple business method
Minimal risk factor
No storage required
No special location required. You can start anywhere.

It is not easy to find a reliable supplier.
No order to pack and ship
Hard to tie customers
High competition
Small amount
5. Take action

Now, assuming you've chosen your niche, you'll get your supplier, the platform you want to sell, and you'll have a plane ready for your business. Now it's time to act. Start today after reading this blog post. Do not think too much. You will learn how to handle it day by day when you start.


SP 2013 Migration to O365 (Online Sharepoint)


In SP 2013, we created an application using the workflow of Infopath & SharePoint Designer 2013. We need to migrate them to O365 using metalogix.

I suggested starting the migration instead of transforming Infopath into PowerApps and Workflow in Designer. After migrating the applications, it stays the same in O365. I chose it because we need to restore the content with metadata.

Can you tell me your thoughts or a better solution / approach that we can suggest here?


Forex is an online venture market – Discussions & Help

Forex is an online venture market. Waste is a compelling factor in forex. The difference between asking and offering or buying and offering the price is called a spread. There are two types of spread frameworks provided by the forex broker. They are variable and fixed. The low scattering is crucial for the scalping. This allows the trader to gain benefits and significantly influence his trading design. My broker AAFX offers the lowest spread offer to gain more profits from trading.

sharepoint online – Search the content search web part search template to aggregate tasks

In a site collection, I have about 4 to-do lists, each set up on separate subsites. At the root level, I use a Content Search Web Part, and queries show tasks from these 4 to-do lists to show aggregated tasks in the Web Part. Here's the query I'm using: Path: "https: // / sites /"ContentTypeId: 0x0108 * -RefinableString01: Completed

RefineableString01 is an associated managed property that helps me display unfinished tasks (task status except completed). The challenge now is to show this web part as close as possible to an actual to-do list view that has the name, due date, status, and description as task headers / columns in CSWP, which I have not worked on at all.

Can someone help me set up the task aggregation tabular view using a custom template? For your information, I have already set up managed properties (mapping appropriate crawled properties to the managed properties called refining string, etc.) for description, task status, and due date.

Also, in CSWP, I'd like to display a custom selection column called Investor (site column) along with other base columns. I'm waiting for her to be crawled. Once crawled, I'll set up a managed property for it.

Can someone please help me with the cswp display template that i can use, thanks in advance.

graphics3d – Where to save exported files when using Mathematica Online?

I want to print some Mathematica-generated 3D polyhedra, but I can not figure out how to use the & # 39; Export & # 39; generated files are downloaded. For example:

export["myTestModel.stl", PolyhedronData["Dodecahedron"]

gives as output


What looks like a success! However, the result file is not visible in my "Cloud Files" directory. Where does Mathematica Online store the exported files?

SharePoint Online. Change the file contents with the Remote Event Receiver

I have to check the content of an Excel file uploaded to SharePoint. If the columns do not follow any order, switch them to get the required order.

I thought about a remote event receiver and hosted it in Azure.

I do not know if it's possible to retrieve the SPFile with the remote event receiver and download it to a local computer, modify the file as needed, and upload it back to SharePoint.

Is that a good approach? Can I do it without downloading it?

I searched but did not see how I could change the contents of a file hosted in a Sharepoint library.

PC problem solving and repair for $ 15 online

  • PC Problem Solving and Repair Online

I can assist you with most IT issues related to problems with setting up Word mail problems, installing software, and removing viruses

I will try to help as soon as possible, and if the problem is not solved, only a small fee will be charged for the time spent.

I have 16 years experience in IT services and am confident that I can help you with that

This service has no reviews – order and let the first!

$fifteenIn stock