Answered

Deleting SharePoint list item/items if conditions met

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am new to using Power platforms and hoping someone can help. I am in the process of making a app in power apps to record absences/sickness & Leave request. The App feeds into 2 SharePoint Lists. Name of Lists and columns Detailed below:

(List 1)

Employee Number
Surname
First name
Date of absence
Reason for Absence

(List 2)

Employee Number
Surname
First name
First day of absence
Last day of absence
Reason for Absence

The issue I have is if a entry is added to the (List 2) I need a way for it to check to see if there is a matching Employee number in (List 1) if so, it would need to check if the date of absence in (List 1) falls on or between the First day of absence and the Last day of absence on (List 2). If this is the case I need it to delete that/those entries in (List 1).

I hope this makes sense if you need any clarification on anything let me know.

Thanks

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (1)

Report
Re: Deleting SharePoint list item/items if conditions met

Hi @Anonymous ,

I've made a test for your reference:

1\List1:

2\List2:

3\My Flow

1)

@and( and( equals(item()?['EmployeeNumber'], triggerOutputs()?['body/EmployeeNumber']), greaterOrEquals(item()?['Dateofabsence'], triggerOutputs()?['body/Firstdayofabsence'])), lessOrEquals(item()?['Dateofabsence'], triggerOutputs()?['body/Lastdayofabsence']) )

2)

items('Apply_to_each')?['ID']

Best Regards,

Bof

Was this reply helpful? Yes No
Vickylovesdiak 7 on at

Like (0)

Report

Re: Deleting SharePoint list item/items if conditions met

L

Was this reply helpful? Yes No
Vickylovesdiak 7 on at

Like (0)

Report

Re: Deleting SharePoint list item/items if conditions met

D

Was this reply helpful? Yes No
Vickylovesdiak 7 on at

Like (0)

Report

Re: Deleting SharePoint list item/items if conditions met

F

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

Like (0)

Report
Re: Deleting SharePoint list item/items if conditions met

Hi

Thanks for the help i am still a bit stuck when i am trying to put
items('Apply_to_each')?['ID']
it is asking for a valid integer when i run a test

Thanks

Was this reply helpful? Yes No