Mục lục bài viết
Cập Nhật: 2021-12-11 02:39:10,You Cần kiến thức và kỹ năng về PowerApps connect two SharePoint lists. Bạn trọn vẹn có thể lại Thảo luận ở cuối bài để Mình được tương hỗ.
In Power Apps it is possible to have multiple SharePoint list forms on one lists custom form.
Tóm lược đại ý quan trọng trong bài
Table of Contents
I created two SharePoint lists. With a lot of imagination I called them list 1 and list 2.
When I create a new item in list 1 I want to create an new item in both lists. When I edit an item in list 1 I want to edit the items in both lists.
If you want to use this pattern in a normal canvas app that isnt a custom form then just add the forms as described in the Microsoft documentation about forms in Power Apps.
Using the Power apps menu option on list 1, I created a custom form with Power Apps that looks like this.
Multiple SharePoint list form
The Orange form is the one that writes to list 1 and the green form writes to list 2. The first form is added by Power apps, the second one I had to add to the same screen. With a bit of resizing of the app it isnt too difficult to do.
Now when I set the title of both forms to item 1 and hit the save button
Only the item in the first form is saved to list 1. List 2 is not updated. So even though I have Multiple SharePoint list form only one of them is really used.
My second form is also not reset back to empty values. We will need to do some work here to make it all work as expected. Multiple SharePoint list forms may not be that easy.
First of all you could consider other data update methods as I described in Patch, SubmitForm and Update. However this time I will just use the Submitform and other form operations.
First of all we need to have a look at a number of pieces of code in the form that will need to be updated.
The code that we need to consider is:
The OnSave is by default set to:
SubmitForm(SharePointForm1)
To make sure that the item is saved to the second item I will need to update the onSave to tư vấn my additional form. This second form is called Form1
SubmitForm(SharePointForm1);
SubmitForm(Form1)
With this OnSave code the out of the box save button.
The OnEdit is set to
EditForm(SharePointForm1)
You might think that the following code would work, but
EditForm(SharePointForm1);
EditForm(Form1)
you will find only one item is being edited.
So I added the the Item for my green form
First(Filter(List2, Title = DataCardValue1.Text))
And now when I edit an item I get both items to appear. Ok, this example isnt very exciting and quite often you might have to use different fields to link the items in the separate lists.
Just make sure that you have a key field that you can match up in both lists.
Also as the lists may contain more items , you might need to consider setting your indexes on the list columns correctly as multiple SharePoint list forms will hit both lists.
But hey, we now have something that look like a relational Power app form!
The OnCancel is set to
ResetForm(SharePointForm1)
This will need to be updated to
ResetForm(SharePointForm1);
ResetForm(Form1)
The OnEdit is set to
NewForm(SharePointForm1)
This will need to be updated to
NewForm(SharePointForm1);
NewForm(Form1)
The OnView is set to
ViewForm(SharePointForm1)
This will need to be updated to
ViewForm(SharePointForm1);
ViewForm(Form1)
When merging two lists into one I might consider most of the time to create a screen with many controls on it and then use the patch function instead of the forms.
However as a quick solution I could consider the multiple SharePoint list form approach as described in this post.
It doesnt suit all use cases but definitely some.
Like Loading…
– Một số Keyword tìm kiếm nhiều : ” đoạn Clip hướng dẫn PowerApps connect two SharePoint lists tiên tiến và phát triển nhất , Chia Sẻ Link Cập nhật PowerApps connect two SharePoint lists “.
Bạn trọn vẹn có thể để lại phản hồi nếu gặp yếu tố chưa hiểu nghen.
#PowerApps #connect #SharePoint #lists