cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stumiles86
Level: Powered On

Time Management

So I'm very new to flow and the endless possiblities but it boggles my mind.

 

Heres what i want to do.

We have 3 field engineers. I want them to be able to press a button when they start their project and have the date/time logged in a excel spreadsheet. Then when they finish press the button again and have the sheet find the last entry for that engineer and edit the row so the end time is filled in. as a bonus would be good if there was an input so they could specify what project they was working on.

 

EG:

Untitled.png

 

 

Any body brave enough to take on this challenge?

2 REPLIES 2
Gristy
Level 10

Re: Time Management

Hi @stumiles86 

 

Yes you will take on the flow challenge!

 

The below should help you figure out where to get started:

 

Flow Type: Manual

Trigger: Press a Button

- Get Rows in Table from the Excel

- Check to see if existing Row Exists for Today for Specific User

- If No create row with Name Date/Time

- If yes update row with Name Date/Time

 

I have not played with Get Row, but it may fail if there are no results so you may need to configure the run after. will look something like this:

Annotation 2019-10-16 062920.png

stumiles86
Level: Powered On

Re: Time Management

Hi @Gristy!,

So I currently have the following...

flow.png

If i select start when clicking the button I get a new entry with the name, current time in the start time field.

When i click stop on the button and check the log it gives me 1 result which is the entry with my username and a blank time finished cell.

 

However, how do i now update this row? everytime ive tried the update row it just updates the first entry that matches my username.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 442 members 5,644 guests
Please welcome our newest community members: