Unanswered

Powerapp resetting SharePoint list back to previous input

(0) Share

Report

Posted on by DeeDor

I have created a powerapp that saves some information from a form to a list. The user then has the option to create a delivery note from that item and I have a flow connected to a button that runs when clicked. However I think I have the formula wrong for the on select as when you click the button, the flow runs perfectly but it also sets some fields in the SharePoint list back to what they were before the previous save.

This is what I have in the On Select: GenerateDeliveryNote.Run(Form3.LastSubmit.ID)

I need the user to be abel to save without running the flow each time hence a save button and a run flow button.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The "Form3.LastSubmit.ID" just passes the the Item Id to the Flow, so not much can go wrong on the PowerApps side unless the Save button wasn't clicked before the Run Flow button then you could have an Id for a different Item depending on how your app is configured. What is your Flow doing with the Id?

Was this reply helpful? Yes No
DeeDor 60 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @Jeff_Thorpe
Thanks for getting back to me.
The Powerapp is passing the ID to flow and flow is then creating a delivery note from the information that has been entered in the list.
Full cycle:
User scans a barcode, powerapp finds the item, user enters some details, delivery, etc and saves the item, 2nd button is then clicked if a delivery note is required.
When the 2nd button is pressed it runs the flow and the delivery note is created but when I look back at the list 2 columns change back to the previous setting.
OK.. Ive just checked and they are both choice columns and I had default vaules set ! It was resetting the columns to the default ! Doh !!!

Was this reply helpful? Yes No
DeeDor 60 on at

Like
a
(0)

Report
Copy link

Link copied!

@Jeff_Thorpe

Hi Jeff
Looks like I was wrong, even when I have now changed the colums to have no default value, have refreshed the data source and re-published the app.. When I hit the flow button it is still setting the 2 columns to the same as the column above (this time its not even reset back to what it was previously as there was no previous item)
Strange !
Thanks
Dee

Was this reply helpful? Yes No