Answered

Adding data from a column in a data table to a collection

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

Please see the attached image of the app. I have a data table that views the data when the user selects something on a power BI report. I want to get the data from the contact id column and the data from the text fields(subject,description) into a collection when the button is clicked. I have the following code in the button but it does not work. The contact id is not getting added to the collection.

Collect(
DVdetails,
{
Subject: I_Subject.Text,
Description: I_Description.Text,
MyContactID: ContactID_Column3.Text
}
)

I want the collection as:

ContactID	Subject	Description
FF388...	ddd	dd
FF413...	ddd	dd

Please help.

Categories:

Building Power Apps

app.JPG

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Power Pla... on at

Like (0)

Report

I resolved this using the following code. We can merge two collections together:

ClearCollect(
MySPCollection,
PowerBIIntegration.Data
);
ClearCollect(
DVdetails,
{
ID: 1,
Subject: I_Subject.Text,
Description: I_Description.Text
}
);
ClearCollect(MergeSubject,
AddColumns(MySPCollection, "Subject", LookUp(DVdetails,ID=1,Subject) )
);
ClearCollect(MergeDesc,
AddColumns(MergeSubject, "Description", LookUp(DVdetails,ID=1,Description))
)

Was this reply helpful? Yes No
v-monli-msft on at

Like (0)

Report

Hi @Anonymous ,

Thanks for sharing your resolution here and hope others could benefit from it.

Regards,

Mona

Was this reply helpful? Yes No