SOLVED

SharePoint list with buttons to quickly change state of record

%3CLINGO-SUB%20id%3D%22lingo-sub-1924625%22%20slang%3D%22en-US%22%3ESharePoint%20list%20with%20buttons%20to%20quickly%20change%20state%20of%20record%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1924625%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20creating%20a%20SharePoint%20list%2C%20which%20I%20want%20the%20user%20to%20be%20able%20to%20read%20through%20and%20just%20toggle%20%22OK%22%20or%20%22Not%20OK%22.%20I%20created%20buttons%20on%20the%20column%20and%20then%20a%20flow%20to%20toggle%20from%20%22OK%22%20to%20%22Not%20OK%22%20or%20vice%20versa.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22shahmatwu_0-1606153398728.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F235603i8C89EABED6D87EEF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22shahmatwu_0-1606153398728.png%22%20alt%3D%22shahmatwu_0-1606153398728.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20with%20this%20is%20that%20every%20click%20requires%20the%20user%20to%20confirm%20that%20the%20flow%20will%20run%2C%20which%20makes%20the%20buttons%20impractical%20for%20doing%20work%20quickly.%20I%20wanted%20the%20user%20to%20be%20able%20to%20just%20go%20down%20the%20list%20and%20click%20%22OK%22%20on%20all%20records%20that%20are%20okay%2C%20then%20either%20update%20them%20as%20they%20get%20clicked%2C%20or%20update%26nbsp%3B%20them%20all%20as%20a%20batch%20at%20the%20end.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20assume%20that%20the%20only%20way%20to%20have%20some%20control%20on%20a%20column%20that%20will%20change%20a%20record's%20state%20is%20to%20change%20it%20via%20a%20flow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20get%20the%20user%20to%20edit%20in%20Grid%20View%20either%20as%20this%20just%20would%20not%20be%20user-friendly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20advise%20whether%20what%20I'm%20trying%20to%20do%20is%20possible%3F%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1924625%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1924807%22%20slang%3D%22de-DE%22%3ESubject%3A%20SharePoint%20list%20with%20buttons%20to%20quickly%20change%20state%20of%20record%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1924807%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F879076%22%20target%3D%22_blank%22%3E%40shahmatwu%3C%2FA%3E%20you%20could%20create%20a%20PowerApps%20app%20on%20that%20SharePoint%20List%20as%20Datasource%2C%20without%20a%20flow.%3C%2FP%3E%3CP%3EAnd%20I%20think%20your%20users%20e.g.%20all%20users%20will%20learn%20to%20use%20the%20QuickEdit%20Mode%20as%20well%2C%20if%20you%20have%20the%20time%20and%20nerves%20to%20teach%20them.%20But%20I%20bet%3A%20It's%20worth%20it%20more%20than%20any%2012th-corner-flow...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreets%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1926410%22%20slang%3D%22en-US%22%3EBetreff%3A%20SharePoint%20list%20with%20buttons%20to%20quickly%20change%20state%20of%20record%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1926410%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F153902%22%20target%3D%22_blank%22%3E%40Eva%20Vogel%3C%2FA%3E%26nbsp%3Bthank%20you!%20I'll%20try%20creating%20a%20Power%20Apps%20form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20with%20QuickEdit%20mode%20is%20that%20it%20takes%203%20clicks%20to%20toggle%20a%20value%20(click%20to%20select%2C%20click%20to%20Yes%2FNo%20dropdown%2C%20click%20to%20select%20Yes%2FNo).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2014442%22%20slang%3D%22en-US%22%3EBetreff%3A%20SharePoint%20list%20with%20buttons%20to%20quickly%20change%20state%20of%20record%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2014442%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F153902%22%20target%3D%22_blank%22%3E%40Eva%20Vogel%3C%2FA%3E%26nbsp%3BThat%20was%20a%20bit%20of%20a%20learning%20curve%20and%20I%20still%20have%20some%20issues%20with%20the%20quirks%20of%20Power%20Apps%2C%20but%20I%20did%20eventually%20implement%20what%20you%20suggested%20and%20it%20more%20or%20less%20meets%20my%20needs.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello!

 

I'm creating a SharePoint list, which I want the user to be able to read through and just toggle "OK" or "Not OK". I created buttons on the column and then a flow to toggle from "OK" to "Not OK" or vice versa.

shahmatwu_0-1606153398728.png

 

The problem with this is that every click requires the user to confirm that the flow will run, which makes the buttons impractical for doing work quickly. I wanted the user to be able to just go down the list and click "OK" on all records that are okay, then either update them as they get clicked, or update  them all as a batch at the end.

 

I assume that the only way to have some control on a column that will change a record's state is to change it via a flow.

 

I can't get the user to edit in Grid View either as this just would not be user-friendly.

 

Can someone please advise whether what I'm trying to do is possible? Thank you!

3 Replies
best response confirmed by shahmatwu (New Contributor)
Solution

@shahmatwu you could create a PowerApps App on that SharePoint List as Datasource, without a flow.

And I think your users e.g. all users will learn to use the QuickEdit Mode as well, if you have the time and nerves to teach them. But I bet: It´s worth it more than any 12th-corner-flow...

 

Greets, Eva.

@Eva Vogel thank you! I'll try creating a Power Apps form.

 

The problem with QuickEdit mode is that it takes 3 clicks to toggle a value (click to select, click to Yes/No dropdown, click to select Yes/No).

@Eva Vogel That was a bit of a learning curve and I still have some issues with the quirks of Power Apps, but I did eventually implement what you suggested and it more or less meets my needs. Thank you!