如何使用PowerApps更新两个SP列表项目

发布于 2025-02-02 03:24:20 字数 382 浏览 3 评论 0原文

我们想将2个SharePoint列表连接到一个PowerApps画廊。因此，以SP列表1的形式以表1中的形式编辑，然后用SP列表2进行编辑。title列表1和列表2中的列是相同的。

画廊列表显示“ Gallery.ceed”过滤器是：

SortByColumns(
  Filter(
    [@BICT_DATA_KLANTEN_MAIN]; 
    StartsWith(
      Title; 
      ZOEKBALK_BICT_DATA_MAIN.Text
    )
  ); 
  "Title"; 
  If(
    SortDescending1; 
    Descending; 
    Ascending
  )
)

原文

We would like to connect 2 Sharepoint lists to one PowerApps gallery. So editing in in Form 1 with SP list 1, and then editing in Form 2 with SP list 2. The Title column in List 1 and List 2 are the same.

The gallery list is showing "Gallery.Selected" the filter is:

SortByColumns(
  Filter(
    [@BICT_DATA_KLANTEN_MAIN]; 
    StartsWith(
      Title; 
      ZOEKBALK_BICT_DATA_MAIN.Text
    )
  ); 
  "Title"; 
  If(
    SortDescending1; 
    Descending; 
    Ascending
  )
)

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

寒江雪… 2025-02-09 03:24:20

我很难简洁地回答这个问题。有很多因素在起作用。要将两个SharePoint列表连接到单个画廊控件，请将列表组合到一个集合中。

示例：

ClearCollect(colCombined,
    SPList1,
    SPList2
)

将添加到项目画廊的属性。
但这将添加两个SP列表中的所有记录。
您可能由于不必要的列，数据大小等而不想要此。

考虑到您提到的表单控制的形式，请对List1和List2之间的关系进行一些思考。我想您想要一个标题 - 详细信息 - 型的关系。

就个人而言，我从SharePoint列表中删除标题列，然后使用RecordGuid列。它对我和其他来维护应用程序的人更为直观。 “标题”没有说“与列表相关联需要的ID密钥”。
研究powerApps guid guid（） a>函数。创建新记录时，您需要填充两个列表的recordguid列。
创建标题/详细信息应用程序类型的类型涉及1-2小时的差异。从UI到SharePoint最佳实践再到PowerFX代码。

也许对您有用...

Its difficult for me to answer this question succinctly. There are SO many factors at play. To connect two Sharepoint lists to a single Gallery control, combine the lists into a single Collection.

Example:

ClearCollect(colCombined,
    SPList1,
    SPList2
)

Add colCombined to the Items property of the Gallery.
But this will add ALL records from both SP Lists.
You likely don't want this because of unnecessary columns, size of data, etc.

Considering the Form controls you mentioned, put some thought into the relationships between List1 and List2. I'm imagining you want a Header-Details-type of relationship.

Personally, I remove the Title column from Sharepoint lists then use a recordGUID column. Its more intuitive for me and others that come after me to maintain the app. "Title" says nothing about "ID key needed to relate lists".
Research the PowerApps GUID() function. You'll want to populate the recordGUID column of both lists when creating new records.
There is a 1-2hr class worth of nuance involved in creating a Header/Details type of application. From the UI to the Sharepoint best practices to the PowerFX code.

Maybe useful for you...