Hey I'm working on a process that would allow me to delete sharepoint items based on a 6 digit code that is pre-populated in the list. So, my thinking is as follows:
Trigger - when file is modified in sharepoint
list rows present in table (pointing to the specific excel file and table in Sharepoint - just to clarify, there is only one column in the table)
Apply to each - output is the value from the list rows
Get items action - pulls list items from Sharepoint list
Apply to each - value from the get items
Condition - if code on the excel table equals code on sharepoint list
if yes, delete item - list is the same list in get items and the ID is the ID in Get Items
if no, do nothing
I can't seem to get this working, if anyone could help me out, that would be great! :)
Can you mention where you struck and what's your problem, any errors you are getting in any of the step, list in detail, So that we can try to resolve
(If this answers your question you can mark as Answered and give it a Like)
Regards,
Srini
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
3,327
