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.
I had to find a solution for this and tried it with the "Compose/Verfassen"-block.
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.
Churchy
6
Chriddle
4
Super User 2025 Season 1
stampcoin
4