web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Lookup issue

Power Apps

Answered

Lookup issue

(0) Share

Report

Report

Posted on by Community Power Pla...

Hello,

i have a lookup issue and i don't understand what the error is.

I have a SP list and i want to see the Millesime record when the title is display in the form.

In the form, i add this formula

The value from code titre is given a lookup formula.

What i'm doing wrong ?

thank you

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Hi@ALP1,

Based on the issue that you mentioned, do you want to populate the drop down control based on the Title value?

Could you please tell me that

if this Millesime column is a Text type in your SP list?

is this drop down control corresponding to the Millesime a Combo Box or a Dropdown box

From your screenshot, I think Millesime column is a Text column and you have replaced the TextInput corresponding to the Millesime with a drop down control.

Actually, whatever the Combo Box or a Dropdown box, it expects a Table value rather than a Text or a record.

The LookUp() you provided returns a Text value which is not matched to the Combo Box or a Dropdown box.

Please modify your formula as below:

[LookUp(YourSPList,Title=code_titre_value.Text).Millesime]

Notice that you should add a "[]" outside your LookUp formula.

Hope it could help.

Regards,

Qi

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

hi,
It's very intersting. I add the [] and it's work well.

[If(txt_First_habilitation.Text = "Oui";(LookUp(Synthese_Titres;Intitulé=ComboBox_titre_habilitation.Selected.Result).Title);LookUp(Synthese_Titres;Intitulé=ComboBox_titre_rehabilitation.Selected.Result).Title)]

Big thanks

Was this reply helpful? Yes No

Join the conversation