Duplicate Request ID

(0) Share

Report

Posted on by DDM

Hello,

I have an issue where I am creating duplicate request ID

In the Onvisible of the request screen the RequestID is set by reading the list and taking the RequestID item value from the last submitted item.

If(
 frmRequestDetails.Mode = FormMode.New,
 "REQ" & First(
 Sort(
 AddColumns(
 'Freight Requests',
 "NewRequestID",
 Trim(
 Substitute(
 RequestID,
 "REQ",
 ""
 )
 ) * 1
 ),
 NewRequestID,
 Descending
 )
 ).NewRequestID + 1,
 Parent.Default
)

I then increment the Request ID + 1

It seems that following the SubmitForm there is quite a delay in the time that the item is written to the list and the user navigating back to submit a second request which results in the item not being present in the list. This then results in the the new request generating the same Request ID.

Can anyone help?

Many Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

DDM 79 on at

Like (0)

Report

So its not PowerApps after all.

It's simply down to the fact that the- SharePoint list does not refresh after the item is added. I need to hit the F5 refresh a couple of times before the item is shown. Not an optimal solution.

Why the SharePoint list not automatically updating... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report

@DDM could you explain in more detail what the issue is? How do you Navigate to your request screen? After SubmitForm().....or within the OnSuccess property of the form.

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.

Was this reply helpful? Yes No
Verified answer

DDM 79 on at

Like (0)

Report
Hi @PowerRanger

Thanks for coming back to me.

I solved it another way. Essentially, I was never going to achieve what I needed to achieve doing it the way I was doing it and so I took the path of least resistance....

UpdateContext({RequestID: "REQ" & Text(Now(),"[$-en-US]yymmddhhmmss")})

I still get my Unique RequestID and I am not having to worry about ensuring the list is updated to ensure contiguous numbering.

I was having to hit refresh on the SharePoint list twice for the new item to appear. Very Bizarre!

Was this reply helpful? Yes No