How can i check if you submitted a request, but then if you cancel the request to allow user to submit a new one

[patty789]

Hello,

I have a question: How to check in powerapps if you submitted a request to a SharePoint list, and if user cancels the request to be able to submit a new one. I have a formula that checks if the creator submitted a request, but when user updates the record to cancel i want user to be able to submit a new request. Can this be possible? 

[KrishnaV]

Hi @patty789 ,

Add a new column in SharePoint list as request Status (choice column "Yet-To-Start","In-Progress","Completed","Cancelled"). Give a screen to user and list all the his/her tickets along with a cancel button. If user click on cancel button update the status as "Cancelled". While clicking on new ticket request ensure that there are no open tickets in SP List.

Let me know if you need filter formulas, I can provide you in detail.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[patty789]

@KrishnaV Thank you for your response i have this formula on a submit button yet it does not work and currently i have a record created by me and when i go to my personal view on the app i click edit then i have a drop down to select update request or cancel and i select cancel, but i want to go back and select a new request my formula does not work.  

If(!IsEmpty(Filter('Request', CreatorName = varUser.FullName && RequestStatus.Value = "Submitted")), Navigate(PersonalRequestScreen, ScreenTransition.Fade), !IsEmpty(Filter('Request', UpdateType.Value = "Cancel Request")), UpdateContext({showPopup:true}))

[KrishnaV]

Hi @patty789 ,

Try this:

If(!IsEmpty(Filter('Request', CreatorName.DisplayName = varUser.FullName && RequestStatus.Value = "Submitted")), 
Navigate(PersonalRequestScreen, ScreenTransition.Fade), 
!IsEmpty(Filter('Request', UpdateType.Value = "Cancel Request")), UpdateContext({showPopup:true}))

Note:  I am assuming CreatorName is a people picker field in SharePoint List.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[patty789]

@KrishnaV The CreatorName column in SharePoint list is a single text column. 

[KrishnaV]

Hi @patty789 ,

Ok try this,

If(IsEmpty(Filter('Request', CreatorName = varUser.FullName && RequestStatus.Value = "Submitted")), 
Navigate(PersonalRequestScreen, ScreenTransition.Fade), 
!IsEmpty(Filter('Request', UpdateType.Value = "Cancel Request")), UpdateContext({showPopup:true}))

 
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[patty789]

@KrishnaV That worked yet, the If statement now is not checking if i already submitted a request and should take me to my personal view. 

[KrishnaV]

Hi @patty789 ,

Try this:

If(!IsEmpty(Filter('Request', CreatorName = varUser.FullName && RequestStatus.Value = "Submitted")), // This takes the user to PersonalRequest Screen if there are any submitted requested on the logged in user name
Navigate(PersonalRequestScreen, ScreenTransition.Fade), 
!IsEmpty(Filter('Request',CreatorName = varUser.FullName && UpdateType.Value = "Cancel Request")), UpdateContext({showPopup:true})) // This will set the variable to True if there are any cancelled request in the form with the logged in user.

 
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[KrishnaV · Accepted solution]

Hi @patty789 ,

Try this:

If(!IsEmpty(Filter('Request', CreatorName.DisplayName = varUser.FullName && RequestStatus.Value = "Submitted" && Isblnak(UpdateType.Value))), 
Navigate(PersonalRequestScreen, ScreenTransition.Fade), 
!IsEmpty(Filter('Request', UpdateType.Value = "Cancel Request")), UpdateContext({showPopup:true}))

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.