從 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,請參閱 Introduction to 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

    注意

    閘道和內部部署連接只可在使用者的預設環境中建立與使用。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.