Jump to a Section

Overview

Basic Auth

Step-by-step:

  1. Log into remote IP and open start menu.
  2. Open IIS and select “Sharepoint Web Services”.
  3. Inside Sharepoint Web Services, select “Authentication”.
  4. Select “Basic Authentication” and set status to “Enabled”.

And you’re done! Basic auth should now be enabled.

    Events

    • New Document

      Start Flo when a new Document is created

    • New Item

      Monitors SharePoint for a new item to be created in a specific list.

      Options

      • Your SharePoint Lists (dropdown): a list of all your SharePoint lists

      Output Fields

      In addition to the fields below, many of the fields associated with this card are dynamically generated from SharePoint, and cannot be documented as a result.

      • Item
        • Item ID (text): the unique id of the item contained inside SharePoint
        • Created At (text): the date the item was created at
        • Updated At (text): the time of the most recent update to the item
    • Updated Document

      Starts a Flow when an existing document is updated

      Options

      •  Site Path (text): The location of the site. Found in the URL of the site
      • Your SharePoint Drives (drop down menu): Choose from existing SharePoint drives.

      Output Fields

      • Collections (object): Updates collection of documents within SharePoint
    • Updated Item

      Monitors SharePoint for an updated item in a specific list.

      Options

      • Your SharePoint Lists (dropdown): a list of all your SharePoint lists

      Output Fields

      In addition to the fields below, many of the fields associated with this card are dynamically generated from SharePoint, and cannot be documented as a result.

      • Item
        • Item ID (text): the unique id of the item contained inside SharePoint
        • Created At (text): the date the item was created at
        • Updated At (text): the time of the most recent update to the item

    Actions

    • Create Folder

      Makes a new folder in SharePoint.

      Options

      • Site Path (text): The location of the site. Found in the URL of the site
      • Your SharePoint Drives (drop down menu): select the SharePoint drive you wish to use.

      Input Fields

      • Folder
        • Name (type): the name of the new folder.
        • Parent Folder ID (text): if nested folder.

      Output Fields

      • Folder ID (text): New folder ID.
    • Create Item

      Creates a new item in a SharePoint list.

      Options

      • *Site Path(text): The location of the site. Found in the URL of the site
      • Your SharePoint Lists (drop down menu): Choose from existing lists.
        • Note- this card will not work if there are no existing lists in the SharePoint site.

      Input Fields

      • Item
        • Title (text): description of input field.
        • First Name (text)
        • Number (text): assign a number to the item.

      Output Fields

      • Item ID (text): the item ID for the new item.
    • Create Sharing Link

      Creates a sharing like for a document in SharePoint.

      Options

      • Site Path (text): The location of the site. Found in the URL of the site
      • Your SharePoint Drives (drop down menu): The drives available in that site.

      Input Fields

      • Document
        • Item ID (text): The ID of the document. Can be found by using ‘Search Documents’.
      • Link
        • Type (drop down menu): View, Edit, or Embed- what abilities the receiver of the share link will have.
        • Scope (drop down menu): Anonymous or Organization
          • Anonymous: A folder or document can be shared with an external user via an anonymous link, meaning the person accessing the document can’t be identified by the organization. These guest users are commonly called “anonymous users”. When this option is chosen, your document will be visible to anyone who has access to the link, meaning an external user to whom it was sent to directly can share the link to other external users. Thus, documents containing sensitive data should never be shared this way.
          • Organization: Content can also be shared with authenticated external users, meaning guest users are sent an invitation by email and prompted to sign in using an account from a trusted provider in order to access the content in question. Once the invitation is accepted, they are added to your organization’s directory as an external user, but will only have access to the specific elements you shared with them. If you’ve shared an entire site, they’ll have access to everything in it, so make sure it doesn’t contain sensitive content.

      Output Fields

      • Link (text): The new sharing link for the document.
    • Custom API Action

      This action allows you to make a custom, authenticated HTTP call to the microsoft graph API.

      NOTE: This is not like any of the other Sharepoint cards; this card shows some of what goes on behind the scenes on other cards. If you have no experience working with API calls this may be a challenge, however this card is highly customizable. Good luck, and it may help if you refer to the documentation!

      Options

      • Request Type (dropdown): your available HTTP request methods. There are 5 supported HTTP request methods (sometimes called verbs) in custom API calls:

        • GET: retrieves data from a web server based on your parameters. GET requests a representation of the specified resource, and if successful will receive a 200 OK response message with the requested content. Additional documentation here.

        • POST: sends data to a web server based on your parameters. POST requests include actions like uploading a file. Multiple POST’s may result in a different outcome than a single POST, so you should be cautious about unintentionally sending multiple POST’s. If a POST is successful, you will receive a 200 OK response message. Additional documentation here.

        • PUT: sends data to a location in the web server based on your parameters. PUT requests include actions like uploading a file. The difference between a PUT and POST is that PUT is idempotent, meaning that the result of a single successful PUT is the same as many identical PUT’s. If a PUT is successful, you will receive a 200 response message (usually 201 or 204). Additional documentation here.

        • PATCH: applies partial modifications to a resource on a web server based on your parameters. PATCH is not idempotent, meaning that the result of multiple PATCH’s could have unintended consequences. If a PUT is successful, you will receive a 200 response message (usually 204). Additional documentation here.

        • DELETE: deletes the specified resource from the web server based on your parameters (if the resource exists). If a DELETE is successful, you will receive a 200 OK response message. Additional documentation here.

      Input Data

      • Relative URL (text): the address on the web server you are attempting to interact with. Relative URL means that you don’t have to explicitly specify the protocol at the beginning of the URL (such as “http://“). This suggests to the web server that the interaction is occurring on the server (in this instance).

        Example: sites/<baseUrl>.sharepoint.com,<SomeID>,<ID>/lists/<ListID>/items
      • Query (object or text): JSON object that determines the action taken at the URL.

        Example: {"name":"something-urgent"}
      • Headers (object): JSON that determines the content type of the request. This will usually be a replica of the example below.

        Example: {"Content-type":"application/json"}

      Output Data

      • Status Code (Number): the success or failure of your HTTP request. Here is a list of all status codes.

      • Headers (object): a more detailed context for the response/status code that doesn’t relate to the output body. Not all headers that appear in a response header are response headers, meaning that some are unlikely to be useful to you.

      The response headers are dependent on the HTTP request you choose in options.

      • Body (object): depending on the HTTP request you chose in Options, you may receive some data back. That data, such as the data from a GET request, will be contained in this Body object. ))
    • Delete Item

      Deletes and item from a SharePoint list.

      Options

      •  S*ite Path(text): The location of the site. Found in the URL of the site
      • Your SharePoint Lists (drop down menu): Choose from existing lists.
        • Note- this card will not work if there are no existing lists in the SharePoint site.

      Input Fields

      • Delete By
        • Item ID (text): The ID of the Item to be deleted. Can be found by using ‘Search Documents’.

      Output Fields

      • There are no output fields for this card. 
    • Download Document

      Downloads a document from SharePoint onto the designer.

      Options

      •  Site Path (text): The location of the site. Found in the URL of the site
      • Your SharePoint Drives (drop down menu): Choose from existing drives.

      Input Fields

      • File ID (text): The ID of the document to be downloaded. Can be found by using ‘Search Document Library’.

      Output Fields

      • File Content (file): The downloaded file.
    • Read Document

      Uses an Item ID to get information on a document in SharePoint.

      Options

      •  Site Path (text): The location of the site. Found in the URL of the site
        • if the link was: https:/testdeveloper.sharepoint.com/sites/Testsite/innersite/SitePages/Home.aspx for the site called ‘Innersite’, the site path would be the bolded section above (slashes included before and after), which is all the information after ‘sharepoint.com’ up to ‘SitePages…’.
      • Document Library (drop down menu): Choose from existing document libraries.

      Input Fields

      • Item
        • Item ID (text): The Document ID. Can be found by using ‘Search Document Library’.

      Output Fields

      • Document
        • Name (text): The name of the document.
        • Created By ID (text): The ID of the user who created the document.
        • Created By Name (text): The name of the user who created the document.
        • Created At (text): The date the document was created.
        • Updated By ID (text): The ID of the user who updated the document.
        • Updated By Name (text): The name of the user who updated the document.
        • Updated At (text): The date the document was updated.
        • Size (text): The size of the document file.
        • URL (text): The URL of the document.
    • Read Item

      Using an Item ID, returns information about an Item.

      Options

      •  Site Path (text): The location of the site. Found in the URL of the site
      • Your SharePoint Lists (drop down menu): Choose from existing SharePoint lists.

      Input Fields

      • Item
        • Item ID (text): The Item ID. Can be found by using ‘Search Document Library’.

      Output Fields

      • Document
        • Title (text): The title of the item.
        • First Name (text): The first name associated with the item.
        • Number (text): The number associated with the item.
        • Created At (text): The date the item was created.
        • Updated At (text): The date the item was updated.
    • Read List

      Reads all items from a list in SharePoint.

      Options

      •  Site Path (text): The location of the site. Found in the URL of the site
      • Your SharePoint Lists (drop down menu): Choose from existing SharePoint lists.

      Input Fields

      • No inputs.

      Output Fields

      • List
        • Item
          • Title (text): The title of the item.
          • First Name (text): The first name associated with the item.
          • Number (text): The number associated with the item.
          • Person (T/F)
          • Date (text)
          • Item ID (text)
          • Created At (text): The date the item was created.
          • Updated At (text): The date the item was updated.
    • Search Document List

      Search Document List in Sharepoint.

      • Options

        • Site Path: The path to the site in SharePoint being accessed.

          Example: /sites/YourSite
        • Result Set: Specifies how many documents will be returned.

          • First file - Will only return the first file found.

          • All files - Will return all files found.

        • Document List: The folder in your Sharepoint site that will be searched.

      Input Fields

      • Search
        • Query (string) - Query text to be used to search for items. This may matched across several fields including filename, metadata, and file content.

      Output Fields

      • Item
        • File ID (string) - The ID of the file.
        • Type (string) - The type of the file.
        • Name (string) - The name of the file.
        • Parent Item ID (string) - The Parent Item ID.
    • Search List

      Searches for a list item by using an input.

      Options

      •  Site Path (text): The location of the site. Found in the URL of the site
      • Your SharePoint Lists (drop down menu): Choose from existing SharePoint lists.
      • Field (drop down menu): Which aspect of the item you are searching with.
      • Operator (drop down menu): == Equal to, > Greater than, < Less than, >= Greater than or equal to, <= Less than or equal to, and != Not equal to. Choose the operator that will be used for the search. ie: If the Number field and the == operator are chosen, then the designer will search for items with a number equal to the input number.

      Input Fields

      • Keyword (text): The input value matching the chosen field type which will be used in the search.

      Output Fields

      • List
        • Item
          • Title (text): The title of the item.
          • First Name (text): The first name associated with the item.
          • Number (text): The number associated with the item.
          • Person (T/F)
          • Date (text)
          • Item ID (text)
          • Created At (text): The date the item was created.
          • Updated At (text): The date the item was updated.
    • Update Item

      Updates stored information on an Item in SharePoint.

      Options

      •  Site Path (text): The location of the site. Found in the URL of the site
      • Your SharePoint Lists (drop down menu): Choose from existing SharePoint lists.

      Input Fields

      • Update By
        • Item ID (text): The identifier for the item. Can be found by using ‘Search Document Library’.
      • Item
        • Title (text): The updated title for the item.
        • First Name (text): The updated First Name associated with the item.
    • Upload Document

      Uploads a document onto the Designer.

      Options

      •  Site Path (text): The location of the site. Found in the URL of the site
      • Your SharePoint Drives (drop down menu): Choose from existing SharePoint drives.

      Input Fields

      • Input
        • Parent Folder ID _(text) _The Parent Folder the document is in.
        • File Name _(text) _The name of the file.
        • File Content (file)

      Output Fields

      • Output
        • File ID _(text) _The ID of the document within the Designer.
        • File Name _(text) _The file name within the Designer.