Share
ReportSo, in my powerapps application, I am creating a historical table to store a ticket for every server blackout request that I send. It almost works, the only problem is:
If I send one request with, for instance, SERVER1 and SERVER2 and the IUA [ABC], from StartDate 16/06/2023 13:30 to EndDate 16/06/2023 14:00, sent by my business email, it will work perfectly fine. But, if then I send another request with, for instance, SERVER3 and the IUA [DEF], from StartDate 17/06/2023 14:00 to EndDate 18/06/2023 14:30, sent by my business email, it will give me two tickets that are exactly the same, with:
StartDate 16/06/2023 13:30 - EndDate 16/06/2023 14:00 //the Start and End Dates from the first sent ticket
IUA: [ABC], [DEF]
SERVERS: SERVER1, SERVER2, SERVER3
Sent By: myemail@example.commyemail@example.com
and instead it should give me:
- First Ticket:
StartDate 17/06/2023 14:00 - EndDate 18/06/2023 14:30
IUA: [DEF]
SERVERS: SERVER3
Sent By: myemail@example.com
- Second Ticket:
StartDate 16/06/2023 13:30 - EndDate 16/06/2023 14:00
IUA: [ABC], [DEF]
SERVERS: SERVER1, SERVER2, SERVER3
Sent By: myemail@example.commyemail@example.com
I tried to clear the collection after sending the first and second request but obviously it didn't work, since it erased all the data from the collection, causing the historical table to be empty, as I anticipated. How can I solve this without clearing the collection and without accumulating the data from one ticket to another?
All responses (
Answers (
326
