Problem with Patch function - submit multiple forms in one Excel

[Schwaigy]

Hi Community,

I have a problem with my Inventory Management App.

My app have two device : command materials and find all inventory movments.

I'm using 2 Excel Table (Onedrive for business).

All products and materials are in DataSource : Table1.

The second DataSource : Table 2 is where I want to collect all my products movments records (IN/OUT).

Here is my products screen and the 2 forms that I'm using to create the movments recordings.

I create all the app but I've a problem with recording movments in Table 2...

Here is my Movments recordings Screen...

I think that a patch function can resolved it but I'm lost...

I'm using a SubmitForm at this moment. Here is my Function :

Thanks in advance for all your precious tips and heplful commentary.

And sorry for my bad english...

If you need more screenshot and explanations please tell me.

[gabibalaban]

Hi @Schwaigy ,

You didn't said a word about the error or the app behaviour ? 

[Schwaigy]

Hi @gabibalaban ,

Thanks for the answer.

The problem is the SubmitForm function that don't record the EditForm1_1 values (Image, Name and Reference N°). You can see in the Excel Table2 and in the DetailMovementScreen that we can't see anything 😞 

I think that a patch function can fix my problem but I can't write it... 😞

[poweractivate]

@Schwaigy 

There are too many factors here to consider, in our opinion, in this case.

We could make an attempt at helping you with this, but because of this one having so many factors, we'd like to first ask you this to see if we can attempt a shortcut on helping you:

1) Would you be allowed to post the app here or send it to us to take a look at? Be sure to check this very carefully - if you are not allowed to e.g. if there is confidential material in there, you cannot do it. If you do send it you warrant and attest that you are permitted to share it and that it has no confidential material.  As for the Excel Files can be created by ourselves just off of your screenshots with mock data  - it would be mostly only the app.

2) If the answer to #1 above is yes, reply here and we'll give you instructions how to send the app to us and we might go ahead and check it, then if possible advise you of a solution to the issue.

3) If the answer to #1 is no, just say so and we will see if we can just check on it anyway even without the app.

[Schwaigy]

@poweractivate 

Sorry but my answer is no 😞

I'm working for a federal administration so it's impossible to share my app...

But I can send you screenshots of everything

Thanks

[poweractivate]

@Schwaigy 

Try seeing if using the Refresh(YourDataSource) function with the datasource (the one tied to the one that doesn't show up the updates) and put this in the formula as a statement right after the SubmitForm works for you. It may be that that it is not picking up update right away after the SubmitForm when it is being done like that.

[Schwaigy]

It doesn't work... For me the problem is the link between the two Table (1 and 2). For me the problem is in the EditForm1_1.

I tried to use Patch function but I"m noob ^^ I can't write the function correctly...

Did you know if the French syntax is different ?

[LRVinNC]

@Schwaigy  I notice that your Table 2 does not appear to have any columns to tie the movement record back to a specific item.  In other words, you record the movement but there is nothing to say what moved.  You will need to add a column to contain the reference number, name or ID for the item so you know WHAT moved.  

Additionally, from what I can see, there is no reason for you to do a Submit form on Edit_Form1_1 because you aren't changing anything on that form.  In fact, you really don't need to use an edit form there, although you can.  There is no rule that says you have to use a display form if you aren't editing.  In fact, some people always use an edit form - BUT, you don't need to do a SubmitForm unless something is changing. 

So, what might work better, if for you to have a single form on this screen.  The reference number column (which I mentioned earlier you need to add to know which item you are talking about) would be populated just like you do currently on Edit_Form1_1 except now you will populate it on Form3 instead.  You can do a lookup on Table1 to get the image and Nom fields to display and then continue with the other columns you are already using.  Then you will only have a single SubmitForm.  The problem you are having is because the second SubmitForm is never getting executed.  With a Single SubmitForm(Form3) that will no longer be the case and your record should be posted and you won't need to use a Patch statement.

LRVinNC

[Schwaigy]

Awesome answer @LRVinNC ! You're a genius !

You understand my problem 🙂 so I need to use Lookup and change my forms 🙂

But how can I have my reference number ? I must add reference number in Table 2 ?

LookUp function can choose the Image and Name of the product I select in Product list ?

Can you help me with the LookUp Function? 😞 give me an example of function based on my values 🙂

Thanks in advance 😉

[LRVinNC]

@Schwaigy  Thanks for the kind words and sorry for the delay in responding.  

Yes, you need to add another column to Table 2 to contain your reference number or some other column that will uniquely identify which item the movement is about.  

Here's details on Lookup: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup.

I can't give you the exact syntax on the lookup because I don't know how you have structured your screens, but here is an example.

You can likely save the reference number of the selected item to a global variable with
Set(SelectedProduct, ThisItem.Reference)
in the OnSelect from the Products gallery when you click on the Shopping Cart.  You may even already be doing this.  Look at how information is currently passing between your Products Gallery and your Ajouter Mouvement screen.  You will do the same, except you will need to pass the info into Form 3 instead.  

In Form 3, you'll need to add a field for your Reference (which you are adding to Table 2) and then you'll need to add a custom card to Form 3 into which you place a label for Nom and an Image for your product image.  Then you can use the lookup to populate those two fields.  It will look something like
Lookup(Table1, Reference = SelectedProduct ).Nom
where SelectedProduct is the field in the Set statement I referenced above.   The .Nom on the end tells it which field to return after it does the lookup matching the reference column in Table 1 to the SelectedProduct in the global variable.  You'll do exactly the same this to get the image, substituting .Image (or whatever the correct column name in Table1 is for the image.  You won't be updating those two fields in the custom card - they are just for display purposes.  You'll update all the other columns using your SubmitForm(Form3).

Hope this helps.
LRVinNC