Unanswered

Using multiple lists in a single app

(1) Share

Report

Posted on by arthurgand

OBS: If there are any links already resolved please send them to me!!

I'm starting to powerapps, my question is the following, can I use 4 sharepoint picklists, in one form for another list?

For example>
List 1 - Parts Model
List 2 - Vehicle Model
List 3 - Employees
List 4 - Status

And I use the Main List to save everything
List 5 - Main

The idea is to create a form, where bring the options of the first 4 lists and save via PATCH everything in list 5. I even tried to do some things, but I don't know how I should create the list, if for example where it is a drop list, should I put it as drop or leave it only as text

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @arthurgand ,
Let try this write this code in form on Success Property
Patch( List5, Defaults(List5), { Title: TextInput1.Text, PartModel: Dropdown1.Selected.Value, VehicleModel: Dropdown2.Selected.Value, Employee: Dropdown3.Selected.Value, Status: Dropdown4.Selected.Value } )
Make sure to replace TextInput1, Dropdown1, Dropdown2, Dropdown3, and Dropdown4 with the actual names of your controls.
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali
arthurgand on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect, I did it this way, but I have a problem possibly between my list and what I'm going through via patch, it returns me that he's expecting a record, but he's passing a text.
I don't know if that's the only mistake in question as well
CODE:
Patch(
OS_Detalhes;
Defaults(OS_Detalhes);
{
Empresa: txtEmpresa_1.Text;
Criado: DataIN_1.SelectedDate;
DataBaixa: DataOUT_1.SelectedDate;
KMSaida: Value(txtKMIN_1.Text);
KMChegada: Value(txtKMOUT_1.Text);
Observacao: txtOBS_1.Text; // So far no problems
Foto1: AddMediaButton2_1.Media;
Foto2: AddMediaButton3_1.Media;
Foto3: AddMediaButton4_1.Media;
Usou_Peca: PecasEscolhidas;
Colaborador: ColaboradorEscolhido;
Situacao: StatusEscolhido;
PlacaVeiculo: PlacaEscolhida
}
);;
Notify("Registro Atualizado"; NotificationType.Success)
M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @arthurgand ,
Try This
Patch( OS_Detalhes, Defaults(OS_Detalhes), { Empresa: txtEmpresa_1.Text, Criado: DataIN_1.SelectedDate, DataBaixa: DataOUT_1.SelectedDate, KMSaida: Value(txtKMIN_1.Text), KMChegada: Value(txtKMOUT_1.Text), Observacao: txtOBS_1.Text, Foto1: AddMediaButton2_1.Media, Foto2: AddMediaButton3_1.Media, Foto3: AddMediaButton4_1.Media, // Assuming 'Usou_Peca' is a Choice field Usou_Peca: ForAll(PecasEscolhidas, {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value: Value}), // Assuming 'Colaborador' is a People field Colaborador: {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: ColaboradorEscolhido.Selected.Claims}, // Assuming 'Situacao' is a Choice field Situacao: {Value: StatusEscolhido.Selected.Value}, // Assuming 'PlacaVeiculo' is a Text field PlacaVeiculo: PlacaEscolhida.Selected.Value } ); Notify("Registro Atualizado", NotificationType.Success);
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali
arthurgand on at

Like
a
(0)

Report
Copy link

Link copied!

Still returned error, I have the fields with errors:

is in Drop-down type:
Contributor = drpColaborador_1
VehicleLicense Plate = drpPlaca_1
Situation = drpSituacao_1

It's in type list box:
Usou_Peca = listaPeca_1

In my list, all of these fields are ready to receive single-line text type