web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApps And SharePoi...
Power Apps
Answered

PowerApps And SharePoint Magic?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello PowerApp Users,


I was wondering if anyone from community could help please? Would PowerApps be an efficient tool to use for the following:-
A Certificate SharePoint list where new records are added but currently it's a manual process to remove the older records (the odler records have a need to be retained so they are archived).


Each record contains five variables and the manual user process is currently to check to see if the first four variables match and the fifth variable (date field) is more recent than the previous entry. I've written the rough code as below


IF [V1] ISMATCH AND IF [V2] ISMATCH AND IF [V3] ISMATCH and IF [V4] ISMATCH AND IF [new V5-Date] is >= [previous V5-Date] THEN CERTIFICATE= "Current" ELSE "Old"


Any help would be very much appreciated!

Categories:
  • Verified answer
    Delid4ve Profile Picture
    795 on at

    Yes it could be used.

    You could have a simple form to input the new data.

    A confirm button could then do the following:

     

     

    Removeif(sharepointlist,ID=Lookup(sharepointlist,field1=Valueinapp And field2=valueinapp And field3=valueinapp And field4=valueinapp,ID));Patch(sharepointlist,Defaults(sharepointlist),{field1:Valueinapp,field2:valueinapp,field3:valueinapp,field4:valueinapp})

    I dont know what your value types are so valueinapp represents a textbox/dropdown etc

     

    This is very simple and you could build in a couple hours with minimal knowledge, about 10 minutes once you are familiar.

    The for would need to be set to new mode (now need for edit form unless you need to make changes to existing records.

     

    If you set up anothe list (archive) with the same fields you can also patch that list before the removeif function to copy the old data accross first.

     

    If you want to get fancier you could then use flow, when a new item is created in list, to automatically create your new certificate and store it in a document library, save it to a local network folder, convert it to pdf etc etc.. 

     

    the only manual entry would be the powerapps form then. (Please apologise to the person that is no longer required to do all this Smiley Indifferent)

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Brilliant! Thank you for very much for the assistance. Something for us to look into for sure!

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 409 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 252 Most Valuable Professional

Last 30 days Overall leaderboard