cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FarrellDrafting
Helper II
Helper II

Add Column from lookup of another collections column, lookup error

I'm trying to add info from a collection to another, and my lookup is flagging an error on comparing two text columns to find a match. Any help? See linked image below, for context, both collections are local, the columns being compared are both single string columns. this is the tail end of a large add columns command.

FarrellDrafting_0-1619632970807.png

I've tried adding text surrounding the ElemQCNum of Map Local, in matches anything that contains

2 REPLIES 2
mdevaney
Super User III
Super User III

@FarrellDrafting 
Can you please supply a screenshot of the error message AND a full screenshot of your code before & after the error?

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Ok, below is the full clear collect.

 

ClearCollect(CombinedElevationControlLocal,
	AddColumns(
		ShowColumns(GroutElevationControlLocal,
			"Title",
			"ElemQCNum",
			"ElemDia",
			"ElemType",
            "TargetTopOfGroutElev",
            "MinTopOfType3Elev",
            "MaxDepthToAggCushion",
            "ElevControlRepInitials",
            "ElevDate",
            "ElevTime",
            "VerticalControlPoint",
            "VCPLaserLevelElevation",
            "LaserLevelElevation",
            "TargetRodLengthtoGrout",
            "ActualRodLengthtoGrout",
            "TargetRodLengthtoType3",
            "ActualRodLengthtoType3",
            "PushRequiredLBS_x002d_Comments",
            "ActualDepthAggCush",
            "RecordNumber",
            "ItemID"
            ),
		"Ident","Grout",
		"VCPtoLaserLevelRodLength","",
		"LaserLevelElev","",
		"CageCutoff","",
		"TargetTopofHoopElev","",
		"TargetTopGroutElev","",
		"TargetRodLengthtoHoop","",
		"ActualRodLengthtoHoop","",
        "XPixel",LookUp(MapLocal,ElemQCNum = GroutElevationControlLocal[@ElemQCNum],XPixel),
        "YPixel","",
        "ShapeWidthPixel","",
        "ShapeHieghtPixel",""
	)
);

 

Below is the tool tip that pops up when i mouse over the equals sign. using in works, but it supplies the same result for all records.

errorpopup.png

This is the first clear collect creating a merged collection, without the XPixel, YPixel, ShapeWidthPixel, and ShapeHeightPixel it works fine. its just the lookup functionality that isn't working.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (85,576)