Скачать или смотреть Compare 2 Collections for Unsaved Changes in Power Apps

Learn how to compare 2 collections using a simple formula in Power Apps.
✔️ Compare collections in Power Apps.
✔️ Handling DataCard values in New and Edit forms.
✔️ Conditional pop-up based on comparison.
✔️ Using ShowColumns

Whether you're managing data in SharePoint or another data source, this tutorial is packed with practical tips and real-world examples.

🎯 Perfect For:

Beginners seeking practical knowledge.
Intermediate users refining their app-building skills.

Don't forget to 👍 like, 💬 comment, and 🔔 subscribe for more Power Apps tips and tricks!
Happy 2025, we have a new Intro!

Entire Formula Used:
//Checks New Form
If(
varFormMode = "New",
//Checks if Not Blank on New Form
If(
!IsBlank(DataCardValue12.Value) Or !IsBlank(DataCardValue13.Value) Or !IsBlank(DataCardValue14.Selected.Value),
UpdateContext({varPopUp: !varPopUp}),
Navigate(SCREEN_RADIOS,ScreenTransition.Fade)),
//Checks Edit Form

//Collects Current Data in Datasource
ClearCollect(
colCurrentData,
ShowColumns(
Filter(
Accessories,
ID = tblSelectedAccessory.Selected.ID
),
Title,
ModelNum,
Color,
ID
)
);
//Collects Current Data in Accessory Form
ClearCollect(
colAccessoryForm,
{
Title: DataCardValue12.Value,
ModelNum: DataCardValue13.Value,
ID: DataCardValue6.Value,
Color: DataCardValue14.Selected
}
);
//Check if Datasource and Current Data Are Equal
If(
First(colCurrentData).Title = First(colAccessoryForm).Title And First(colCurrentData).ModelNum = First(colAccessoryForm).ModelNum And First(colCurrentData).Color.Value = First(colAccessoryForm).Color.Value,
Navigate(SCREEN_RADIOS,ScreenTransition.Fade),
UpdateContext({varPopUp: !varPopUp})
)
)

Chapters
0:00 Introduction
0:59 The Question
3:56 Organizing your Data
4:15 Create First ClearCollect
5:48 ShowColumns
9:16 Collect Current Form Data
11:15 Visually Comparing the 2 Collections
13:06 Formula to Compare
16:51 Combining into One Giant Formula
18:35 Creating a New Variable for New FormMode
19:30 Organizing the Formula with Comments
20:56 Testing
23:40 Conclusion