Unanswered

PowerApps

(1) Share

Report

Posted on by CU13080235-3

CTCData i get from using ClearCollect which is combine 3 data into CTCData, but for my CTC_Monitoring a few column no appear their item on CTCData, did i miss anything?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Michael E. Gernaey 53,968 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

You haven't posted any code at all. There is no way for us to tell what you missed. The pictures are great!!!! But please post your code, and also the data that you expect to see.

It sounds like you expect the values that show in CTC_Monitoring, to appear in CTCData. However, you have to explain how they relate to the other data,

since you said it takes 3 other collections/data sources to make CTCData

And then please share the code and we can help.

Was this reply helpful? Yes No
CU13080235-3 4 on at

Like
a
(0)

Report
Copy link

Link copied!

oh sorry here is my code -

ClearCollect(

ContractData,

AddColumns(

CTC_ContractNo,

tblContractDetails,// Add a new column named 'ContractTitle'

LookUp(

tblContractDetails,

Title = CTC_ContractNo[@Title],

'Contract Title'

)

)

);

// Create a collection for the Monitoring Data

ClearCollect(

MonitoringData,

ShowColumns(

CTC_Monitoring,

ProgressText

)

);

// Combine both collections

ClearCollect(

CTCData,

ForAll(

ContractData,

Patch(

ThisRecord,

{

ProgressText: LookUp(

MonitoringData,

Title = ThisRecord.ProgressText,

ProgressText

)

}

)

)

);

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

When you use ThisRecord Power Apps understands that you want the closest Record, so inside the LookUp when you used ThisRecord it gets the item related to it.

In order to fix your issue, you can create a variable to get the current record (CD - ContractData) and use it instead of ThisRecord, like this:

// Combine both collections ClearCollect( CTCData, ForAll( ContractData As CD, Patch( CD, { ProgressText: LookUp( MonitoringData, Title = CD.ProgressText, ProgressText ) } ) ) );

Hope it helps you :)

Was this reply helpful? Yes No