Inline Editing

[VincentGiovanni]

Hello Great Community!

I work at a warehouse and we're recieving hundreds of products daily

I have an App which is able to insert new rows of data from the delivery notes, the problem I've is that I'm using a form for every row.

The Columns are basically; 

Supplier, Ordernumber, Internal Number, Article number, Product, Quantity, Deliverad Date, Client & Comments.
This is then pushed out to a Sharepoint List and I'm trying to figure out a way to make an Inline Editing where you could easily add new row and inserting all the data before submitting it instead of doing a form for every product since a delivery note can have 50 rows of products under the same Ordernumber.

I've watched a couple of videos where Collections, I just cant seem to figure it out. 

Could anyone please help me and guide me through it?

Best Regards 
Vincent

 

[Waegemma]

Hi @VincentGiovanni ,

Your question is a bit broad 🙂

One way to approach this:

You could use a datatable coupled to a collection.

Get the collection with the collect button (you can use a filter) from you list.

Put textinputs at the bottom of each column and use a button to add this row of inputs to the collection.

With another button you patch the entire collection to your list.

To correct mistakes, remove the selected row with the Remove Button.

ADD-Button:
Patch(colTest,Defaults(colTest), {Department:txtDepartment.Text, Title:txtTitle.Text})

REMOVE-Button:
RemoveIf(colTest, 'Id (ID)'  = DataTable3.Selected.'Id (ID)')

COLLECT-Button:
ClearCollect(colTest,Test)

PATCH-Button:
Patch(Test,colTest)

This is a sketch, not an app 🙂

Marc

[VincentGiovanni]

Hello Again,

Sorry for the broad question, To keep it simple, I would like to add an collection of multiple items and then submit the collection permanently into the Sharepoint list instead of submitting a form for each and every item, I've uploaded a printscreen of my test screen. 

The thing I'm missing at the moment is how to upload this temporary collection into my SP list now that i have multiple items stored in the collection

[Waegemma]

Hi @VincentGiovanni ,

You can patch the whole collection in one time: Patch(YourList, YourCollection).

Just make sure the fields in your collection match the ones in the list (name and type).

In your case something like:

Patch(YourList,NyInleverans) should do the trick.

Greetings,

Marc

[VincentGiovanni]

Hello again!

Thank you for your kind help!
It almost did the trick, When Wrote in the OnSelect in the Patch button as you wrote Patch(YourList, NyInleverans) , it came back an error message saying a Record value is expected so instead of Table so i changed the OnSelect to Patch('Innleveranse Lager';
{
Title: Leverantör.Text;
Ordernummer: Ordernummer.Text;
Ordermärkning: Ordermärkning.Text;
Artikelnummer: Artikelnummer.Text;
Produktbeskrivning: Produkt.Text;
Antal: Antal.Text;
LeveransDatum: LeveransDatum.SelectedDate;
Mottagaren: Beställare.Text;
Kommentar: Kommenta.Text
})

This almost did the trick, it only inserted the last item of the collection. 

[Waegemma]

Hi @VincentGiovanni ,

My fault.  If you initialise your collection NyInleverans starting from your list, it should work.

Change (or add to)  the OnVisible property of your inputscreen:

ClearCollect(NyInleverans, Filter('Innleveranse Lager',false))

This way your collection is empty, but with all the right fields that are present in 'Innleveranse Lager'.

In my version of the app above, this happens under the Collect-Button.

Marc

[Waegemma]

Hi @VincentGiovanni ,

If for some reason the above doesn't work, you could always use this in the OnSelect of your 'Button':

ForAll(NyInleverans; Patch('Innleveranse Lager'; Defaults('Innleveranse Lager');ThisRecord))

Marc