Share
Report
2Okay so i've got the Following Setup:
I'm creating an IT-Support Flow, where the companies users can create Tickets by entering their problems in an adaptive card in teams. The flow creates a ticket in our ticketingsystem and a "log-ticket" in an excel file. That all works.
My problem is the administrator setting "Delete Ticket". I want the admins to be able to enter a ticket id and it gets deleted in the excel-log. The excel file is a simple 9 page long file with a table on each page. The different tables being IT-Toppics like, if its a software problem, hardware or others. Now my problem: I need the flow to lookup each table and check if the id is in that table. Because if it isn't, the delete function will throw an error.
Here's my setup:
Excel Topic-Table:
Delete-Module in Powerautomate:
Might be confusing, because its german, ill try to explain it:
- The flow checks if the password entered in the DeleteAC is Start12345 (Only administrators are supposed to able to delete tickets)
- If the password is correct, i tried to use a loop that uses a pre defined variable "TableInc" (Table 2-9, which are the Topic-tables), that checks every table (Table1, Table2, Table3, ... , Table9) and deletes the Ticket with the entered ID (data.id, which is the Input field from the DeleteID AC Adaptive Card at the top).
- It then sends a confirmation Adaptive Card/Updates the old one that everything worked and the ticket got deleted
The problem is that this approach obviously fails as soon as the first table does not contain that id.
How else could i solve my problem? Further i would like to include the following functions (optional but would be great):
- When an admin enters for example "6-20" in the ID input, i want all id's from 6-20 to be deleted
- When an admin enters for example "4,6,2,8,30" in the ID-input, i want exactly those ID's to be deleted.
I hope someone can help me with this problem!
All responses (
Answers (
