web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / resetting the column v...
Power Automate
Unanswered

resetting the column value of sharpoint form

(0) ShareShare
ReportReport
Posted on by 64

I have a SharePoint form customized using PowerApps , when user submit it will send an approval email using Microsoft send mail with option using MS flow and according the responds to the approval mail it will update some of the SharePoint and i have set a column  'Review Value' = Reviewed if user take action on it and gave it as a condition  flow  to avoid the looping ,

now in my scenario if user reject the request , then if someone edit and submit again , it doesnt trigger the flow because its review value is reviewed , i need the review value column to get reset to notreviewed on successful submit ion of the form 

any help ?

Categories:
I have the same question (0)
  • Paulie78 Profile Picture
    8,422 Moderator on at

    Hi @jaleefpk 

     

    This is really a PowerApps question, but I will give you my thoughts as I had to do the same recently. In my SharePoint form I include a label for the current authorisation status with a button that says "Resubmit for Approval". The button is only visible if the status is rejected. It looks like this:

     

    Re-Approve.PNG

     

    When the button is selected it sets the value of a variable like this:

     

    Set(resubmit, true);

     

    Then I set the value of the status label like this:

     

    If(resubmit = true, "Resubmit", ThisItem.'Approval Status'.Value)

     

    So if the resubmit button is pressed it sets the value of the label to "Resubmit", otherwise it shows the current status. The value of the data card is then set to the value of the label.

     

    This gives the users a clear method of resubmitting the approval.

     

    Hope this helps.

     

    Paulie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard