cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Advanced mode alternative

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!
 
 
1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

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.

View solution in original post

2 REPLIES 2
Super User III
Super User III

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.

View solution in original post

Worked perfect @Paulie78 ! Thank you so much!

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (4,495)