创建从 PowerApps 到 SharePoint 的连接Create a connection to SharePoint from PowerApps

创建到 SharePoint Online 或本地 SharePoint 的连接,以便自动生成应用或从零构建应用。Create a connection to either SharePoint Online or on-premises SharePoint so that you can generate an app automatically or build one from scratch.

如果不熟悉 PowerApps,请参阅 PowerApps 简介If you're unfamiliar with PowerApps, see Introduction to PowerApps.

截至本文,PowerApps 支持自定义列表,但不支持自定义库。As of this writing, PowerApps supports custom lists but not libraries. 此外,还可以在某些类型的列(例如选项图片)中显示数据,但无法更新该数据。In addition, you can show data in some types of columns, such as Choice and Picture, but you can't update that data. 有关详细信息,请参阅 已知问题For more information, see Known issues.

指定 SharePoint 连接Specify a SharePoint connection

  1. 如果还未注册,请 注册 PowerAppsIf you haven't already signed up, sign up for PowerApps.
  2. 使用注册所用的同一凭据登录到 powerapps.comSign in to powerapps.com using the same credentials that you used to sign up.
  3. 在左侧导航栏中,单击或点击“管理”,然后单击或点击“连接”。In the left navigation bar, click or tap Manage, and then click or tap Connections.

    “文件”菜单上的“新建”选项

  4. 在右上角附近,单击或点击“新建连接”。Near the upper-right corner, click or tap New connection.

    新建连接按钮

  5. 在连接列表中,单击或点击“SharePoint”。In the list of connections, click or tap SharePoint.

    添加 SharePoint 连接

  6. 请按照本主题后面出现的任一过程中的步骤操作:Follow the steps in either of these procedures, which appear later in this topic:

连接到 SharePoint Online 站点Connect to a SharePoint Online site

  1. 单击或点击“直接连接(云服务)”,然后单击或点击“添加连接”。Click or tap Connect directly (cloud services), and then click or tap Add connection.

    选择 SharePoint Online

  2. 转到本主题末尾的 后续步骤Go to Next steps at the end of this topic.

连接到本地 SharePoint 站点Connect to an on-premises SharePoint site

  1. 单击或点击“使用本地数据网关连接”。Click or tap Connect using on-premises data gateway.

    选择本地 SharePoint

    注意:只能在用户的默认环境中创建和使用网关和本地连接。Note: Gateways and on-premises connections can only be created and used in the user's default environment.

  2. 指定用户名和密码。Specify your user name and your password.

    如果凭据包括域名,则将其指定为“域\别名”。If your credentials include a domain name, specify it as Domain\Alias.

    指定凭据

  3. 如果未安装本地数据网关,则请 安装,然后单击或点击图标来刷新网关列表。If you don't have an on-premises data gateway installed, install one, and then click or tap the icon to refresh the list of gateways.

    安装网关

  4. 在“选择网关”下,单击或点击要使用的网关,然后单击或者点击“添加连接”。Under Choose a gateway, click or tap the gateway that you want to use, and then click or tap Add connection.

    选择网关

后续步骤Next steps

  • 基于指定的列表 自动生成应用Generate an app automatically based on a list that you specify. 默认情况下,应用包含三个屏幕,分别用于浏览记录、显示有关单个记录的详细信息以及创建或更新记录。The app will have three screens by default: one each for browsing records, displaying details about a single record, and creating or updating a record.
  • 从零开始构建应用Build an app from scratch. 本主题针对 Excel 编写,但原则同样适用于 SharePoint。This topic was written for Excel, but the same principles apply to SharePoint.