Forum Discussion
Calculate the number of times a choice variable is used
Hi I have a "Status" column that is manually updated by the users throughout the process as the process moves forward. One status = 'Rejected' and they want to be able use this status at any poin...
markikav1955 one way to do it would be to have a JSON-formatted button in your list that the project team would click when they want to reject an item. You would also have a column in your list for the number of times each item was rejected. The button triggers a flow in Power Automate that would update the list item and increment the number of times rejected column for that item by 1. If you need specifics about any of this just shout.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- Hi Rob
Yes specifics would be great.
They are using an InfoPath form for data entry presently so could the button be presented on such form? If not its ok I can tell them if rejecting something just use the list view.
Thanks for the help..markikav1955 InfoPath, if it even works with modern SharePoint lists, is no longer supported.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- Hi Rob
That is fine, so is this possible solely through Power Automate or does it need some json too in the list?
Thanks
Mark
