About cooperation between PowerApps and sharepointList

(0) Share

Report

Posted on by 匿名さん

Since it was displayed in Japanese, I will post it again in English.

Question 1

When the input items in each column of the sharepoint list were changed from free input (text) to selection format, the Datafield on the Form screen of the Power Apps app was newly increased by the number of columns that were changed. I'm an app beginner, but if I change the input format of each item in the sharepoint list column, is it necessary to replace the old and new data fields in the Power Apps app?

Question 2

(1) the editform edit screen when the sharepoint list is displayed in the gallery and

ⅰGallry→Edit field with editform①

(2) the editform edit screen when the sharepoint list is displayed in the data table on the same screen on the screen for editing the field with editform. Is it possible? Is it?

ⅱdatatable→Edit field with editform②

above I would like to be able to access ① for both ⅰ and ⅱ. Is that possible?

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

匿名さん 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Since it was displayed in Japanese, I will post it again in English.
Question 1
When the input items in each column of the sharepoint list were changed from free input (text) to selection format, the Datafield on the Form screen of the Power Apps app was newly increased by the number of columns that were changed. I'm an app beginner, but if I change the input format of each item in the sharepoint list column, is it necessary to replace the old and new data fields in the Power Apps app?
Question 2
(1) the editform edit screen when the sharepoint list is displayed in the gallery and
ⅰGallry→Edit field with editform①
(2) the editform edit screen when the sharepoint list is displayed in the data table on the same screen on the screen for editing the field with editform. Is it possible? Is it?
ⅱdatatable→Edit field with editform②
above I would like to be able to access ① for both ⅰ and ⅱ. Is that possible?
v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @匿名さん ,

For question1, if data source structure is changed, you'd better delete the entire form and then add an Edit form into the App.

For question2, both ways are fine, but only one way you should choose to use in your App, otherwise, it's not logical.

A form can connect to only one data source via its Data Source property and hold the specific item in its Item property. Since Gallery and Data table both have SP list as their data sources, you need to define where the item is selected. However, Data table does not include an OnSelect property not like the Gallery.

Best regards,
匿名さん 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your reply.
Regarding question 2, the SP list of gallery and datatable are the same, and two are displayed in the application due to appearance problems. When you select either gallery or datatable and move to the edit screen of the item, you want to be able to display correctly on the edit screen even if you select either gallery or datatable on one edit screen. You say that datatable does not have an onselect attribute, but it looks like you can select an onselect attribute for each column, but is it not possible to use this onselect attribute for each column in a datatable?
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @匿名さん ,

Columns in Data Table have OnSelect property, but it cannot reference current selected value or record. You can have a Gallery and a Data table on the same screen, but the form on this screen needs to connect to DataTable.Selected in Item property and the form on the other screen needs to connect to Gallery.Selected. OnSelect of Gallery would be Select(Parent);Navigate(Screen2).

In addition, you will need two buttons for submitting each form on the two screens respectively.

Best regards,
匿名さん 9 on at

Like
a
(1)

Report
Copy link

Link copied!

I understand. Thank you very much for teaching me.