Remove items in sharepoint library that does not match

(0) Share

Report

Posted on by MortenBak

152

Hello everyone,

I'm trying to expand an app, where I've come across a challenge.

I have a button that creates a new item in a sharepoint library, based on week numbers, and I only want the newest week to appear in the library for other use in the app.
But I dont know how to write the code I need for it to look up in the sharepoint library, and remove other elements that does not have the week number I just wrote.

I'm looking for something like

If(
 Lookup(
 Sharepoint library; Title != Textinput.Text);
#Where I want it to delete the items that does not equal the week number, and not do anything if it is the same

But I dont know how to write the code.

Any help is much appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @MortenBak ,

If you want to remove items in the library based on conditions, you can try using the formula RemoveIf().

My library:

Add a Button to the app and set the ‘OnSelect’ to the following formula:

RemoveIf(Test11,Not(WeekNum(Created)=WeekNum(Today())) Or Not(Year(Created)=Year(Today())))

After clicking, It removed files that are not this week.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

MortenBak 152 on at

Like (0)

Report
Copy link

Link copied!

Hello Wearsky,

I played with some other ways of doing it, and ended up using Last(Sharepointlist), and then creating a flow to delete files thats older than a month. I'm sure this would have done the trick as well, and I'll probably add this the next time I'm playing with PowerApps.

Thank you for the response!

Was this reply helpful? Yes No