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

Notifications

Announcements

Community site session details

Community site session details

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

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,422 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard