Solved: Create folder if does not exist then insert create file/If folder exist insert create file

Create folder if does not exist then insert create file/If folder exist insert create file

HI All
I hope everyone is doing ok 🙂
I need some help with a flow i am creating which has me confused.

my desired scenario is
When list item created
Check if folder exists
If does then insert new create file (html)
if not create Folder then insert create file (html) file

I have searched and read numerous post to this forum and others , read blogs and tried to create my requirement from the examples they provide.
So here is my flow so far

All works fine 🙂

My issue is that on list folder i get a 'The response is not in a JSON format.' and it says resource not there but it is because on the first test run inserting a sharepoint list item it created the folder! (still has the same fault on List Folder though)

So it creates the folder again!

My FolderName Variable is is

Dynamic content is a Person field and from share point list 'get item'

My List folder is this

Path is the Get folder metadata

so
my first pass creating a list item creates a folder if not there!
But if i then create another item with the FolderName with the same data (the reviewer.displayname the same) the condition runs but staes there s no folder when there is so runs the false condition again 😞

The email functions are just for testing

Must of this was taken adapted from @abm blog post

Help would be gratefully received 🙂
Gary

Quick Links

Leaderboard > Power Automate - Building Flows