Updating secondary list

%3CLINGO-SUB%20id%3D%22lingo-sub-2347887%22%20slang%3D%22en-US%22%3EUpdating%20secondary%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2347887%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%20fairly%20new%20to%20Sharepoint%2C%20i%20just%20wondered%20if%20i%20could%20pick%20all%20your%20brains!%3CBR%20%2F%3EI%20have%20developed%20a%20simple%20'Holiday%20Request'%20PowerApp%20which%20populates%20data%20into%20a%20sharepoint%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20need%20this%20sharepoint%20list%20to%20'talk'%20to%20another%2C%20and%20update%20it%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewe%20have%20about%2060%20members%20of%20staff%20and%20only%207%20are%20allowed%20off%20at%20the%20same%20time%3C%2FP%3E%3CP%3Eso...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26gt%3Bthe%20first%20sharepoint%20list%20will%20have%20staff%20members%20holiday%20request%20dates%20on%20it.%3C%2FP%3E%3CP%3E%26gt%3BThe%20second%20list%20will%20have%20a%20column%20full%20of%20dates.%20And%20the%20number%20%227%22%20in%20the%20next%20column%20(for%20the%20number%20of%20spaces%20we%20have%2C%20to%20have%20off).%3C%2FP%3E%3CP%3Ei%20need%20this%20number%207%20to%20reduce%20by%201%2C%20everytime%20someone%20requests%20holiday%20on%20that%20day%2C%20from%20the%20other%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20this%20doable%3F%3CBR%20%2F%3EI%20was%20going%20to%20make%20the%20second%20list%20of%20dates%20a%20sharepoint%20calendar%20instead.%20But%20i%20don't%20know%20how%20doable%20that%20is%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2347887%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2347938%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20secondary%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2347938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1051716%22%20target%3D%22_blank%22%3E%40TheClusk%3C%2FA%3E%26nbsp%3BI%20can%20think%20of%202%20ways%20to%20do%20achieve%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Add%20a%20data%20source%20of%202nd%20list%20to%20your%20Power%20Apps.%20Find%20the%20unique%20item%20from%202nd%20list%20for%20which%20you%20are%20adding%20holiday%20request%20in%201st%20list.%20Then%20update%20the%20item%20in%202nd%20list%20with%20new%20number%20using%26nbsp%3B%3CA%20title%3D%22Patch%20function%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerapps%2Fmaker%2Fcanvas-apps%2Ffunctions%2Ffunction-patch%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EPatch%20function%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Run%20Power%20Automate%20flow%20on%20item%20creation%20(%26amp%3B%20maybe%20on%20item%20update)%20in%201st%20list.%26nbsp%3BFind%20the%20unique%20item%20from%202nd%20list%20for%20which%20you%20are%20adding%20holiday%20request%20in%201st%20list.%20Then%20update%20the%20item%20in%202nd%20list%20with%20new%20number%20using%26nbsp%3B%3CA%20title%3D%22Update%20item%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fconnectors%2Fsharepointonline%2F%23update-item%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EUpdate%20item%3C%2FA%3E%26nbsp%3Baction%20in%20Power%20automate.%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%26nbsp%3B%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%26nbsp%3B%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2348242%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20secondary%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348242%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20your%20reply%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnly%20probelm%20i%20have%20is%20that%20List%201%20has...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eholiday%20request%20date%20from%20(12th%20may)%20%26amp%3B%20to%20(19th%20may)%20(not%20a%20list%20of%20each%20seperate%20day)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Elist%202%20will%20have%20that%20list%20of%20seperate%20days.%20(12th%2C%2013th%2C14th%2C15th%20etc...)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20would%20i%20get%20around%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello everyone, fairly new to Sharepoint, i just wondered if i could pick all your brains!
I have developed a simple 'Holiday Request' PowerApp which populates data into a sharepoint list.

 

i need this sharepoint list to 'talk' to another, and update it

 

we have about 60 members of staff and only 7 are allowed off at the same time

so...

 

>the first sharepoint list will have staff members holiday request dates on it.

>The second list will have a column full of dates. And the number "7" in the next column (for the number of spaces we have, to have off).

i need this number 7 to reduce by 1, everytime someone requests holiday on that day, from the other list.

 

is this doable?
I was going to make the second list of dates a sharepoint calendar instead. But i don't know how doable that is

2 Replies

@TheClusk I can think of 2 ways to do achieve this:

 

1. Add a data source of 2nd list to your Power Apps. Find the unique item from 2nd list for which you are adding holiday request in 1st list. Then update the item in 2nd list with new number using Patch function 

 

2. Run Power Automate flow on item creation (& maybe on item update) in 1st list. Find the unique item from 2nd list for which you are adding holiday request in 1st list. Then update the item in 2nd list with new number using Update item action in Power automate.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Thank you for your reply

 

Only probelm i have is that List 1 has...

 

holiday request date from (12th may) & to (19th may) (not a list of each seperate day)

 

list 2 will have that list of seperate days. (12th, 13th,14th,15th etc...)

 

How would i get around this?