cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Posting Collections to On-Premise SQL - Replicating data

Hey, Not having an issue posting from the App to SQL, the issue is that if i have 3 items in the collection it's pasting 3 items in SQL table, but all as the last entry in the Collection. The Collection is grabbing all the data from a Gallery and apending it correct in the app, but when submitted its just the wrong data.

 

This is the code from the Gallery + add new:

Patch(
    SampleCollection,
    ThisItem,
    {
        SampleQtyCol: Value(Qty.Text),
        SampleQtyDescCol: QtyDesc.Text,
        SampleDateCol: Date.SelectedDate,
        SampleTypeCol: Type.Text,
        SampleTestCol: Test.Text,
        SampleReceivedCol: Received.Value
    }
);
Collect(
    SampleCollection,
    {
        SampleQtyCol: 0,
        SampleQtyDescCol: "",
        SampleDateCol: Today(),
        SampleTypeCol: "",
        SampleTestCol: "",
        SampleReceivedCol: false
    }
)

This is the code from OnSuccess.

ForAll(
    SampleCollection,
    If(
        !IsBlank(Qty),
        Patch(
            '[dbo].[SampleData]',
            Defaults('[dbo].[SampleData]'),
            {
                SampleDate: Date.SelectedDate,
                SampleQty: Value(Qty.Text),
                SampleQtyDesc: QtyDesc.Text,
                SampleType: Type.Text,
                SampleTest: Test.Text,
                SampleRecevied: Received.Value,
                SSFMaster: Form2.LastSubmit.SSFID
            }
        )
    )
)

I have attached the SQL Screenshoot.

Any help would be appreciated

2 REPLIES 2
Anonymous
Not applicable

adding in @GregLi to help with this question

Anonymous
Not applicable

@Cranny In looking at the code, it appears it is the order of operations that are causing the problem. First you create the collection, then you clear it before you submit it. 

Could you try editing the code so that the collection is cleared after the data has been submitted to SQL? Please let us know if this helps?

PS. You reference form 2 in your code to submit to SQL, where is form 2 in this scenerio? 

Thank you for your patience @Anonymous

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Check out the Power Apps Community Call for January 2021

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (3,822)