Sharepoint list - dynamic contacts?

%3CLINGO-SUB%20id%3D%22lingo-sub-2546638%22%20slang%3D%22en-US%22%3ESharepoint%20list%20-%20dynamic%20contacts%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2546638%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20first%20time%20listener%2C%20first%20time%20caller%20here%3A%3CBR%20%2F%3E%3CBR%20%2F%3Ei%20have%20a%20question%20that%20i%20haven't%20had%20much%20luck%20searching%20for%2C%20but%2C%20i'm%20guessing%20it%20is%20because%20i%20don't%20really%20know%20the%20correct%20terminology%3F%20(or%20it%20isn't%20supported%3F)%3CBR%20%2F%3E%3CBR%20%2F%3Eso%2C%20i%20have%20an%20excel%20file%20that%20has%20alarm%20messages%20with%20contact%20information%20that%20is%20unique%20to%20each%20message%20-%20i%20want%20to%20get%20these%20into%20a%20sharepoint%20list%20or%20series%20of%20lists%26nbsp%3B%20(there%20are%20several%20hundred%20messages%20to%20manage%20and%20we%20may%20opt%20to%20have%20them%20by%20building%20or%20by%20business%20unit%20or%20whatever)%20but%20i%20was%20hoping%20to%20have%20a%20blank%20spot%20or%20place%20holder%20for%20each%20contact%20and%20then%20the%20contact%20name%20and%20number%20as%20a%20seperate%20column%20in%20the%20entry.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3Ethe%20reason%20for%20this%20is%202%20fold%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3Ei%20am%20going%20to%20use%20a%20power%20automate%20flow%20to%20generate%20the%20messages%2C%20because%20we%20are%20also%20looking%20to%20get%20feedback%20from%20SMS%20and%20email%20so%20we%20can%20have%20a%20round%20robin%20that%20continues%20until%20we%20get%20a%20response%26nbsp%3B%3C%2FLI%3E%3CLI%3Ewhile%20the%20contacts%20may%20be%20the%20same%20often%2C%20the%20ORDER%20of%20whom%20is%20contacted%20varies%20with%20almost%20every%20message%20and%20i%20want%20a%20more%20manageable%20way%20to%20replace%20names%20and%2For%20numbers%20when%20needed.%3C%2FLI%3E%3C%2FOL%3E%3CP%3ESo%20far%20-%20i%20have%20this%20(with%20redacted%20information)%3A%3C%2FP%3E%3CTABLE%20width%3D%22903%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22230%22%3EMessage%20Name%3C%2FTD%3E%3CTD%20width%3D%22289%22%3EMessage%20content%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EName%201%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%23%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EName%202%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%23%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EName%203%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EHALL_CHWS_PUMP%3C%2FTD%3E%3CTD%20width%3D%22289%22%3E%3CBR%20%2F%3ECHILLED%20WATER%20PUMP%20AT%26nbsp%3B%20HALL%20WILL%20NOT%20RUN!!%3CBR%20%2F%3EA.%20MON%20-%20FRI%205PM-MIDNIGHT%20OR%20SAT%20%26amp%3B%20SUN%208AM-MIDNIGHT%2C%20CONTACT%20THE%3CBR%20%2F%3EELECTRICAL%20TROUBLE%20TRUCK%20OPERATOR.%3CBR%20%2F%3EB.%20ALL%20OTHER%20HOURS%20REFER%20TO%20THE%20AFTER%20HOURS%20CALL-IN%20LIST%20FOR%20CENTRAL%20CONTROL.%3CBR%20%2F%3EC.%20IF%20CENTRAL%20CONTROL%20CAN%20NOT%20BE%20REACHED%20CALL%20REFRIGERATION%20ON%20CALL%20PHONE%3CBR%20%2F%3ED.%20IF%20NONE%20OF%20THE%20ABOVE%20CAN%20BE%20REACHED%20CALL%20ONE%20OF%20THE%20FOLLOWING%3A%3CBR%20%2F%3E1.%20BOB%20CONTACT%26nbsp%3B%20AT%20%23%2C%20OR%3CBR%20%2F%3E2.%20STACY%20CONTACT%20AT%20%23%20(HOME)%20or%20%23%20(CELL)%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EBOB%20CONTACT%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E111-111-1111%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ESTACY%20CONTACT%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E222-222-2222%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ESTACY%20CELL%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E333-333-3333%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3Ehere%20BOB%20and%20STACY%20are%20specific%20people%20i've%20redacted%20the%20names%20and%20numbers%20of%20-%20what%20i'd%20like%20to%20have%20is%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CTABLE%20width%3D%22903%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22230%22%3EMessage%20Name%3C%2FTD%3E%3CTD%20width%3D%22289%22%3EMessage%20content%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EName%201%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%23%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EName%202%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%23%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EName%203%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EHALL_CHWS_PUMP%3C%2FTD%3E%3CTD%20width%3D%22289%22%3E%3CBR%20%2F%3ECHILLED%20WATER%20PUMP%20AT%26nbsp%3B%20HALL%20WILL%20NOT%20RUN!!%3CBR%20%2F%3EA.%20MON%20-%20FRI%205PM-MIDNIGHT%20OR%20SAT%20%26amp%3B%20SUN%208AM-MIDNIGHT%2C%20CONTACT%20THE%3CBR%20%2F%3EELECTRICAL%20TROUBLE%20TRUCK%20OPERATOR.%3CBR%20%2F%3EB.%20ALL%20OTHER%20HOURS%20REFER%20TO%20THE%20AFTER%20HOURS%20CALL-IN%20LIST%20FOR%20CENTRAL%20CONTROL.%3CBR%20%2F%3EC.%20IF%20CENTRAL%20CONTROL%20CAN%20NOT%20BE%20REACHED%20CALL%20REFRIGERATION%20ON%20CALL%20PHONE%3CBR%20%2F%3ED.%20IF%20NONE%20OF%20THE%20ABOVE%20CAN%20BE%20REACHED%20CALL%20ONE%20OF%20THE%20FOLLOWING%3A%3CBR%20%2F%3E1.%20CONTACT%26nbsp%3B%20Name%201%26nbsp%3B%20AT%20%23%2C%20OR%3CBR%20%2F%3E2.%20CONTACT%20Name%202%20AT%20%23%20(HOME)%20or%20Name%203%20AT%20%23%20(CELL)%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EBOB%20CONTACT%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E111-111-1111%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ESTACY%20CONTACT%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E222-222-2222%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ESTACY%20CELL%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E333-333-3333%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3Eand%20then%20when%20the%20power%20automate%20gets%20involved%2C%20it%20replaces%20Name%201%2C%20and%20%23%2C%20Name%202%20and%20%23%20etc.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3Ethoughts%20on%20how%20to%20accomplish%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2546638%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi all, first time listener, first time caller here:

