Answered

Referencing a choice value in a collection

(0) Share

Report

Posted on by Zenton

Hi,

In formula below I am using DropColumns to remove Coulmns with null results. The formula is working but Service Required is a choice field in a SharePoint List and the CountA does not see the Value selected and result is 0.

How can I reference the Value of Choice selected in 'Service Required' so I can check if it is null?

Screenshots of collection below.

ClearCollect(removedNulls
,If(CountA(lastRecords.'Bin Location to be emptied?')=0,DropColumns(lastRecords,'Bin Location to be emptied?')
,If(CountA(lastRecords.'PO Name')=0,DropColumns(lastRecords,'PO Name')
,If(CountA(lastRecords.'Transport Service Requested')=0,DropColumns(lastRecords,'Transport Service Requested')
,If(CountA(lastRecords.'PO Name')=0,DropColumns(lastRecords,'PO Name')
,If(CountA(lastRecords.'Schedule Required')=0,DropColumns(lastRecords,'Schedule Required')
))))))

lastRecords Collection

Value of field_7 ('Service Required')

Thanks Rodney

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Zenton ,

Please try and get the selected values in the formula:

ClearCollect(removedNulls,If(CountA(lastRecords.'Bin Location to be emptied?')<=1,DropColumns(lastRecords,'Bin Location to be emptied?'))); ClearCollect(removedNulls,If(CountA(lastRecords.'Service Required'.Value)<=1,DropColumns(lastRecords,'Service Required'))); ClearCollect(removedNulls,If(CountA(lastRecords.'PO Name')<=1,DropColumns(lastRecords,'PO Name')))

Best regards,

Was this reply helpful? Yes No
Zenton 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-jefferni I tried adding .Value. but is not valid when referencing a Collection

Was this reply helpful? Yes No
Verified answer

Zenton 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Does not look like the way I am trying to achieve the solution will work. I will mark as completed

Was this reply helpful? Yes No