cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bbsin
Post Prodigy
Post Prodigy

SP list formatting can ask here???

Hi

 

Not sure where to post.. can I ask about SP list formatting here?

 

I have a column status - in progress, completed, need action ,  contract -   I need it to auto fill the status when

ContractDate has date in - Contract

WorkAmt has number - InProgess

PaidAmt - has number - Completed

1 ACCEPTED SOLUTION

Accepted Solutions
NiloferA
Responsive Resident
Responsive Resident

Hello @bbsin ,

You can achieve this using Power Automate.

  1. Create an Automated Flow which triggers "When an item is created or modified"
  2. In this Flow, add a condition - ContractDate "is not equal to" null and ContractDateUpdated "is equal to" null. If yes, then add Update Item action and update the Status to Contract and ContracteDateUpdated to Yes. (ContractDateUpdated is a new column you will have to add to avoid infinite looping)
  3. You can add more conditions based on your scenario and proceed accordingly

Let me know if you need further help on this topic.

Please give a Kudo if you found this helpful or Mark this Reply as Solution if it solved your problem.

View solution in original post

3 REPLIES 3
NiloferA
Responsive Resident
Responsive Resident

Hello @bbsin ,

You can achieve this using Power Automate.

  1. Create an Automated Flow which triggers "When an item is created or modified"
  2. In this Flow, add a condition - ContractDate "is not equal to" null and ContractDateUpdated "is equal to" null. If yes, then add Update Item action and update the Status to Contract and ContracteDateUpdated to Yes. (ContractDateUpdated is a new column you will have to add to avoid infinite looping)
  3. You can add more conditions based on your scenario and proceed accordingly

Let me know if you need further help on this topic.

Please give a Kudo if you found this helpful or Mark this Reply as Solution if it solved your problem.

View solution in original post

Hi Nilfoer,  thank you

 

@NiloferA   Thanks  Great.  🙂

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,226)