Skip to main content

Notifications

Community site session details

Community site session details

Session Id : xcHL0dAwN7lALXRbKrOJqe
Power Automate - Building Flows
Answered

Advanced mode alternative

Like (0) ShareShare
ReportReport
Posted on 27 Nov 2020 09:23:07 by 9

Hi together!

 

I have to do some Power Automate-Flows for work and in the last Flow i'm having some problems.

 

The idea is to have a Excel-File which is uploaded to a SharePoint list. That works perfectly. Now the SharePoint list should be updated with changes and new items in the Excel-File. I've found some tutorials, which show, how this works. The best one was this one from Jamie McAllister: https://jamiemcallister.com/upload-update-excel-values-to-sharepoint-list/

 

The problem is, that he uses the "advanced mode", which is no longer existing in Power Automate.

qualle_0-1606468156032.png

 

I had to find a solution for this and tried it with the "Compose/Verfassen"-block.

 

qualle_1-1606468307220.png

The Input is: empty(body('Elemente_abrufen')?['body/value'])
 
The problem is, that the value of the "Compose/Verfassen"-block is always "true" and I don't know how to fix that. Maybe you have some ideas and can help me.
 
Unbenannt.PNG
 
Translation:
Elemente abrufen: Get items
Element erstellen: Create item
Element aktualisieren: Update item
Bedingung: Condition
 
Thank you so much for your help!
 
 
  • qualle Profile Picture
    9 on 27 Nov 2020 at 18:14:16
    Re: Advanced mode alternative

    Worked perfect @Paulie78 ! Thank you so much!

  • Verified answer
    Paulie78 Profile Picture
    8,407 Super User 2025 Season 1 on 27 Nov 2020 at 10:44:46
    Re: Advanced mode alternative

    I suggest you put another compose before the check for empty which is just:

    body('Elemente_abrufen')?['body/value']

    So you can check manually if it is empty (and that is why the subsequent empty evaluation always ends up being true.

    You can also check this using the run history without having to use the compose.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Churchy Profile Picture

Churchy 6

#2
Chriddle Profile Picture

Chriddle 4 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 4

Overall leaderboard
Loading started