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

WHY update item replaced previous record

Need your kindness Help here,

 

Im working on ms flow for the Multiple user can trigger button clock in and clock out. The user which trigger the button will update the item in SPlist. however i find something wrong while trigger for Out which the item for previous record will be replaced. I just want it replaced on latest record / follow user record. My flow as below:

 

flow.PNG

6 REPLIES 6
Willemijn
Level 8

Re: WHY update item replaced previous record

Hi, 

 

With the action get items, you will get all items of that list. If you then choose to apply to each to update the item, you will update the item x times for all items in the list. My advise is to first filter the list of the get items by date (today) and then check the user (I didn't figure out how to do this in the Odata query so My get items looks like this: 

 

Datum is the fieldname of the date field, and the formula is this: 

Datum eq '@{formatDateTime(utcNow(),'yyyy-MM-dd')}'

 

2019-07-15 15_06_59-Edit your flow _ Microsoft Flow.png

 

 

 

Community Support Team
Community Support Team

Re: WHY update item replaced previous record

Hi @safuanAXO ,

 

If you want to update the latest record, you could refer to the configuration below.

Use Order by and Top Count to get the latest record, then update the item.

33.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
safuanAXO
Level: Powered On

Re: WHY update item replaced previous record

hi @v-bacao-msft 

 

I follow guide as u mentioned earlier, i put employee name as my Order field and Top count =1. The problem is when

Example Scenario:

Employee A clock in and Out - success update in sharepoint List ( IN and OUT column)

Employee B Clock in - Success update clock IN

Employee B Clock out - It will replaced clock out Employee A also. 

 

I wondering there is some function or method ive doing this wrong. please help and thanks for your kind reply

Capture.PNG

 

 

Highlighted
Super User
Super User

Re: WHY update item replaced previous record

@safuanAXO 

I believe you can get this working if you add an OData filter to your existing configuration.  You need to retrieve only the records for the employee who is ckecking out.

 

The filter will look something like this:

EmployeeClaims eq 'Email of the person who clicked the button from Dynamic properties'

 

You'll need the single quotes.

OData filters usually use a columns internal name.  So, create a new flow and use get items to retireve items from the attendance list.  Run the flow and ckeck to output of the Get items action.  You'll need to refer to the Employee claims column in exactly the same way as it shouws in the output.

You'll still want Order By ID Desc and Top count of 1

 

 

 

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
safuanAXO
Level: Powered On

Re: WHY update item replaced previous record

hi @ScottShearer ,

 

ive try your solution on this. but no output in sharepoint. can u advise on this ? Thanks for your feedback

Capture1.PNG

 

 

 

Capture2.PNG

safuanAXO
Level: Powered On

Re: WHY update item replaced previous record

Helpful resources

Announcements
firstImage

Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

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 Flow Community Video Gallery!

Users Online
Currently online: 45 members 4,350 guests
Please welcome our newest community members: