Unanswered

Order of information in html table

(0) Share

Report

Posted on by MrFrankenfurter

Hi, I have a power automate flow that pulls information from a sharepoint list and places it into an array variable, that is later converted into a HTML table and some CSS added before emailing out to a list of people.

My issue is that the flow pulls the last three items from the list, which are the shifts in the workplace - Early, Late and Night.

These items will appear in a random order in the email, i.e. sometimes Early Late Night (desired) but other times Late, Early, Night etc.

Is there a way of ensuring the items appear in the order 'Early Late Night'? They are always stored in the list in this order

Thanks in advance

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Expiscornovus 33,851 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @MrFrankenfurter,

I see you are using Modified as a field for sorting. Modified is a date and time field, so every value is unique. This probably explains why it always is in a random order.

Do you by any chance have another date column in your list setup? Like shift date?

Was this reply helpful? Yes No
MrFrankenfurter 4 on at

Like (1)

Report
Copy link

Link copied!

Thanks @Expiscornovus

Frustratingly no, I use modified (I could use created) because the shifts are inputted via an MS Form which does not have a time field. Allowing users to add their own time in plain text is a bit of an issue. The form is passed through a power automate flow which creates the item in a sharepoint list, so usually modified = created.

Typing this out got me thinking though - and I've altered the flow which creates the sharepoint items from the form to enter the items in the order I need and delay in between each item - which should give them a unique created (and therefore modified) time and hopefully get them in the right order.

Thanks!

Was this reply helpful? Yes No