i have a question that i haven't had much luck searching for, but, i'm guessing it is because i don't really know the correct terminology? (or it isn't supported?)

so, i have an excel file that has alarm messages with contact information that is unique to each message - i want to get these into a sharepoint list or series of lists  (there are several hundred messages to manage and we may opt to have them by building or by business unit or whatever) but i was hoping to have a blank spot or place holder for each contact and then the contact name and number as a seperate column in the entry. 

the reason for this is 2 fold -

 

  1. i am going to use a power automate flow to generate the messages, because we are also looking to get feedback from SMS and email so we can have a round robin that continues until we get a response 
  2. while the contacts may be the same often, the ORDER of whom is contacted varies with almost every message and i want a more manageable way to replace names and/or numbers when needed.

So far - i have this (with redacted information):

Message NameMessage contentName 1#Name 2#Name 3#
HALL_CHWS_PUMP
CHILLED WATER PUMP AT  HALL WILL NOT RUN!!
A. MON - FRI 5PM-MIDNIGHT OR SAT & SUN 8AM-MIDNIGHT, CONTACT THE
ELECTRICAL TROUBLE TRUCK OPERATOR.
B. ALL OTHER HOURS REFER TO THE AFTER HOURS CALL-IN LIST FOR CENTRAL CONTROL.
C. IF CENTRAL CONTROL CAN NOT BE REACHED CALL REFRIGERATION ON CALL PHONE
D. IF NONE OF THE ABOVE CAN BE REACHED CALL ONE OF THE FOLLOWING:
1. BOB CONTACT  AT #, OR
2. STACY CONTACT AT # (HOME) or # (CELL)
BOB CONTACT111-111-1111STACY CONTACT222-222-2222STACY CELL333-333-3333

here BOB and STACY are specific people i've redacted the names and numbers of - what i'd like to have is:

Message NameMessage contentName 1#Name 2#Name 3#
HALL_CHWS_PUMP
CHILLED WATER PUMP AT  HALL WILL NOT RUN!!
A. MON - FRI 5PM-MIDNIGHT OR SAT & SUN 8AM-MIDNIGHT, CONTACT THE
ELECTRICAL TROUBLE TRUCK OPERATOR.
B. ALL OTHER HOURS REFER TO THE AFTER HOURS CALL-IN LIST FOR CENTRAL CONTROL.
C. IF CENTRAL CONTROL CAN NOT BE REACHED CALL REFRIGERATION ON CALL PHONE
D. IF NONE OF THE ABOVE CAN BE REACHED CALL ONE OF THE FOLLOWING:
1. CONTACT  Name 1  AT #, OR
2. CONTACT Name 2 AT # (HOME) or Name 3 AT # (CELL)
BOB CONTACT111-111-1111STACY CONTACT222-222-2222STACY CELL333-333-3333



and then when the power automate gets involved, it replaces Name 1, and #, Name 2 and # etc. 

thoughts on how to accomplish this?

0 Replies