Unanswered

Create Collection from Dataverse Lookup Columns

(0) Share

Report

Posted on by VJ-22072138-0

I have a Dataverse table, with two Lookup Columns, with One-To-Many relationships with one other table. When a collection is created, the two fields created a Type Table in the collection creating a patch error.

How can I create a collection text date for the two lookup columns…Thanks

Collect(

colContact,

{

name: ThisItem._ContactID,

firstname:inpFirstNameEG.Text,

lastname: inpLastNameEG.Text,

email: inpEmailEG.Text,

ItemStatusLU: cbxItemStatusEG.Selected,

CompanyLU: cbxCompany.Selected

}

)

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Syvenn ,

Probably like this

Collect( colContact, { name: ThisItem._ContactID, firstname:inpFirstNameEG.Text, lastname: inpLastNameEG.Text, email: inpEmailEG.Text, ItemStatusLU: cbxItemStatusEG.Selected.Value, CompanyLU: cbxCompany.Selected.Value } )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
VJ-22072138-0 53 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply! Collection will not accept .Value

Was this reply helpful? Yes No
WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Syvenn ,

What type of column is ItemStatus and what are the Items of cbxItemStatusEG ?

Was this reply helpful? Yes No
VJ-22072138-0 53 on at

Like (0)

Report
Copy link

Link copied!

The ItemStatus is a Lookup column, The parent table [ContactSy] has a One-To-Many relationship with the [lookupinfo] table. It is a text field.

Was this reply helpful? Yes No
VJ-22072138-0 53 on at

Like (0)

Report
Copy link

Link copied!

Sorry it's a Many-To-One relationship:

Was this reply helpful? Yes No
WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Syvenn ,

Yes, but what is the Items of cbxItemStatusEG and if you type in

cbxItemStatusEG.Selected.

what comes up underneath ?

Was this reply helpful? Yes No
VJ-22072138-0 53 on at

Like (0)

Report
Copy link

Link copied!

Hello, thanks for the reply!
The Items statement: Filter(Choices([@ContactSy].ItemStatusLU),EntCode = "PRO1" && Module="Contact" && Prompt="Status"), which provides two items in the cr965_itemvalue combobox: Active & Non Active

If I type in: cbxItemStatusEG.Selected i get:
If I build the collection with this code (Cannot use Selected must use SelectedItems:
Collect(
colContact,
{
cr965_contactid:ThisItem.Contact,
cr965_firstname:inpFirstNameEG.Text,
cr965_lastname:inpLastNameEG.Text,
cr965_email:inpEmailEG.Text,
cr965_CompanyLU:cbxCompany.SelectedItems.CompanyName,
cr965_ItemStatusLU:cbxItemStatusEG.SelectedItems.ItemValue,
cr965_name:inpID.Text
}
);
I get:
Which indicate the data type is unsupported for the 2 combo boxes.
If I patch directly with this code:
Patch(ContactSy, ThisItem, {FirstName:inpFirstNameEG.Text,LastName:inpLastNameEG.Text,email:inpEmailEG.Text, ItemStatusLU:cbxItemStatusEG.Selected, CompanyLU: cbxCompany.Selected});

It works fine. Not that if I patch directly, I must use Selected w/out the column name. SelectedItems generates an error.

Thanks for you time on this issue.

Was this reply helpful? Yes No
WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Syvenn ,

What I am after (note extra dot after Selected) is what comes up when you type in

cbxItemStatusEG.Selected.

essentially the output of the combo box. Another question here - is this a single or multi-select control ?

Was this reply helpful? Yes No
VJ-22072138-0 53 on at

Like (0)

Report
Copy link

Link copied!

It is a single control.
Requested Output:

Was this reply helpful? Yes No
WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Syvenn ,

You should need whichever one of those produces the Text result you want. Try putting the values on a Label after you have selected something in the drop-down.

Was this reply helpful? Yes No