WHY update item replaced previous record

[Anonymous]

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:

[Willemijn]

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')}'

[v-bacao-msft]

Hi @Anonymous ,

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.

Best Regards,

[Anonymous]

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

[ScottShearer]

@Anonymous 

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

[Anonymous]

hi @ScottShearer ,

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

[Anonymous]

@ScottShearer  ??