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 ?
Solved! Go to 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.
@Sander_FLX i think you need to check your sharepoint column setting > Default value
@Sander_FLX Can you check SP Column Type is Number Value Or Text Value? set it to number and then check
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.
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.
User | Count |
---|---|
164 | |
90 | |
72 | |
64 | |
62 |
User | Count |
---|---|
210 | |
152 | |
97 | |
86 | |
66 |