Microsoft Flow PowerApps Projects Time Management Apps - Part 1

Goal is to be able to manage how much time (in hours and minutes) the company spent each month. 
Each Employee should write down when he started and when he finished, and calculate the time. 
At each period of time we should be able to get a report of total time spend per client. 

Design: 

Data will be 2 SharePoint lists, one for clients names, other for the time spent. 
List 1 is Title only for client name. 
List 2:
  • Title - client name
  • Created - start time
  • Created By - employee
  • EndTime - end time ☺
  • TotalTime - calculated field for time (=TEXT(EndTime-Created, "hh:mm"))

App1 - Employee chooses client, has 2 buttons, start and end
App2 - Manager can choose month and gets a list of clients with their total time

Lets start, SP as states

App1


Drop "Items" Connected to SPList and "Value" to Title.
Button Start to Flow is very simple, create a sharepoint list item with title of selected client.
Since i wanted some message in the app i had the flow to return some answer with the current time, using "Convert time zone" step to convert "utcNow()" function to my format "hh:mm"



Start Button OnSelect
Set(MessageToClient, 'TimeRecordForEmployee_CreateItem'.Run(ddlClient.SelectedText.Value))

For the End Button the flow is a bit more complicated
We need to search the latest item for that client, so we start with "Get items" step, filtering Title to the value from the PowerApp and Order By "EndTime asc". Top count to 1, for ease.

*NOTE when i tried 2 filter i got and error using "AND", you must use "and".


Next we need to extract the ItemId, and the Title for the update step. also calculate the Now Time like last flow



Item extraction from array
Get 1st item from the "Get items" step, if not null use body content, body has "value" property, and that's the array, so 1st item from that, them get field.

first(outputs('Get_items')?['body/value'])['ID']
first(outputs('Get_items')?['body/value'])['Title']

Finishing the flow with "Update item" and respond, since Title is a Required field we must re-set it, and also we need the item is. For the EndTime we're using "utcNow()"




Part 2 for App2

Comments

Post a Comment

Popular posts from this blog

OverTheWire[.com] Natas Walkthrough - JUST HINT, NO SPOILERS

game portal: http://overthewire.org/wargames/natas/ PASSWORDS for each level are stored in /etc/natas_webpass/natasX I made this walkthrough for people like me, i needed some help, but didnt want the spoiler, so here i will give you all the information needed to pass each level, yet not the solution. For levels needed custom web request i made a different post for powershell and javascript  with how-to's, since is a piece of learning for itself, and also for those of us that play at work and have only powershell at their hands. Although its not a complete spoiler there, its quite most of the solution so try yourself 1st. Natas The Natas game is from basic to advances web hacking. Every few levels is about whole new exploitation (with some harder ones doing comeback later), so a lot of learning. If you're new, you're the reason i am writing so much even for the 1st level, just please google EVERY topic you see, since in the following levels i assume you know the ...
Read more

Asp.Net Ending Response options, Response.End() vs CompleteRequest()

this blog is for any1 who get the ThreadAbortException when caling Response.End(), and then tried the other options such as HttpContext.Current.ApplicationInstance.CompleteRequest() and found out that there was no replacement. i'll start with the bottom line: if you want to stop right now your response and send it as is you dont have any other option other than Response.End(), period and it's the right thing to throw that EX in that case. the answer is its because there is the "HTTP pipeline" and the "Asp.Net pipeline", and CompleteRequest() cuts the HTTP pipeline but not the Asp.Net one so everything that is from handlers forwars (including all page events) continues but your part, the asp one, stays in your hands so that no information will be lost, so ur suppose to manage your code currectly, since information lost is really a bad thing, although in most cases we use Response.End() we know what we are losing and we want it. see this short article ab...
Read more

SOLVED The item could not be indexed successfully because the item failed in the indexing subsystem

if you got an error like this The item could not be indexed successfully because the item failed in the indexing subsystem. ( The item could not be indexed successfully because the item failed in the indexing subsystem.; Failed to recover content group; Aborting insert of item in Link Database because it was not inserted to the Search Index.; ; SearchID = 04081656-B51B-4DCD-96D4-6DB2D2CEEEE7 ) as well as these: The item could not be indexed successfully because the item failed in the indexing subsystem. ( The item could not be indexed successfully because the item failed in the indexing subsystem.; Caught exception when preparing generation GID[7]: (Previous generation (last=GID[6], curr=GID[7]) is still active. Cannot open GID[7]); Aborting insert of item in Link Database because it was not inserted to the Search Index.; ; SearchID = 92EB0180-C086-4853-BED8-F4878D9748AD ) the solution for me was to clear configuration cache (PS)  and then restart SP Search Services. THX ...
Read more