Unanswered

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

I have the same question (0)

All responses (3)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report
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" ) );;

Was this reply helpful? Yes No
Reze 60 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Reze 60 on at

Like (1)

Report
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" ) )

Was this reply helpful? Yes No