They are the two file names from your supplied code which are from the data source
Try with a collection, that way you can have a look what is in it after the code is run. I will go back a step in efficiency here as I cannot currently test why they are not there - I generally avoid using "one-use" Collections or Variables.
I am also wondering why you have those two actions inside your Patch at the start - they are separate functions.
Clear(colDups);
ForAll(
Filter(
Gallery3.AllItems,
Checkbox1.Value
) As _Data,
Collect(
colDups,
LookUp(
BCP,
UniqueID = _Data.TextInput2_1.Text && DateClosed = _Data.DataCardValue13_1.SelectedDate
)
)
);
If(
CountRows(colDups) > 0,
Notify(
"Entry Already Exists for " & Concat(
colDups,
UniqueID & " - " & Text(
DateClosed,
"dd/mm/yyyy"
),
", "
),
NotificationType.Error
),
UpdateContext({varShow:true});
Select(Button9);
Patch(
BCP,
ForAll(
Filter(
Gallery3.AllItems,
Checkbox1.Value
) As _Data,
{
Title: _Data.TextInputMarket.Text,
Address: _Data.TextInputAddress.Text,
City: _Data.TextInputCity.Text,
State: _Data.TextInputState.Text,
LocationConcat: _Data.DataCardValue17_1.Text,
Time: _Data.TimeDD.Selected,
DateClosed: _Data.DataCardValue13_1.SelectedDate,
Status: _Data.StatusCardValue16_2.Selected,
Reason: _Data.DataCardValue26_1.Text,
UniqueID: _Data.TextInput2_1.Text,
ISE: _Data.TextInputISE.Text,
Latitude: _Data.TextInputLatitude.Text,
Longitude: _Data.TextInputLongitude.Text,
Dealer: _Data.TextInputDealer.Text,
AD: _Data.CBAD.Selected,
DIR: _Data.CBDIR.Selected,
SrSpecialistSalesProgramExecution: _Data.CBSPE.Selected
}
)
);
Select(BTNLoadData);
Notify(
"Success! To see your entries click on My BCP Entries button",
NotificationType.Success
)
)
Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee
