SharePoint Online-Excel工作表中的自动完成字段 [英] SharePoint Online - Autocomplete fields from Excel Sheet
问题描述
I working on a solution here which may or may not be possible with SharePoint Online (365)
我有一个很大的excel列表(975行)，其中包含以下列:学生ID，姓氏，名字，全名，年级，表格，房屋，子学校
I have a large excel list (975 lines) of students containing columns: student ID, Surname, First Name, Full Name, Year Level, Form, House, SubSchool
这里要求的是将电子表格导入到SharePoint中，这可以完成，然后创建一个新的文档集内容类型，称为学生".包含电子表格中的所有列名称.此后，创建一个新的文档库，添加 内容类型转换为库，这就是我遇到的问题...要求的是以下内容；
What is requested here is to import the spreadsheet into SharePoint which can be done, then create a new document set content type called "Student" containing all columns names from the spreadsheet. After this a new document library is created, added content type to library and this is where I get stuck... what is requested is the following;
- Be able to select a students name either typing or using a people picker when creating a new document set (student), and all the other fields listed above are populated automatically FROM the spreadsheet list that was imported into SharePoint previously.
The other half of this is that they would like to update this spreadsheet every year so that the data in the speadsheet will change and therefore the information in SharePoint will change as well.
有没有人曾经尝试过在SharePoint Online中实现这样的目标?
Has any one tried to achieve anything like this before in SharePoint online?
干杯
推荐答案
我们可以为电子表格列表创建工作流程，并使用更新列表项"在新列表中更新值的操作.
We can create a workflow for spreadsheet list, and use "Update List Item" action to update value in new list.
以下文章供您参考:
或者，如果您可以编写代码，我们可以使用客户端对象模型(C#)来实现.
Or if you can write code, we can use Client Side Object Model(C#) to achieve it.
最好的问候，
这篇关于SharePoint Online-Excel工作表中的自动完成字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
