Writing a Collection to Sharepoint

(0) Share

Report

Posted on by Aimthedame

220

I have a button running the following formula:

ForAll(collectMultiscan,Patch('Thermostats & CO2', Defaults('Thermostats & CO2'), {Date: Now(), Employee: User().FullName, Customer: inputCustomer.Text, Title: PartNum, Description: Description, Quantity: Quantity}));

This is what it is returning:

Date Title Quantity Description Employee Customer

8/20/2020	CO2		Carbon Monoxide Alarm	John Doe	Jones
8/20/2020	Y8704	2	TH6320U2008 3H/2C HP, 2H/2C Conv.	John Doe	Jones
8/20/2020	18N77	2	THX321WFS2001W 3H/2C HP, 2H/2C Conv.	John Doe	Jones
8/20/2020	Y8705	2	TH6210U2001 3H/1C HP, 1H/1C Conv.	John Doe	Jones

This is what it should return:

Date Title Quantity Description Employee Customer

8/20/2020	CO2	2	Carbon Monoxide Alarm	John Doe	Jones
8/20/2020	Y8704	1	TH6320U2008 3H/2C HP, 2H/2C Conv.	John Doe	Jones
8/20/2020	18N77	1	THX321WFS2001W 3H/2C HP, 2H/2C Conv.	John Doe	Jones
8/20/2020	Y8705	1	TH6210U2001 3H/1C HP, 1H/1C Conv.	John Doe	Jones

What am I doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Aimthedame

Formula looks good. Can you review your collection through the Collection Viewer and verify if the results there are what you expect?

I would guess there is something wrong in the collection.

I hope this leads to some resolution for you.

Was this reply helpful? Yes No
Aimthedame 220 on at

Like (0)

Report
Copy link

Link copied!

I'm using the barcode scanner (my phone) so I it's hard to see the collection.

This is the scanner formula:
Collect(collectMultiscan, {PartNum: btnScan.Value, Description: LookUp(Inventory, LPN = btnScan.Value, DESC), Quantity: Quantity.Text})

The "Sample value" collection data has no Quantity in the first row and then the three following rows Quantity contains "1".

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Aimthedame

Understood - always a challenge to use phone only features and try to troubleshoot without instrumentation enabled.

On the surface - the collect formula appears fine as well, but there could be other factors to consider and you should narrow down the scope of where to look.

What I would suggest is to put a Label on the screen and set its text property to :

First(collectMultiscan).Quantity

See what the Quantity value is when you collect something.

Or, skip the label and put a small Gallery on the screen and set the Items property to collectMultiscan

Put a label in the Gallery and set test to ThisItem.PartNum & " - " & ThisItem.Quantity

That would help facilitate understanding where to start looking.

Was this reply helpful? Yes No
Aimthedame 220 on at

Like (1)

Report
Copy link

Link copied!

Thanks to your Gallery suggestion I was able to fix my collection. I will definitely use that in the future.

Was this reply helpful? Yes No