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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Help Needed - Flow whi...
Power Automate
Unanswered

Help Needed - Flow which updates "Status" based on a number on True/False Tick Boxes.

(0) ShareShare
ReportReport
Posted on by 7

Hello there all. 

 

I am new to Power Automate, and looking to utilise the automation to remove user error. 

 

Currently using an MS List, users will manually change a "Choice Column" called [Status] based on the shipment progression (Asset Inducted/Awaiting Transport Docs/Awaiting Export/Awaiting Collection/Collected/Cancelled).

 

I'm looking for support in setting this up as an automated function based on multiple "Yes/No Column"  or "an inputted Date Column"

 

All new are records within the list by default are  [Status] = Asset Inducted



[Status] = Awaiting Transport Doc when [Shipment created] = True/Yes or [Shipment Raised] = an inputted DD/MM/YYYY

[Status] = Awaiting Export when [Transport Docs Received] = True/Yes

[Status] = Awaiting Collection when [Export Completed] = True/Yes

[Status] = Collected when [Collected] = True/Yes or  [Date collected] = an inputted DD/MM/YYYY

 

Can anyone help??

 

all help is greatly appreciated  

 

 

Categories:
  • Andrew_J Profile Picture
    1,962 Moderator on at

    @eddie242 

     

    I will try to help.

     

    So I understand the status:

     

    • Asset Inducted
    • Awaiting Transport Docs
    • Awaiting Export
    • Awaiting Collection
    • Collected
    • Cancelled

    It looks as though some of this is driven by Y or N or Date, from your status section above.

     

    I am sorry if I am repeating back to you what you have written but I hope you understand.

     

    Regards

     

    Andrew

  • eddie242 Profile Picture
    7 on at

    Good Morning Andrew. 

     

    I'm new to this so found it easier to explain concept with a image. 

     

    eddie242_0-1710326727939.png

     

    Apologises if this image is too small ive added it as a PDF also.

     

  • Andrew_J Profile Picture
    1,962 Moderator on at

    @eddie242 

     

    That is a lot easier, so basically you need a muliple choice field with the following:

     

    • Asset Inducted
    • Awaiting Transport Docs
    • Awaiting Export
    • Awaiting Collection
    • Collected
    • Cancelled

     

    One of you statements was "I'm looking for support in setting this up as an automated function based on multiple "Yes/No Column" or "an inputted Date Column"".

     

    I would suggest starting off with adding a new item in the list.  The user will enter the DATE for the "Asset Inducted" I would base this around if an item is created or modified trigger as this would fit everything else.

     

    There is something called "SWITCH" in flow, I think you need to use this for each of your six conditions.  The "SWITCH" would then have muliple cases beneth it based on your six conditions.  See below for more information on the "SWITCH":

     

    https://www.youtube.com/watch?v=6KokllQUX2I

     

    The case would be based around the change of DATE.  If the DATE was added to say "Awaiting Export" section then it would have a condtion to check for this DATE beign added and then if true update the status to "Awaiting Export" using the UPDATE ITEM.  It could also say change the Y to Yes in full or subsitute the Y for a tick but that is up to you.  The flow would then end.  If the date was added then you could send an email to someone external when the item is ready to leave your facilty.

     

    I would ask you to do some testing of the flow with one or two condtions, let me know if it works.

     

    I would look at the following to customise the entry form to make it easier to enter and see the date.

     

    https://www.youtube.com/watch?v=H4HyWJ9Seps

     

    I know the above maybe not what you need but it may help the team out to enter the data and see other parts of the data for you do not want them to change.  Call it locking the List down.  It might give you other ideas to spead the process up.

     

    I hope that helps.

     

    Regards,

     

    Andrew

  • eddie242 Profile Picture
    7 on at

    Thank you very much i will try this! 

    thanks again for the support and apologises for any of my incorrect terminology. 

  • Andrew_J Profile Picture
    1,962 Moderator on at

    @eddie242 

     

    No problem.

     

    A slight correction, the following:

     

    I would suggest starting off with adding a new item in the list.  The user will enter the DATE for the "Asset Inducted" I would base this around if an item is created or modified trigger as this would fit everything else.

     

    should read

    I would suggest starting off with adding a new item in the list.  The user will enter the DATE for the "Asset Inducted" I would base this around if an item is created or modified trigger as when the user enters the DATE this would add the "Asset Inducted" in the status column.  This would then create a standard for everything else you want.

     

    That is is for amplification I did not want you to start off by not udnerstanding the above in the first instance and appoligies if I am beign so simplistic. 

     

    Regards,

     

    Andrew

  • eddie242 Profile Picture
    7 on at

    Sorry Andrew, Ive been away so only just getitng to try this. 

     

    As i said this is all new to me. 




    I have tried to complete a Switch but no success! 
    eddie242_0-1710781094652.png

    This image shows a flow for  set up to work automatically if a SP item is Created or Modified. 

    I added a initialise variable, and the switch. 

     

    So in my head: flow runs because user has edited item line "Collected from Warehouse" to YES, because this meets the switch criteria then SP Item Updated "Status Value" is changed to collected. 


    I got the following errors on running 

    The execution of template action 'Switch' failed: The result of the evaluation of 'scope' action expression '@triggerOutputs()?['body/Collected_x0020_from_x0020_Wareh']' is not valid. It is of type 'Boolean' but is expected to be a value of type 'String, Integer'.

    When changed Var Collected from string to Boolean, i get this error "The execution of template action 'Switch' failed: The result of the evaluation of 'scope' action expression '@triggerOutputs()?['body/Collected_x0020_from_x0020_Wareh']' is not valid. It is of type 'Boolean' but is expected to be a value of type 'String, Integer'."

     

    Also have warnings because of infinite loop. 

    Am sorry i am very new to the Power Automate side, happy with SP Lists just trying to create my automation and reduce errors. 

  • Andrew_J Profile Picture
    1,962 Moderator on at

    @eddie242 

     

    Okay looking at your flow after the trigger you need to delete the Variable. 

     

    GET ITEMS - always good after you have made a change

    SWITCH - Base this on the the muliple choice field, you have and create one for each type as follows:

     

    • Asset Inducted
    • Awaiting Transport Docs
    • Awaiting Export
    • Awaiting Collection
    • Collected
    • Cancelled

    You need to stick to the above as I noticed some change in your last post.

     

    Each case title below should match the six status above:

     

    Andrew_J_0-1710880733640.png

    In each case below the magenta box you should have an IF statement.  And for "Asset Inducted" case this  would be based around the DATE entry.  If DATE is entered, it goes down the YES route and uses UPDATE ITEM to update the fields that you have indicated above.  Make sure you have selected the correct Status in the bottom. 

     

    The rest of the cases should match the above.  But change the status at the bottom.  I think that will give you what you want but feal there will be some more to deal with. 

     

    If you can get to that stage do some testing it should work, if not come back to me.

     

    Regards,

     

    Andrew

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 321 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 244

#3
Henil Profile Picture

Henil 102

Last 30 days Overall leaderboard