Hello Community,
I need your help please, I've built a Power Apps using an Editable Grid in Power Apps - Editable Grid in Power Apps | SharePoint List - YouTube
Now I want to take that data and trigger a Power Automate when the Save button is pressed, but I don't know where to start as I've not done anything like this before.
This is the OnSelect Property
If(
varGridEdit,
If(
!IsBlank(
LookUp(
colGridData,
FirstName = Blank() || FirstName = "" || Surname = Blank() || Surname = "" || Company = Blank() || Company = "" || IsEmpty(Visiting) || IsBlank(Visiting) || EmailAddress = Blank() || EmailAddress = "" || IsEmpty(DateTimeofArrival) || IsBlank(DateTimeofArrival)
)
),
Notify(
"Please fill required fields",
NotificationType.Error,
2000
),
Patch(
InVentryVisitors,
UpdateIf(
colGridData,
Created = Blank(),
{ID: Blank()}
)
);
Remove(InVentryVisitors,colDelete);
Notify(
"Grid Data Updated",
NotificationType.Success,
2000
);
Clear(colDelete);
Select(btnLoadData);
Set(
varGridEdit,
!varGridEdit
)
),
Set(
varGridEdit,
!varGridEdit
)
);
So when the Save button has been selected, new or modified data is patched back into the SharePoint list, and this is the data I want to capture and send ONE Email when this happens.
Any suggestions?
Thank you in advance
Claire
