Combo box with other datasource

(0) Share

Report

Posted on by EdevaldoJeronim

Hi,

I have 02 list in Sharepoint TblMenuUserGrupo and TblGrupo like the example below

TblMenuUserGrupo
IdUser	IdGrupo
NF016	1
NF016	3
NF018	2

and

TblGrupo
IdGrupo	DescGrupo
1	Administrator
2	Supervisor
3	Planning

I have a ComboBox in the form "DataCardValue13" but i need to appear the field "DescGrupo" in the list of ComboBox from the TblGrupo and i need to save the information (the results: IdGrupo) in the field IdGrupo of the TblMenuUserGrupo.

Categories:

Building Power Apps

All responses (8)

Answers (2)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@EdevaldoJeronim

Change your Items property of the combobox to: TblGrupo

If it is the IdGroup that you need to store or display from, then this will give you what you need.

I hope this is helpful for you.
EdevaldoJeronim 99 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes , thank you,
I changed the item property to TblGrupo and now the "DescGrupo" appears in the list of ComboBox to select but the field "IdGrupo" is the information i need to save and is not appear for i link and save
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@EdevaldoJeronim

In your update property you can reference the selected item in the combobox and its associated IdGrupo.

Your Update Property:

DataCardValue13.Selected.IdGrupo

You'll also want to set the DefaultSelectedItems property to properly show the item from the record when you are editing an existing record.

DefaultSelectedItems:

LookUp(tblGrupo, IdGrupo=Parent.Default)
EdevaldoJeronim 99 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes ,
For the Update Property "DataCardValue13.Selected.IdGrupo" appears the error "expected the record value"
and
DefaultSelectedItems:
"LookUp(tblGrupo, IdGrupo=Parent.Default)" appear the error "invalid argument type"

Could you help me?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@EdevaldoJeronim

The formula was based on the assumption that you were storing a simple value in your list. You appear to have a complex column.

So...what type of column is field IdGrupo in the TblMenuUserGrupo list?
EdevaldoJeronim 99 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes, It's a complex collumn, the IdGrupo is a lookup field in TblMenuUserGrupo from TblGrupo.

I'm moving all Database from Microsoft Access to Sharepoint to start to use the Power Apps and the Database is very structured (almost 30 tables / list), the main Tables are with around 150.000 records and I use the Lookup field to keep the Foreign key.
What your opnion about the LookUp field in Sharepoint? I work with Access, Oracle, SQL Server but in this case I only have Sharepoint or maybe i'll try to request access to the CDS Database but I don't have many experience with this package
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@EdevaldoJeronim

It's all good, we just need to give the Lookup column what it wants... and Id and a Value.

So, your Update property should become:

{ Id: DataCardValue13.Selected.ID, Value: DataCardValue13.Selected.Title }

Now in the above, you'll need to replace Title with whatever column is the column used in your Lookup definition. So, look at the definition in SharePoint and see which column you are using to connect to the other table, then substitute that above.

For the DefaultSelectedItems property of DataCardValue13, set it to:

LookUp(tblGrupo, IdGrupo=ThisItem.IdGrupo)
Verified answer

EdevaldoJeronim 99 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much @RandyHayes