c# - 获取不带图表的 SharePoint 在线列表元数据
问题描述
有没有办法使用 Powershell(最好)或 C# 获取特定 SharePoint 列表的字段名称和类型?这是我尝试过的。它挂起或显示 Get-PnPList :不支持查询表达式“Param_0.Fields.ElementType”。我们不允许使用 Graph。
#Set Parameters
$SiteURL = "https://MyCompany.sharepoint.com/teams-and-projects/dev"
$ListName = "TechDevWorkRequests"
#Connect to SharePoint Online site
Connect-PnPOnline -Url $SiteURL -UseWebLogin
Get-PnPList -Identity Lists/$ListName -Includes Fields.ElementType
Invoke-PnPQuery
解决方案
这与 if 语句不同。
#Set Parameters
$SiteURL = https://myCompany.sharepoint.com/teams-and-projects/dev
$ListName = "TechDevWorkRequests"
#Connect to SharePoint Online site
Connect-PnPOnline -Url $SiteURL #-UseWebLogin
$columns = Get-PnPField -List $ListName
foreach($column in $columns)
{
if ($column.Group -eq "Custom Columns" -and $column.Hidden -eq "False")
#if statement doesn’t filter output. Not sure why.
{
Write-Host "Column Title :" $column.Title
Write-Host "Description :" $column.Description
Write-Host "Group Name :" $column.Group
Write-Host "Hidden? :" $column.Hidden
Write-Host "Internal Name :" $column.InternalName
Write-Host "Static Name :" $column.StaticName
Write-Host "Scope :" $column.Scope
Write-Host "Type :" $column.TypeDisplayName
Write-Host "Schema XML :" $column.SchemaXml
Write-Host "Is Required? :" $column.Required
Write-Host "Is read only? :" $column.ReadOnlyField
Write-Host "Unique? :" $column.EnforceUniqueValues
Write-Host "-------------------------------------------"
}
}
推荐阅读
- java - 我有一个用 C/C++ 编写的应用程序,每次系统启动/重新启动时都需要运行。实现这一目标的最简单方法是什么?
- java - spring boot web binding时如何拦截报错信息?
- c# - 使用 Linq to XML 遍历 XML 文件未按预期工作
- function - 是否可以在 ZSH 中动态定义函数?
- typescript - 如何模拟外部模块
- python - 在 python 中打印循环时如何获得唯一的随机输出?
- wireguard - Wireguard VPN 不接收来自服务器的数据
- excel - 为什么 .autoFill 会导致 Excel 崩溃?
- javascript - 如何通过子属性在猫鼬中查找文件?
- sql - 如何使用 SQL 从前 n 行查询?