Unanswered

Need a script to automate removing older listings based on 'Return Date' in Excel on Sharepoint

(0) Share

Report

Posted on by KennethM87

Hello,

I am needing to create a script to automatically remove an entire row(s) within an entire table based on the 'Return Date' in my document. For an example on what my document looks like, I have attached a screenshot (above).

Essentially, I am needing a script that automatically removes an entire row if it is earlier than today's date (whatever day that is). I have been trying to use the 'record' option so the script can read my commands, and I can get it to delete a row, but it is not doing exactly what I need it to do. Any assistance is much appreciated.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @KennethM87 ,
after using the Action "List rows present in a table", please follow these steps:
in a "Compose" action, format your Return Date value using an expression like "formatDateTime('<your_value>'),'yyyy-MM-dd');
Condition: if the Outputs of your previous Compose action is less than today (use an expression like "formatDateTime(utcNow(),'yyyy-MM-dd')"), Delete the row.

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

Was this reply helpful? Yes No
KennethM87 2 on at

Like (0)

Report
Copy link

Link copied!

I am still new to scripting, so please forgive me. I inputted the same information you gave me, minus adding my tables & documents for the script to reference, but I am getting this error when I save the script:
I know you stated that I need to put my value into this section, but I am honestly not sure what I would input there for the script to reference. I really appreciate you helping with this.

Was this reply helpful? Yes No