You’re offline. This is a read only version of the page.
4
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
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!
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?
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,962
Most Valuable Professional
Share
Report
All responses (
Answers (
