Ticketing system

(0) Share

Report

Posted on by 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

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
justinhd83 25 on at

Like (0)

Report
Copy link

Link copied!

Hi there screen shots below

Thanks

Was this reply helpful? Yes No
Verified answer

RezaDorrani 12,145 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
justinhd83 25 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
justinhd83 25 on at

Like (0)

Report
Copy link

Link copied!

Hi

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

Thanks

Was this reply helpful? Yes No
justinhd83 25 on at

Like (0)

Report
Copy link

Link copied!

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-item-is-modified/m-p/27320

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.

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

Hi @justinhd83

Glad to knwo u r 90% there

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

Was this reply helpful? Yes No
justinhd83 25 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
justinhd83 25 on at

Like (0)

Report
Copy link

Link copied!

Evening so i have a quick question
the foundation of my flow works however ive noticed today that any edits in the sharepoint list to existing items kicks the flow off for all is there a way to add delays to the flow or checkers so that only the line being worked with generates a flow?

Was this reply helpful? Yes No