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 -
- 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
- 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 Name | Message content | Name 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 CONTACT | 111-111-1111 | STACY CONTACT | 222-222-2222 | STACY CELL | 333-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 Name | Message content | Name 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 CONTACT | 111-111-1111 | STACY CONTACT | 222-222-2222 | STACY CELL | 333-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?
