Collect can't get all data from table by ShowColumns

(1) Share

Report

Posted on by NT32

Hello,

Actually, I have used this formula for a period of time, and it worked very fine.

Until today i don't know what happened (I'm sure that i didn't make any change to this formula) but the collection seem may have something wrong with it. it can't get all the data it used to collect.

the thing is i want to collect the collection name "getdataforDOnotifyDG" with specific columns by ShowColumns function,

as you can see the ShowColumns work fine, but in the end the collection got only 2 columns just ID and field_29 (it used to get all i defined in the formula)

So, i would like to know what happen and how to fix this. please help.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

WillPage 2,307 Super User 2025 Season 2 on at

Like (4)

Report

You could try the setting this retired feature for troubleshooting purposes

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (2)

Report
Hi @NT32 ,

You have a couple of redundant things in there - try this

ClearCollect( getdataforDOnotifyDG, ShowColumns( Filter( 'NBL Domestic Delivery Order', Order_DeliveryStatus = "Delivered" && Schedule Transporter="DG" ), ID, ScheduleTransporter, Schedule_LoadingDateTime, ScheduleDeliveryDateTime, 'ERP_Package Type', ERPQuantity, 'ERP_Shipto Cust', 'ERP LO Number' * ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
ImTonGz 17 on at

Like (1)

Report

I have a same problem like you. It happen today also after using this collection formula for a year, as I try to debug step by step all formula is fine until I want to keep that table to collection. It suddenly not store Number values.

still figure out how to fix this thing 🙃

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (2)

Report

Hi @ImTonGz ,

Did you make some changes yesterday ? If so have a look at the release version of your published app. I have been having issues with 3.2064 across two different domains on two separate apps. Reverting to 3.2061 solved the issue for now.

Was this reply helpful? Yes No
ImTonGz 17 on at

Like (3)

Report

Hi @WarrenBelz I did’t change anything for a long time, problem suddenly come up today.

by the way, I try to change settings in as @WillPage mentioned and its work !.

Was this reply helpful? Yes No
NT32 16 on at

Like (1)

Report

@WillPage It worked, thank you very much.

Was this reply helpful? Yes No
NT32 16 on at

Like (2)

Report

@WarrenBelz Thank you for your advice about the redundant thing and helping optimize my formula.

Was this reply helpful? Yes No
NT32 16 on at

Like (1)

Report

big thank to @WillPage
Yeah! it works for me as well, happy to hear that you can solve the problem.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (3)

Report

I can also confirm that the suggestion from @WillPage works

Not ideal in the long term though - the version issue needs to be addressed by MS

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (1)

Report
The might be a way by using Something like
Clear(getdataforDOnotifyDG); ForAll( Filter('NBL Domestic Delivery Order', Order_DeliveryStatus = "Delivered" && Schedule Transporter="DG"), Collect(getdataforDOnotifyDG, { ID: ThisRecord.ID, ScheduleTransporter: ThisRecord.ScheduleTransporter, Schedule_LoadingDateTime: ThisRecord.Schedule_LoadingDateTime, ScheduleDeliveryDateTime: ThisRecord. ScheduleDeliveryDateTime, 'ERP_Package Type': ThisRecord.'ERP_Package Type', ERPQuantity: ThisRecord.ERPQuantity, 'ERP_Shipto Cust': ThisRecord.'ERP_Shipto Cust', 'ERP LO Number': ThisRecord.'ERP LO Number' } ) )
Without that setting switched on.

Was this reply helpful? Yes No