如何使用逻辑应用程序更新SharePoint网站内的Excel文件内容 [英] How do I update excel file content which is inside SharePoint site using logic app

问题描述

我有一个SharePoint网站，我有一个excel文件，我希望在间隔后使用逻辑应用程序将一行附加到该excel文件中。

我想知道哪个连接器我应该使用我试过使用Sharepoint 连接器，但我无法理解如何追加行。

我从HTTP连接器的一个API输出中将行数据放入json数组。

json输入是 -

[

  {

" id"：" 2"，
" name"：" a"，&
" address"："dmk"，

" log"："low"" b $ b }，

  {

" id"：" 3"，
" name"：" b"，$
" address"：" dmk"，

" log"："high">
 }

]

Excel文件就像包含现有数据的标题一样 -

id 姓名地址日志 

1 一个        DMK     低

我想将json数据作为一行附加到我的sharepoint网站上的excel文件中。 

---

SE

解决方案

您需要使用excel在线连接器  https://docs.microsoft.com/en-us/azure/connectors/connectors-create- api-excel

请阅读此论坛  https://social.msdn.microsoft.com/论坛/ EN-US / 779d2f9c-123D-475d-897c-da204d3d4d94 /传送表的元数据从 - 天青-SQL数据库到SharePoint的使用逻辑的应用程序库？论坛= azurelogicapps

I have SharePoint site inside that I have one excel file I want to append a row into that excel file using logic app after interval.

I wonder which connector i should use I tried using Sharepoint  connector but I'm unable to understand how to append row.

I have row data into json array from one API output from HTTP connector .

json input is -

[
 {
"id":"2",
"name":"a",
"address":"dmk",
"log":"low"
 },
 {
"id":"3",
"name":"b",
"address":"dmk",
"log":"high"
 }
]

Excel file is like having headers including existing data -

id  name address log 

1  a        dmk      low

I want to append json data as a row to excel file which is there in my sharepoint site. 

---

SE

解决方案

you need to use excel online connector https://docs.microsoft.com/en-us/azure/connectors/connectors-create-api-excel

Please read this forum too https://social.msdn.microsoft.com/Forums/en-US/779d2f9c-123d-475d-897c-da204d3d4d94/transfer-table-metadata-from-azure-sql-database-to-sharepoint-library-using-logic-apps?forum=azurelogicapps

这篇关于如何使用逻辑应用程序更新SharePoint网站内的Excel文件内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！