Preset body of email to pull information with data in specific order

[AliDg2]

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. 

[AliDg2]

Hi,

the Service date is preset choice options that are set in the sharepoint list.

the drop down ddate is a field based on the date the person entered the data in the system. 

[WarrenBelz]

@AliDg2 ,

But what type of field is ServiceDate that you trying to filter on (date or text). And what exactly are the Items of the drop-down - I believe your issue lies here. You might need

Text(ServiceDate,ShortDate) = Text(DateValue(DdDate.Selected.Result),ShortDate)

 if ServiceDate is a Date field (and the dd has a valid date format as the output.

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.

[AliDg2]

sorry it is a text format not a date format.

this is the text i have set up for that:

Text(Now(),"[$-en-US]ddd, dd mmm yy")

[WarrenBelz]

@AliDg2 ,

Where do you use that formula?

[AliDg2]

that formula sits in the form that the user fills out

[WarrenBelz]

@AliDg2 ,

I am trying to work out what and how you are comparing here. I believe your problem is the date filter. You said the field was Text, do you store it dd/mm/yyyy etc and what are you seeing in your date drop-down to compare this with? You said the date drop-down was Service date is preset choice options that are set in the sharepoint list, yet in your formula you refer to ddDate.Selected.Result, which is a Distinct filter. Can you please tell me the Items of ddDate?

[AliDg2]

Sorry was at a work conference couldnt focus on getting this sorted. 

the date filter is stored as a text dd mmm yy. When we click the dropdown bar it brings up only the dates that have been entered in by the user. ie. if someone has put in the data of today. when  we go to the report page it shows that data. the items of ddDate are a collection based on info from service date. Does that make sense?

[WarrenBelz]

@AliDg2 ,

Can you please give me the Items property of your drop-down ddDate.

[AliDg2]

you mean this?

Sort(collectServiceDate, Result, Ascending)

[WarrenBelz]

@AliDg2 ,

That is the first time you have mentioned a collection in the drop-down. Where do you collect this and how?

You have to help me a bit here and provide all the information - I cannot see your model or data. I have offered a quick Teams session previously as we are in the same country.