Unanswered

WHY update item replaced previous record

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Willemijn 214 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

hi @ScottShearer ,

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer ??

Was this reply helpful? Yes No