Hi @JacksonDas
Pls refer the below sample flow to fetch shifts based on today's date and save details into excel sheet.
Here, the Input excel has been uploaded on SharePoint document library with table created in it:
Here are the actions which you can used for saving shifts details in excel sheet:
1. Add "List Shifts" action to get all the shifts for a team. Select the team from the drop down and to filter the shift for a day, we need to write an expression in "From Start Time" & "To End Time":
Expression used for Start time parameter:
@{startOfDay(utcNow())}
Expression used for End time parameter:
@{startOfDay(addDays(utcNow(),1))}
Next, we iterate the shift list using "Apply to each" action and get the details like assigned to, start time, end time & notes:
Now, as shift list returns the user id of the assigned to so we add "Get user profile" action to get the name from the user id:
Expression used in the above screenshot:
item()?['userId']
Finally, we will use "Add a row in table" action to add the details in the excel sheet:
Choose the Display Name from the dynamic content returned by "Get user profile" action
For other columns - start time, e:nd time & notes, I have used expressions:
| Fields or Columns |
Expression |
| Start Time |
convertFromUtc(item()?['sharedShift/startDateTime'],'India Standard Time','MM-dd-yyyy hh:mm tt')
|
| End Time |
convertFromUtc(item()?['sharedShift/endDateTime'],'India Standard Time','MM-dd-yyyy hh:mm tt')
|
| Notes |
item()?['sharedShift/notes']
|
here, I have converted UTC time to IST, pls modify the time zone as per your need.
The output obtained by this flow:
I hope this will give you some idea to start designing the desired flow.
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
