Hi everyone,
based on the video from April (https://www.youtube.com/watch?v=vuBuPxOY8uM) I built the following code. The difference to April's code is that I want to directly switch the order in gallery based on a table and not use a helpcollection.
Unfortunatly I got the Error to define the PowerAppID. Have somebody an idea?
Looking forward to hearing from you 🙂
Select(Parent);;
UpdateContext({previousRecord:LookUp(
Tabelle10;
Order=ThisItem.Order-1)
});;
Update(
Tabelle10;
previousRecord;
{
Verteiler: previousRecord.Verteiler;
Name: previousRecord.Name;
Firma: previousRecord.Firma;
Funktion: previousRecord.Funktion;
Telefon: previousRecord.Telefon;
email: previousRecord.email;
Order: ThisItem.Order;
ProjektNr: previousRecord.ProjektNr
}
);;
Update(
Tabelle10;
ThisItem;
{
Verteiler: ThisItem.Verteiler;
Name: ThisItem.Name;
Firma: ThisItem.Firma;
Funktion: ThisItem.Funktion;
Telefon: ThisItem.Telefon;
email: ThisItem.email;
Order: previousRecord.Order;
ProjektNr: ThisItem.ProjektNr
}
)
Solved! Go to Solution.
Hi @WarrenBelz ,
thanks for your response. Unfortunatly he cant find the field ID.
I try it just by changig Update to Patch. These seem to work. Thx a lot. Below the code:
Select(Parent);;
UpdateContext({previousRecord:LookUp(
Tabelle10;
Order=ThisItem.Order-1)
});;
Patch(
Tabelle10;
previousRecord;
{
Verteiler: previousRecord.Verteiler;
Name: previousRecord.Name;
Firma: previousRecord.Firma;
Funktion: previousRecord.Funktion;
Telefon: previousRecord.Telefon;
email: previousRecord.email;
Order: ThisItem.Order;
ProjektNr: previousRecord.ProjektNr
}
);;
Patch(
Tabelle10;
ThisItem;
{
Verteiler: ThisItem.Verteiler;
Name: ThisItem.Name;
Firma: ThisItem.Firma;
Funktion: ThisItem.Funktion;
Telefon: ThisItem.Telefon;
email: ThisItem.email;
Order: previousRecord.Order;
ProjektNr: ThisItem.ProjektNr
}
)
Hi @vinc1992 ,
This should do it if I have read your requirements correctly
Select(Parent);;
UpdateContext(
{
previousRecord:
LookUp(
Tabelle10;
Order = ThisItem.Order - 1
)
}
);;
Patch(
Tabelle10;
{ID:previousRecord.ID};
{
Verteiler: previousRecord.Verteiler;
Name: previousRecord.Name;
Firma: previousRecord.Firma;
Funktion: previousRecord.Funktion;
Telefon: previousRecord.Telefon;
email: previousRecord.email;
Order: ThisItem.Order;
ProjektNr: previousRecord.ProjektNr
}
);;
Patch(
Tabelle10;
{ID: ThisItem.ID};
{
Verteiler: ThisItem.Verteiler;
Name: ThisItem.Name;
Firma: ThisItem.Firma;
Funktion: ThisItem.Funktion;
Telefon: ThisItem.Telefon;
email: ThisItem.email;
Order: previousRecord.Order;
ProjektNr: ThisItem.ProjektNr
}
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Hi @WarrenBelz ,
thanks for your response. Unfortunatly he cant find the field ID.
I try it just by changig Update to Patch. These seem to work. Thx a lot. Below the code:
Select(Parent);;
UpdateContext({previousRecord:LookUp(
Tabelle10;
Order=ThisItem.Order-1)
});;
Patch(
Tabelle10;
previousRecord;
{
Verteiler: previousRecord.Verteiler;
Name: previousRecord.Name;
Firma: previousRecord.Firma;
Funktion: previousRecord.Funktion;
Telefon: previousRecord.Telefon;
email: previousRecord.email;
Order: ThisItem.Order;
ProjektNr: previousRecord.ProjektNr
}
);;
Patch(
Tabelle10;
ThisItem;
{
Verteiler: ThisItem.Verteiler;
Name: ThisItem.Name;
Firma: ThisItem.Firma;
Funktion: ThisItem.Funktion;
Telefon: ThisItem.Telefon;
email: ThisItem.email;
Order: previousRecord.Order;
ProjektNr: ThisItem.ProjektNr
}
)
Yes, that would work as well (looks pretty close to what I posted, but ID is better if you can get it). I assume my post assisted you to get there.