web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Advanced mode alternative
Power Automate
Answered

Advanced mode alternative

(0) ShareShare
ReportReport
Posted on 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!
 
 
Categories:
I have the same question (0)
  • Verified answer
    Paulie78 Profile Picture
    8,424 Moderator on at

    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.

  • qualle Profile Picture
    9 on at

    Worked perfect @Paulie78 ! Thank you so much!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 711

#2
Vish WR Profile Picture

Vish WR 691

#3
Haque Profile Picture

Haque 525

Last 30 days Overall leaderboard