How to use ShowColumns with a Right(,) ?

(0) Share

Report

Posted on by simms7400

829

Hi FOlks -

I have the following collection:

 ClearCollect(
 TargetList,
 {
 TargetAlias: "Not Applicable",
 TargetID: "Not Applicable"
 },
 ShowColumns(
 Filter(
 rdTarget,
 Or(
 Not(DataElement_Type.Value = "Time Tracking"),
 Not(Portfolio_Status.Value = "Terminated")
 )
 ),
 "TargetAlias",
 "TargetID",
 "DDU_Portfolio",
 "Modality_Detail",
 "Target_Short_Name",
 "Target_Long_Name",
 "Business_Owner",
 "Mechanism",
 "IP_Owner"
 )
 )

But for the "TargetID", I actually want to do:

Right(TargetID,8)

How would I achieve that? Thanks!

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@simms7400

You could use AddColumns() to add the truncated ID column.

ClearCollect( TargetList, { TargetAlias: "Not Applicable", TargetID: "Not Applicable" }, ShowColumns( AddColumns( Filter( rdTarget, Or( Not(DataElement_Type.Value = "Time Tracking"), Not(Portfolio_Status.Value = "Terminated") ) ), "RtargetID",Right(TargetID,8) ), "TargetAlias", "TargetID", "RtargetID", "DDU_Portfolio", "Modality_Detail", "Target_Short_Name", "Target_Long_Name", "Business_Owner", "Mechanism", "IP_Owner" ) )

In this formula, the truncated column is added within the ShowColumns() function but not replacing the TargetID. However, it could replace TargetID by leaving that one out of the ShowColumns() list and renaming RtargetID to TargetID for the collection.
simms7400 829 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp

Thank you so much, this worked like a charm!!