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... Microsoft Employee

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

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Join the conversation