cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

PowerApps And SharePoint Magic?

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Impactful Individual
Impactful Individual

Re: PowerApps And SharePoint Magic?

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)

View solution in original post

2 REPLIES 2
Highlighted
Impactful Individual
Impactful Individual

Re: PowerApps And SharePoint Magic?

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)

View solution in original post

Highlighted
Anonymous
Not applicable

Re: PowerApps And SharePoint Magic?

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

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,437)