Ticketing system

[justinhd83]

Hi power apps sucks i am probably going to get fired because of power apps

i have a list in sharepoint cloumns are

Title

Description Text and compulsory field

Category Choice drop down

Percent number shown as percentage

Priority drop down menu high, medium, low

Task Status drop down menu Not Started, In Progress, Completed

Assigned To Name/Person Field

Ok so i generated the app in power apps but it populates all the fields so i make the fields Percent,Task Status, Assigned To

Not visible great user cant see it only problem neither can i, then try to create a new screen for the fields i want to see add a screen it only gves me three field hobble my way through that save app cant find my screen created.

So i create a flow basically when item created in sharepoint using app  via link on sharepoint main page once app sua email to myself, generate another condition that says Or based on task status equal to In progress generate a new email that says task staus updated this goes to person that created the ticket, generate another condition that says Or if Task status is equal to Completed create a email to creator of ticket and myself to say ticket closed.Great save try to kick of flow get 6 emails realise that the Or part doesnt kick off when i change the status because there is no trigger.

Amy ideas on how this can be redone, i have looked for flows that simply say when list is updated send a email nothing

If anyone can assist me ill appreciate i have watched the power apps videos read items i am still not getting the hang of it

Thanks

[RezaDorrani]

Hi @justinhd83 

Firstly calm down and do not get frustrated

Share screenshots of the Flow in edit mode and run mode

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[justinhd83]

Hi there screen shots below

Thanks

[RezaDorrani · Accepted solution]

Hi @justinhd83 ,

For your scenario just use a Switch action with flow

Try the Switch action

so Swicth - Task Status

and then  create cases for each scenario

Case: -  Not Started

CASE : In progress and so on

send ur specific email for each case

Try it out and let me know

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[justinhd83]

Hi i have created it fog the first notification then i went into the sharepoint list did a quick edit and changed the status to in progress no notification

[RezaDorrani]

@justinhd83 

You flow trigger is when an item is created

so flow will only trigger when a new item is created not when updated

there is a trigger available that does both

You will have to change thre trigger if that is ur scenario

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[justinhd83]

Hi

Thanks fior the feedback what is the trigger called that does both?

Thanks

[justinhd83]

Hi so i am at a 90% solution to this specific problem after your advise i wat trolling through the pages and came across a post

https://powerusers.microsoft.com/t5/I-Found-A-Bug/When-a-new-Item-is-created-and-when-an-existing-it...

And with some tweaking i have managed to get to the stage where based on creating a flow from scratch not using a template and using some code i have managed to get a notification for stautu not started and status in progress, status completed isnt sending the notification not sure why.

[RezaDorrani]

Hi @justinhd83 

Glad to knwo u r 90% there

now share screenshot of your flow in edit mode and when flow runs both

[justinhd83]

Hi so i have finally come right in my quest for notifications on this app everything works as it should thank you for your help @RezaDorrani i still have a million questions on power apps and a million more frustrations but at least this is working