cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PrasoonSur
Frequent Visitor

Conditional updating of Online Excel (in Sharepoint) using Power Automate

I was wondering if an online excel column data could be updated using power automate flows/ scripts. For example;

I have a table like the following, with a similar formula:

Power Automate Doubt 3.PNG

Formula:

=IF(G3<>"","Moved Out",
IF(C3="In-house","Available",
IF(C3="Outsourced",
IF(AND(D3<>"",E3=""),"With Supplier","Available"),
IF(C3="Disposal",
IF(F3<>"","Disposed","Available"),"")
)))

 

 

Since I'm using this online excel table (in SharePoint) for Power Apps, there shouldn't be any formula (I'm new I'm not so sure about this either).

 

Is there any way I can update all the "Availability" Column cells using power automate flows/ scripts, following the logic as given in the above formula?

It could either be a scheduled flow, or flow triggered by updating/ addition of rows in the above table, or flow triggered by end of another flow.

 

Pls help out, let me know if this is possible. Thanks in advance!

 

@fchopo | @awildash | @ScottShearer | @Pstork1 | @DamoBird365 | @chrisingh42188 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @PrasoonSur :

I've made a test for your reference:

1\My excel table:

vbofengmsft_0-1646963568280.png

My Flow:

vbofengmsft_2-1646964816629.png

The expression:

If(
  not(equals(items('Apply_to_each')?['Move Out date'],'')),
  'Moved Out',
  If(
    equals(items('Apply_to_each')?['Type'],'In-house'),
    'Available',
    If(
      equals(items('Apply_to_each')?['Type'],'Outsourced'),
      If(
         And(not(equals(items('Apply_to_each')?['Date of sending'],'')),equals(items('Apply_to_each')?['Date of return'],'')),
         'With Supplier',
         'Available'),
      If(
        equals(items('Apply_to_each')?['Type'],'Disposal'),
        If(
           not(equals(items('Apply_to_each')?['Date of Disposal'],'')),
           'Disposal',
           'Available'
         ),
        ''
       )
    )
  )
)

 

Result:

vbofengmsft_1-1646964677680.png

Best Regards,

Bof

 

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @PrasoonSur :

I've made a test for your reference:

1\My excel table:

vbofengmsft_0-1646963568280.png

My Flow:

vbofengmsft_2-1646964816629.png

The expression:

If(
  not(equals(items('Apply_to_each')?['Move Out date'],'')),
  'Moved Out',
  If(
    equals(items('Apply_to_each')?['Type'],'In-house'),
    'Available',
    If(
      equals(items('Apply_to_each')?['Type'],'Outsourced'),
      If(
         And(not(equals(items('Apply_to_each')?['Date of sending'],'')),equals(items('Apply_to_each')?['Date of return'],'')),
         'With Supplier',
         'Available'),
      If(
        equals(items('Apply_to_each')?['Type'],'Disposal'),
        If(
           not(equals(items('Apply_to_each')?['Date of Disposal'],'')),
           'Disposal',
           'Available'
         ),
        ''
       )
    )
  )
)

 

Result:

vbofengmsft_1-1646964677680.png

Best Regards,

Bof

 

Wow!! This is exciting! Thanks for the effort! I will try this out and then accept as a solution. Much appreciated!!

I never thought power automate could handle such logic. Now I understand that there are so much to explore..!!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,404)