I have a flow that looks through a list of people and pulls out those who have a birthday in the current month. It then formats that list as a table and emails it out. I would like to get the list to show up in date order, The Get Sharepoint list entry has an order by field, I just can't figure out the correct ODATA syntax. I want to sort just on the day of the month.
This query is ordered by SharePoint field named Created in descending order.
You must use the name of the column that SharePoint uses internally - not its display name.
To get the internal column name you need to go to the List (or Library) Settings page, then select your column.
Now look at the address bar of the browser window. Go to the end of the URL and look for the Field=
In the above example the internal name of the field is projectnumber . In this case both the internal name and display name happen to be the same.
OK - that gets me the field name - but how do I extract just the day from a date field for that? Do I need to create that in a variable in an earlier step? Won' t that require a loop to happen after the list is obtained?
I guess I could create a calculated field in the list to extract the day. Not sure about the syntax for that either, but I'll give it a try.
I created a calculated field in SharePoint to contain just the day of the birthday. Running the Flow I get the following error:
The field 'BDay_Date' of type 'Calculated' cannot be used in the query sort expression.
Can calculated fields not be used for this?