Quantity has always the same value in my list

[Sander_FLX]

Hi,

I created a simple powerapp to collect barcodes and put them into a sharepoint list.

In my Gallery I add 'Text Input' (Hoeveelheid) field, set the format for this as a number.

This is my OnScan code :

Collect(CollectMultiScan, {ScanId: ScanID.Text,BarcodeInfo:'Scan button_1'.Value,WhoScanned: User().FullName, WhenScanned: Now()})

This is my OnSelect code For my UPLOAD button :

ForAll(
CollectMultiScan,
Patch(
TEST,
Defaults(TEST),
{
ScanID: ScanId,
Title: BarcodeInfo,
Barcode: BarcodeInfo,
Aantal: Hoeveelheid.Text,
Who: WhoScanned,
When: WhenScanned
}
)
);
Clear(CollectMultiScan);
Set(
varvar,
GUID()
);
Reset(ScanID)

TEST is the name of my Sharepoint List

Everything works but the Quantity (hoeveelheid) is always the same... Even you fill in 3 in the 'Hoeveelheid' field after upload he always use the latest input from the collection...

Input in the APP :

Output in the List :

Could you help me, don't see the problem  ?

[Himanshu_90677]

@Sander_FLX  i think you need to check your sharepoint column setting > Default value

[Sander_FLX]

Hi @Himanshu_90677 ,

The Default value column setting off 'Aantal' is empty :

[Himanshu_90677]

@Sander_FLX  Can you check SP Column Type is Number Value  Or Text Value? set it to number and then check

[Sander_FLX]

Hi, just changed it to number and the result still the same.

Always the same input from the last input field.

So if i set 1,2,3 in the 3 gallery lines. The result in my list is always 3 instead of 1,2,3.

[Sander_FLX · Accepted solution]

Hi @Himanshu_90677 ,

I Solve it by changing the code :

ForAll(Gallery1.AllItems,Patch(TEST,Defaults(TEST),{ScanID:ScanId,Title:BarcodeInfo,Barcode:BarcodeInfo,Aantal:Value(Hoeveelheid.Text),Who:WhoScanned,When:WhenScanned}));Clear(CollectMultiScan);Set(varvar,GUID());Reset(ScanID)

I used CollectMultiScan for my collection and there was no 'hoevelheid' added to that collection so i took now the whole gallery.

It's solved.