Answered

LookUp for a Column in a Filter

(0) Share

Report

Posted on by Reze

Hello,

I have two tables in dataverse. ATIV_REQ_Requisition_History and ATIV_REQ_GrabePlace. The first one has an ID that reference the second one, for example in a row of the first I have a column GrabePlaceID (1) and wna't to LookUp for the Name associated with that ID in the Second table.

So far I have the data from the first table:

Set(
 Trash;
 RenameColumns(
 ShowColumns(
 Filter(
 ATIV_REQ_Requisition_History;
 DateTimeRequest >= dtStartDateExport.SelectedDate And DateTimeRequest <= dtEndDateExport.SelectedDate
 );
 "cr6ec_cc";
 "cr6ec_datetimerequest";
 "cr6ec_mailrequester";
 "cr6ec_observations";
 "cr6ec_justification";
 "cr6ec_usernamerequester";
 "cr6ec_grabeplaceid";
 "cr6ec_reqtypeid";
 "cr6ec_statusid"
 );
 "cr6ec_cc";
 "CC";
 "cr6ec_datetimerequest";
 "DateTime Request";
 "cr6ec_mailrequester";
 "Mail Requester";
 "cr6ec_observations";
 "Observations";
 "cr6ec_justification";
 "Justification";
 "cr6ec_usernamerequester";
 "UserName Requester";
 "cr6ec_grabeplaceid";
 "GrabePlaceID";
 "cr6ec_reqtypeid";
 "ReqTypeID";
 "cr6ec_statusid";
 "StatusID"
 )
);;

and the result:

So, I need to replace the column GrabePlaceID by the real name that I would get from the second table: LookUp(ATIV_REQ_GrabePlace;ID = ????;GrabPlaceName).

I don't know how to join the two queries.

Thanks

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Reze,

If I understood correctly you want to insert a LookUp for the GrabePlaceID column like below:

Set( Trash; RenameColumns( ShowColumns( Filter( ATIV_REQ_Requisition_History; DateTimeRequest >= dtStartDateExport.SelectedDate And DateTimeRequest <= dtEndDateExport.SelectedDate ); "cr6ec_cc"; "cr6ec_datetimerequest"; "cr6ec_mailrequester"; "cr6ec_observations"; "cr6ec_justification"; "cr6ec_usernamerequester"; "cr6ec_grabeplaceid"; "cr6ec_reqtypeid"; "cr6ec_statusid" ); "cr6ec_cc"; "CC"; "cr6ec_datetimerequest"; "DateTime Request"; "cr6ec_mailrequester"; "Mail Requester"; "cr6ec_observations"; "Observations"; "cr6ec_justification"; "Justification"; "cr6ec_usernamerequester"; "UserName Requester"; "cr6ec_grabeplaceid"; "GrabePlaceID"; LookUp(ATIV_REQ_GrabePlace;ID = "cr6ec_reqtypeid";GrabPlaceName); "ReqTypeID"; "cr6ec_statusid"; "StatusID" ) );;
Reze 60 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer,

Thanks for the help.

It gives me an error message like 'The argument xxxxx is invalid. It was expected a literal text'. And it's in the RenameColumns section that give me another error 'RenameColumns have some invalid arguments'.

Thank you
Verified answer

Reze 60 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

I figured out. Thank you for your help @BCBuizer.

Set( query; RenameColumns( ShowColumns( AddColumns( Filter( ATIV_REQ_Requisition_History; DateTimeRequest >= dtStartDateExport.SelectedDate And DateTimeRequest <= dtEndDateExport.SelectedDate ) As a;"GrabePlaceName";LookUp(ATIV_REQ_GrabePlace;cr6ec_id = Text(a.cr6ec_grabeplaceid)).Name;"ReqTypeName";LookUp(ATIV_REQ_ReqType;cr6ec_id = Text(a.cr6ec_reqtypeid)).Name;"StatusName";LookUp(ATIV_REQ_ReqStatus;cr6ec_id = Text(a.cr6ec_statusid)).Name); "cr6ec_cc"; "cr6ec_datetimerequest"; "cr6ec_mailrequester"; "cr6ec_observations"; "cr6ec_justification"; "cr6ec_usernamerequester"; "GrabePlaceName"; "ReqTypeName"; "StatusName" ); "cr6ec_cc"; "CC"; "cr6ec_datetimerequest"; "DateTime Request"; "cr6ec_mailrequester"; "Mail Requester"; "cr6ec_observations"; "Observations"; "cr6ec_justification"; "Justification"; "cr6ec_usernamerequester"; "UserName Requester" ) )