resetting the column value of sharpoint form

(0) Share

Report

Posted on by jaleefpk

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:

General topics

I have the same question (0)

All responses (1)

Answers (0)

Paulie78 8,422 Moderator on at

Like (0)

Report
Copy link

Link copied!
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:

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

Was this reply helpful? Yes No