Hi,
I have been trying to pull information different ways and i am still getting stuck.
i have a set of data in a gallery that when i send the email i want the information to pull the data in a specific order.
i have created a collection with the following code below which is run on start of the app
ClearCollect(
LocationSort,
{
Order: "a",
Title: "BNE Central"
},
{
Order: "b",
Title: "BNE Downtown"
},
{
Order: "c",
Title: "GRT Springfield"
},
{
Order: "d",
Title: "GC Central"
},
{
Order: "e",
Title: "GC North"
},
{
Order: "f",
Title: "SC North"
},
{
Order: "g",
Title: "SC South"
},
{
Order: "h",
Title: "DRW Malak / Palmerston"
}
);
ClearCollect(
CampusSort,
GroupBy(
LocationSort,
"Order",
"Title"
)
)
Then on the email button i have the following code:
Sort(
LocationSort,
"Order"
);
Office365Outlook.SendEmailV2(
User().Email,
"State Lead Service Report for" & " " & DDServiceBlock.Selected.Result & " " & DdDate.Selected.Result,
Concat(
Gallery3.AllItems,
"<p><br><b>" & GLCampus.Text & "-" & BsubmitBy.Text & "</b><br>" & "</b><br>" & GFinalRepor_1.Text & "</p>" & "</b><br>"
)
);
Notify("Email Sent")
However the information still doesnt want to pull the data based on the order specified onstart.
Any help would be appreciated. I even thought of hardcoding the body of the email but unsure how to do that.
