Set availability in SharePoint Online list and connect it with flow

%3CLINGO-SUB%20id%3D%22lingo-sub-756549%22%20slang%3D%22en-US%22%3ESet%20availability%20in%20SharePoint%20Online%20list%20and%20connect%20it%20with%20flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756549%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20shift%20schedule%20in%20a%20SPO%20List.%3C%2FP%3E%3CP%3EIdeally%20we%20should%20have%20an%20option%20for%20each%20person%20to%20set%20themselves%20as%20available.%20For%20that%20i%20created%20a%20yes%2Fno%20column%20called%20%22Available%20now%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScenarios%20that%20would%20work%20me%3A%3C%2FP%3E%3CP%3E-%20Person%20edits%20their%20own%20item%20in%20the%20list%2C%20sets%20availability%20field%20of%20their%20item%20to%20yes%20or%20no%2C%20and%20it%20triggers%20an%20email%20through%20the%20flow.%3C%2FP%3E%3CP%3E-%20Person%20sends%20an%20email%20through%20the%20flow%20(or%20any%20other%20possible%20trigger%2C%20if%20you%20have%20some%20idea%20feel%20free%20to%20say%20it)%2C%20and%20it%20automatically%20updates%20the%20field%20in%20the%20column%20%22Available%20now%22%20of%20that%20person%20to%26nbsp%3B%3CSTRONG%3Eyes.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20i%20have%20with%20the%20first%20scenario%20is%20that%20i%20would%20have%20to%20ask%20100%2B%20people%20to%20create%20their%20entries%20in%20the%20list%2C%20because%20if%20i%20create%20it%20for%20all%20of%20them%2C%20they%20will%20not%20be%20able%20to%20edit%20their%20own%20items.%3C%2FP%3E%3CP%3EIt%20would%20be%20much%20easier%20if%20i%20can%20create%20it%20all%20myself%20and%20somehow%20have%20the%20system%20of%20letting%20them%20set%20themselves%20to%20available%20-%20yes%2Fno%2C%20and%20then%20having%20some%20sort%20of%20notification.%20That's%20the%20whole%20idea.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123376iA1BDFE1C425A13CB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22shifts.JPG%22%20title%3D%22shifts.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EAny%20hint%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-756549%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFlow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-756633%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20availability%20in%20SharePoint%20Online%20list%20and%20connect%20it%20with%20flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756633%22%20slang%3D%22en-US%22%3Eyou%20might%20want%20to%20look%20at%20Shifts%20in%20Microsoft%20Teams%2C%20to%20see%20if%20that%20could%20work%20for%20you%20-%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Fmicrosoft-teams-for-firstline-workers-723d8259-7d17-49f5-9af8-fa9fee2036bd%3Fui%3Den-US%26amp%3Brs%3Den-IE%26amp%3Bad%3DIE%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Fmicrosoft-teams-for-firstline-workers-723d8259-7d17-49f5-9af8-fa9fee2036bd%3Fui%3Den-US%26amp%3Brs%3Den-IE%26amp%3Bad%3DIE%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-756634%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20availability%20in%20SharePoint%20Online%20list%20and%20connect%20it%20with%20flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-756634%22%20slang%3D%22en-US%22%3E%3CP%3EOrganization%20does%20wanna%20use%20SPO%20only%2C%20not%20Shifts%20%3A%20%2F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-765653%22%20slang%3D%22en-US%22%3ERe%3A%20Set%20availability%20in%20SharePoint%20Online%20list%20and%20connect%20it%20with%20flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765653%22%20slang%3D%22en-US%22%3EWhy%20can%E2%80%99t%20they%20edit%20their%20own%20entry%20if%20you%20create%20it%3F%20Do%20you%20have%20the%20item%20level%20security%20on%3F%20%3CBR%20%2F%3E%3CBR%20%2F%3EAnother%20way%20is%20you%20could%20create%20it%20for%20all%20of%20them%20and%20have%20a%20person%20column%20and%20then%20set%20your%20default%20view%20to%20filter%20by%20that%20person%20column%20with%20the%20value%20%5Bme%5D.%20Then%20they%20only%20see%20their%20own%20by%20default.%20Not%20sure%20if%20requirements%20but%20an%20idea.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I am trying to create a shift schedule in a SPO List.

Ideally we should have an option for each person to set themselves as available. For that i created a yes/no column called "Available now"

 

Scenarios that would work me:

- Person edits their own item in the list, sets availability field of their item to yes or no, and it triggers an email through the flow.

- Person sends an email through the flow (or any other possible trigger, if you have some idea feel free to say it), and it automatically updates the field in the column "Available now" of that person to yes.

 

The problem i have with the first scenario is that i would have to ask 100+ people to create their entries in the list, because if i create it for all of them, they will not be able to edit their own items.

It would be much easier if i can create it all myself and somehow have the system of letting them set themselves to available - yes/no, and then having some sort of notification. That's the whole idea.

 

shifts.JPG


Any hint?

 

Thank you

 

3 Replies
Highlighted
Highlighted

Organization does wanna use SPO only, not Shifts : /

Highlighted
Why can’t they edit their own entry if you create it? Do you have the item level security on?

Another way is you could create it for all of them and have a person column and then set your default view to filter by that person column with the value [me]. Then they only see their own by default. Not sure if requirements but an idea.