Power Platform Community Forum Thread Details

Hello everyone,

I want to create a form to edit data from multiple database with the same column name but a different name (Ex. "Group1", "Group2", "Group3", "Group4").

I was expect PowerApps to send the data to modify go to 'Storage one' to store the data that need to be corrected.

After that, on the second page, it will be a 'Review page' by collect information from 'Storage' to show result and review.

If I review 'OK', it will send this data to edit the database by the column name must match the database name.

I have a question,

Can I use a variable to select a database from SharePoint or car I Store the data in a 'Table' function'?

//Collection variable for select a database
Set(
VarStorage,
"Group " & DataCardValue10.Selected.Value
);

//record data in table
Set(
VarDatabase,
Table(
{
Machine: DataCardValue49.Text,
'Process number': DataCardValue50.Text,
Detail: DataCardValue51.Text,
'Item assembly': DataCardValue52.Text,
'Part assembly': DataCardValue53.Text,
Equipment: DataCardValue54.Text,
'Tools image': DataCardValue55.Image,
'Process image': DataCardValue57.Image,
Group: {
Id: Value(DataCardValue14.Selected.Value),
Value: DataCardValue13.Selected.Value
},
MACHINE: {
Id: Value(DataCardValue15.Selected.Value),
Value: DataCardValue10.Selected.Value
}
}
)
);

-------------------------------------------------

If i review OK, it will edit the data in database name

Switch(
VarStorage,
"Group1",
UpdateIf(
'Group1',
Register = DataCardValue12.Text,
VarDatabase),
"Group2",
pdateIf(
'Group2',
Register = DataCardValue12.Text,
VarDatabase),
"Group3",
pdateIf(
'Group3',
Register = DataCardValue12.Text,
VarDatabase),
"Group4",
pdateIf(
'Group4',
Register = DataCardValue12.Text,
VarDatabase)
)