Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

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

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 276 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 245 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 212

Overall leaderboard
Loading started