Powerapps Multiple Screen Navigation

[razken88]

I'm using a Form for screen 1 and a Data Table for screen 2! I cannot collect the fields from Screen 1 into Screen 2 and then publish them as one record in Sharepoint!

[Giraldoj]

HI @razken88 

You actuaqlly can achieve this, but I'll need more details about what exactly you are trying to accomplish. Based on your description, here's a potential solution:

1. Store Form Data from Screen 1: When navigating from screen 1 to screen 2, save all the form data from screen 1 into a collection or variable. For example:

Collect(Screen1Data, {Field1: DataCardValue1.Text, Field2: DataCardValue2.Text})​

2. Store Form Data from Screen 2: Do the same for the form data on screen 2. For example:

Collect(Screen2Data, {Field3: DataCardValue3.Text, Field4: DataCardValue4.Text})

3. Combine Data from Both Screens: Combine the data from both screens into a final collection. For example:

ClearCollect(FinalData, Screen1Data, Screen2Data)

4. Patch the Final Collection to SharePoint: Patch this final collection into the SharePoint list. For example:

Patch(SharePointList, FinalData)

I hope this explanation helps. However, we need more information about your current setup and what you want to achieve to provide a more precise solution.

[razken88]

Thanks for your response. It does help clarify the collection part of the data as one record into SharePoint. However, I'm still looking for clarification on navigating the multiple screens before creating the one record for Sharepoint. The query I currently have is throwing errors

[Giraldoj]

As I said in my previous response, Ill need more details to help you like the actual error you are facing.

[razken88]

Here's my query: 

Navigate(MOTORMAKE, ScreenTransition.Cover, {

    Header StoreName: ThisItem.StoreName,

    HeaderStoreNumber: ThisItem.StoreNumber,

});

I've changed the actual field names, but this is the query on  Screen 1, which has a Form(MotorMake), Screen 2 has a Data Table(Motor Brand).  The error I get is it doesn't recognize MotorMake. I hope I've clarified the issue and if I haven't let me know, still working to get the one record in Sharepoint. It works if they are both Screen 1 and 2 are FORMS but Screen 2 is a Datatable for a specific function 

[Giraldoj]

Thanks for sharing more details. First, there's a small error in your code:

Navigate(MOTORMAKE, ScreenTransition.Cover, {
HeaderStoreName: ThisItem.StoreName,
HeaderStoreNumber: ThisItem.StoreNumber,
});

You have an extra comma after ThisItem.StoreNumber.

Now, I think I understand your requirement better, but there's still a part that I'm not clear on. Let's say you have a form called Form(MotorMake) on Screen1, which we'll call the MotorMake screen. If you want to jump to Screen2, the MotorBrand screen where the table is, your code should point to the MotorBrand screen, not the MotorMake screen.

Also,  about the MotorBrand screen. Here's what I'm trying to understand, You collect information from MotorMake and then pass that information in context variables to the MotorBrand screen, right?

Is the information in the MotorBrand table filtered based on the values of these context variables?

So, the information put in Screen1 is not directly updated but just captured to use in Screen2?

If that's correct, the problem might be with your navigate formula. Please try this:

Navigate(MotorBrand, ScreenTransition.Cover, {
HeaderStoreName: ThisItem.StoreName,
HeaderStoreNumber: ThisItem.StoreNumber
});

Make sure the screen you're navigating to is MotorBrand, not MotorMake.

If my response resolved your issue, please feel free to mark it as the solution by clicking "Accept as solution." This helps others find the answer more easily. If you found the content helpful in any other way, a "Thumbs Up" would be greatly appreciated. Thank you! 😁

[razken88]

I really appreciate your input! The two screens Motor Brand and Motor Make, mirror a manual form. MotorBrand has the Header Details, while MotorMake has the Liner details, which is entered as a table. The two screens are collected and published as One record in SharePoint. I did change the query to MotorBrand and it now recognizes it, however it doesn't recognize any of these field items '

HeaderStoreName: ThisItem.StoreName

[razken88]

I rewrote the screen fields with the prompt that started with the field name and the prompt included the DataCard for screen1, the error is now gone and switched to screen 2. The issue is now screen 2 that starts to throw an error with the MotorMake(Form from Screen 1)

[razken88]

This is the query on the Screen 2 button, it throws the following error: 'Unexpected characters. The formula contains 'Control' where 'indent' is expected'

-------The Query for collecting Screen1 &2 then creating one record is as written below:

Set(MOTORMAKE, MOTORMAKE.Updates);
ClearCollect(DataTableItems, DataTable1.AllItems);
ClearCollect(MergedCollection,
{
HeaderStoreName: StoreName_DataCard1.Selected,
HeaderStoreNumber: StoreNumber_DataCard1.Selected.Value, {
TxtDiscountAmount: ThisRecord.DiscountAmount,
ItemNumber: ThisRecord.ItemNumber, }
)
}
);

Patch('Order UAT', Defaults('Order UAT'),
{
StoreName: First(MergedCollection).HeaderStoreName,
StoreNumber: First(MergedCollection).HeaderStoreNumber,
LineItems: First(MergedCollection).LineItems
}
);

[Giraldoj]

Hi @razken88 

It looks like the error in your code is due to improper placement and nesting of curly braces {} and the incorrect usage of the ForAll function within the ClearCollect function. Here’s how you can correct your code:

Set(MOTORMAKE, MOTORMAKE.Updates);
ClearCollect(DataTableItems, DataTable1.AllItems);

// Create MergedCollection to combine Screen1 & Screen2 data
Clear(MergedCollection);
Collect(MergedCollection,
    {
        HeaderStoreName: StoreName_DataCard1.Selected,
        HeaderStoreNumber: StoreNumber_DataCard1.Selected.Value
    }
);
ForAll(DataTableItems, 
    Collect(MergedCollection,
        {
            TxtDiscountAmount: ThisRecord.DiscountAmount,
            ItemNumber: ThisRecord.ItemNumber
        }
    )
);

// Patch the collected data to 'Order UAT'
Patch('Order UAT', Defaults('Order UAT'),
{
    StoreName: First(MergedCollection).HeaderStoreName,
    StoreNumber: First(MergedCollection).HeaderStoreNumber,
    LineItems: DataTableItems // Adjust this part based on your schema
});

This should resolve the syntax errors and correctly merge the data from Screen1 and Screen2 into a single collection before patching it to Order UAT.

If my response resolved your issue, please feel free to mark it as the solution by clicking "Accept as solution." This helps others find the answer more easily. If you found the content helpful in any other way, a "Thumbs Up" would be greatly appreciated. Thank you!