Answered

'With' Function and filtered collection not allowing access to choice column value

(0) Share

Report

Posted on by JR-BejeweledOne

5,836 Moderator

I am using the With function to use the data from a filtered collection in creating another collection. It is not allowing me to properly access the value of a choice column. Value should be the correct next step but it doesn't like it at all. ITContacts is a collection in the app.

With(
 {wFilterContacts:
 Filter(ITContacts, Email = ThisItem.PrimaryContact)
},

 ClearCollect(Primary,
 {
 Number: wFilterContacts.WorkPhone,
 Type: "BP",
 SortOrder:
 If(
 wFilterContacts.PrimaryAfterHoursPhone = "Business Phone", 1,
 wFilterContacts.PrimaryAfterHoursPhone = "Mobile Phone", 2,
 3
 )
 },

 {
 Number: wFilterContacts.CellPhone,
 Type: "MP",
 SortOrder:
 If(
 wFilterContacts.PrimaryAfterHoursPhone = "Mobile Phone", 1,
 2
 )
 },
 
 {
 Number: wFilterContacts.HomePhone,
 Type: "HP",
 SortOrder:
 If(
 wFilterContacts.PrimaryAfterHoursPhone = "Home Phone", 1,
 wFilterContacts.PrimaryAfterHoursPhone = "Other Phone", 4,
 3
 )
 },

 {
 Number: wFilterContacts.Other_x0020_Phone,
 Type: "OP",
 SortOrder:
 If(
 wFilterContacts.PrimaryAfterHoursPhone = "Other Phone", 1,
 4
 )
 }
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

JamesYumnam on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JR-BejeweledOne ,
Please try using LookUp function to get your record instead of Filter.

Reason: As per my understanding, With function works with a single record. so it should work on a single record returned by LookUp function. You have used Filter function which returns a table. Hence, you are seeing the Incompatible types error.
LookUp function will return a single record based on your condition.

Hope this helps.

Was this reply helpful? Yes No
RusselThomas 4,014 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JR-BejeweledOne ,
A filter comparitor automatically unpacks each row field to do the comparison, so you can have something like;
Filter(source, column="bob")
but you can't have something like
If(source.column="bob")
just by itself, because there's nothing processing any rows - it's just trying to compare a table to a string which is why you're seeing the error.
You might need to try wrapping it in something that would process each row and then do the comparison, that should give you access to the fields on a per-row basis - something like a ForAll or an AddColumns might work in this instance depending on exactly how you want your Primary collection to look I guess.
eg:
ForAll(Filter(ITContacts, Email = ThisItem.PrimaryContact) As wFilterContacts, Collect(Primary,{ Number: wFilterContacts.WorkPhone, Type: "BP" SortOrder: If(wFilterContacts.PrimaryAfter.....
If processing it row by row doesn't give you the format you're looking for, perhaps you can post an example of the source table and the destination table and we can figure it out from there?
Hope this helps,
RT

Was this reply helpful? Yes No