SharePointIntegration with multiple screens

(0) Share

Report

Posted on by MI2022

Hi all,

I've been reading some solutions from users with similar issues but for any reason they are not working on my side.

Here is the scenario.

I'm using Microsoft Teams and a List. This list was integrated with Power Apps + Customize Forms. This integration creates automatically the App with the SharePointIntegration and all fields in just 1 form and screen.

What I did was to duplicate the 1st screen into more 2 screens and then remove unwanted form fields.

So I have all fields but split into 3 different screens:

When I click on "+ Add new item" I fill all the fields from the 3 screens:

Then when I click on "Save" at the top only the data filled on the 1st screen is saved.

Then I changed the formula OnSave in the SharePointIntegration to:

SubmitForm(frm_Page1_WorkOrders);SubmitForm(frm_Page2_WorkOrders);SubmitForm(frm_Page3_WorkOrders)
 
Then when I click on "Save" at the top, all data filled was saved but in 3 line items and not on the same item:
 
How can I solve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Pacel1 79 on at

Like (0)

Report

Your issue arises because each SubmitForm action treats the submission as a separate item,

resulting in three distinct items being created instead of a single one.

The solution is to use a hidden form that consolidates all the data from your three screens into one form, which is then submitted as a single item.

For each field in the hidden form, set the Default property to reference the respective control in your three visible forms. For example, if you have a text input on frm_Page1_WorkOrders named txt_WorkOrderName, you can set the corresponding field in the hidden form as:

txt_WorkOrderName.text

And at the end You have to submit only the new created form :)

When You test that all data is recived from Your new Forl, You can hide it :)

Was this reply helpful? Yes No
Pacel1 79 on at

Like (0)

Report
Another solution is to use a single screen and a single form while managing visibility dynamically based on a variable. This approach simplifies the app structure and avoids the complexity of multiple screens and forms. Here’s how to implement it:

Step 1: Initialize a Variable

In the OnStart property of your app (or in the screen’s OnVisible property), initialize a variable to control which fields are visible:

Set(varVisibleProp, 0)

Step 2: Use a Single Form

Add a single form (EditForm) connected to your SharePoint list.

Include all the fields that the user needs to fill in across the "screens."

Set the Visible property of each field based on the variable:

For fields in the first "screen":

If(varVisibleProp = 0, true, false)

For fields in the second "screen"

If(varVisibleProp = 1, true, false)

And so on, for additional "screens."

Step 3: Add a Navigation Button

Add a button to act as a Next/Save button.

Set its OnSelect property to adjust the variable or save the form:

If( varVisibleProp < 2, // Adjust this number to match your final step Set(varVisibleProp, varVisibleProp + 1), SubmitForm(Form1) )

Update the button’s Text property dynamically:

If(varVisibleProp = 2, "Save", "Next")

Was this reply helpful? Yes No
Verified answer

timl 36,391 Super User 2025 Season 2 on at

Like (0)

Report
Hi MI2022

Another option is instead of calling SubmitForm, you can call Patch and reference your 3 forms. The formula you would add to the OnSave of your SharePointIntegration object is:

Patch(YourSharePointListName, Coalesce(SharePointIntegration.Selected, Defaults(YourSharePointListName)), frm_Page1_WorkOrders.Updates, frm_Page2_WorkOrders.Updates, frm_Page3_WorkOrders.Updates )

Was this reply helpful? Yes No
kmw1130 988 on at

Like (0)

Report

@Pacel,

I need to be able to go back or reset the form. I put a button to ResetForm or Set(varVisibleProp, 0)

I'm not sure what will work to reset the form or go back.

Was this reply helpful? Yes No