Unanswered

Show Lookup field result in Form

(0) Share

Report

Posted on by rbarpas

Hi, I'm new with PowerApps and I have this doubt, thanks in advance.

The app works witrh Sharepoint list source and I have some lookup fields. For exemple I have this field called "Field" and when I save one form register there is another related field that is saved, in that case is named "Obra:Obra".

In PowerApps, I want that related field shows in the moment the info related with the first selection field (Obra), but this field is blank:

Código Obra = Obra (in Sharepoint)

Obra = Obra.Obra (in Sharepoint)

If I send the form, the info is saved (like if I do it in Sharepoint). But I need to show also this info in the form in the moment when the first lookup field is selected.

Thanks!

Categories:

Building Power Apps

All responses (13)

Answers (0)

Sort by

victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
In this case you have to edit the default item of Obra card to look into the 'Obra' list to get the 'Obra.Obra'.

Assuming the Obra list is called 'Obras' it will be something like this:
LookUp(Obras, ID = combobox.Selected.Id).Obra

Please let me know if you have any question
(se não ficou claro podemos falar em PT)
rbarpas 35 on at

Like
a
(0)

Report
Copy link

Link copied!

You mean in "DefaultSelectedItems"?

The LookUp field is this ("Parte Diario" is the main list, and "Obras" is where de LookUp looks for)
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
No, what I meant is to get the obra's name you have to search for it in the Obras list, so you have to LookUp for it using the 'Codigo Obra' Item, like this:
LookUp(Obras,ID = DataCardValue4.Selected.Id)
rbarpas 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Ah ok, I understand, but now it's showing an error.

Thanls for your time.
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You set the combobox default instead of the card default
rbarpas 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, I changed the Default in combobox but still showing error in the formula.
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
As you are using the spanish version it should be ; instead of ,

LookUp(Obras; ID = DataCardValue4.Selected.Id)
rbarpas 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, that's the key, in Spain is ;
I edited and now the error doesn't appear, but when I check the form when I select a value in "Obra",, the related field "Obra:Obra" still in blank always.
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

did you changed the default of the combobox (blue one)?

If so please set it Parent.Default

It should work
rbarpas 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes I deleted the fields and added again, because had made too many changes.

Now, DataCardValue353 is the LookUp field

And, in the related field, in Default, the LookUp points to DataCardValue353

But, if I play it, and select "Obra", "Obra:Obra", still blank: