Hello, I am setting up a Microsoft List to keep track of our tenders. The two columns that need to talk to each other are the Bid Status column and the Date Submitted column.
When a new item is initially set up, the Date Submitted column is left blank. Once a tender is completed and submitted, we enter a date into the Date Submitted column. Once the Date Submitted column is populated, I would like for the Bid Status choice to change to Submitted.
I have set up a flow that kind of works, however it is working too well. It is changing every new list item to Submitted. I suspect this is because I am using the When an item or a file is modified as my trigger because my list has another flow that gives each item an automatic incremental number (which I assume already modifies the list item).
I am a complete Newbie to Power Automate, so any help you can give me would be appreciated. Here is the flow as I have it at the moment:
I feel like it would be easier to just use an If is not null statement, but I don't know how to do that in Power Automate. Any suggestions?
Thanks!
