Answered

Not being able to submit a ticket

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am using a ticket system based on a form. Whenever I try to submit a ticket, I get an error trying to submit it. Here is the error:

https://gyazo.com/4f4cf58900367cb4ee4e622a4d050dff

I do not have any errors inside of my applications and I have refreshed all the data sources and it still does not work.

Categories:

Building Power Apps

All responses (11)

Answers (1)

Sort by

WarrenBelz 156,738 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,
As noted, I am on the other side of the world to you - I will tag my very capable colleague @mdevaney who is behind your time zone and should certainly be able to help.
NOTE: It follows on from this post
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Guess he has no time to help me or has not seen the @

Are you able to help me? @WarrenBelz
WarrenBelz 156,738 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Ok I give me a few hours. Not home right now
WarrenBelz 156,738 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Ok @Anonymous ,
So I can look at it shortly, please send the code (in text) you use to update the data source.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Alright, I have a icon that I have to click on to send the ticket. The onselect code of this icon is the following:

If(CountRows(Filter(MancoTabel, Value('Ticket ID')=Value(DataCardValue24.Text))) > 0,Navigate(Overzicht,None),SubmitForm([@EditForm])); If(CountRows(Filter(MancoTabel, Value('Ticket ID')=Value(DataCardValue24.Text))) > 0,SubmitForm(EditForm),SubmitForm([@EditForm]))

This basically checks if the ticket id is already in a column, if it is, it will navigate to overzicht and submit the form. When the ticket id is new, it will just submit the form and stay on that screen.

Then on the success of the editform i have this code:

Set(ResetValue, ""); NewForm(EditForm);

ResetValue is to set the values to nothing after submitting. It then creates a new form.

@WarrenBelz
WarrenBelz 156,738 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
OK @Anonymous ,
I am a little confused with your code.
You have two completely separate If statements based on the same argument - that the number of tickets matching the value in DataCardValue24 are either greater than zero or not.
The first one
Greater than zero navigates to Overzicht
If zero submits EditForm
The second one
Greater than zero submits EditForm
If zero submits [@EditForm]
If( CountRows( Filter( MancoTabel, Value('Ticket ID')=Value(DataCardValue24.Text) ) ) > 0 , Navigate(Overzicht,None), SubmitForm([@EditForm]) ); If( CountRows( Filter( MancoTabel, Value('Ticket ID')=Value(DataCardValue24.Text) ) ) > 0, SubmitForm(EditForm), SubmitForm([@EditForm]) )
So no matter what happens, EditForm will be submitted and what is the difference in [@EditForm]?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I understand what you mean and I just see it is indeed the same if statement.

Basically what it is supposed to do is check if the ticket ID is already inside of a column (Mancotabel -> ticketid).

If the ticket is already in the column, I want it to navigate to overzicht and submit the form.

If the ticket does not have the ticked id in the column, I only want it to submit the form. Somehow this works already. I get no error editing it, but trying to make a new ticket I get the error.

@WarrenBelz
WarrenBelz 156,738 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Ok @Anonymous You only need the first half of the code.

If( CountRows( Filter( MancoTabel, Value('Ticket ID')=Value(DataCardValue24.Text) ) ) > 0 , Navigate(Overzicht,None), SubmitForm(EditForm) )

The problem with a new ticket not submitted is that the data is not yet in the list

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Now if the if statement is true, it will only navigate me and not submit it, right?

And when the if statement is not true, it will submit the form?

Cause I also need it to submit it when the if statement is true.

@WarrenBelz
Verified answer

WarrenBelz 156,738 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
OK @Anonymous ,
Understand unless you tell me your logic, I can only deal with the code and try to interpret intention. How would this work
If( CountRows( Filter( MancoTabel, Value('Ticket ID')=Value(DataCardValue24.Text) ) ) > 0 , SubmitForm(EditForm); Navigate(Overzicht,None), SubmitForm(EditForm) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.