How to auto populate field in form with an ID and a Value

(0) Share

Report

Posted on by CU22100725-0

129

Hi,

I need to auto populate a field in a form. I use 2 lists, one with the field in Lookup and the other with the field in Text. I can have the same content in my list several times. When I use the list where the field is in Lookup, I need to have the right content and I would have thought of using my line ID. How can I do this?

I'd like to point out that I'm already filtering my row with a component that only retrieves the field content.

Here's the code I use:

Filter(Choices([@'IX-LigneTache'].Commande); Value = ComboBoxCde.Selected.Title)

Thanks,

Tom Victor

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @TomVictor ,

Please try below method:

Items:

Choices([@'IX-LigneTache'].Commande)

DefaultSelectedItems:

LookUp(Choices([@'IX-LigneTache'].Commande); Value = ComboBoxCde.Selected.Title)

Best regards,

Was this reply helpful? Yes No
CU22100725-0 129 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni ,

Thanks for your help, I tried your methode and it doesn't seem working. If I try to use a content with the same text, I still get only one and not the other.

Regards,
Tom Victor

Was this reply helpful? Yes No
Verified answer

CU22100725-0 129 on at

Like (0)

Report
Copy link

Link copied!
I finally find a solution so here is the code I used to do that :
Filter(Choices([@'IX-LigneTache'].Commande); Value = ComboBoxCde.Selected.Title && Id = Value(LabelIdCde.Text))

Was this reply helpful? Yes No