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 / Power Automate not run...
Power Automate
Unanswered

Power Automate not running work flow but is successful

(0) ShareShare
ReportReport
Posted on by 14

Hi all, just need some support. I created a workflow on power automate, and it is running successfully but when I look at the action item it looks like it is not working. 

 

For reference I am trying to:

Automate JSON files that are uploaded to a SharePoint folder to go into an excel workbook as separate (worksheet)tabs.

 

Power Automate Photo reference: 

techgirl99_0-1685631272175.png

Schema reference: 

 "type""object",
    "properties": {
        "data-set": {
            "type""object",
            "properties": {
                "record": {
                    "type""object",
                    "properties": {
                        "column1.action": {
                            "type""string"
                        },
                        "column1.details": {
                            "type""string"
                        },
                        "column1.user.emailAddress": {
                            "type""string"
                        },
                        "column1.displayName": {
                            "type""string"
                        },
                        "column1.user.name": {
                            "type""string"
                        },
                        "column1.user.active": {
                            "type""string"
                        },
                        "column1.user.links.self": {
                            "type""string"
                        },
                        "column1.user.id": {
                            "type""string"
                        },
                        "column1.user.type": {
                            "type""string"
                        },
                        "column1.user.slug": {
                            "type""string"
                        },
                        "column1.user.timestamp": {
                            "type""string"
                        }
                    }
                }
            }
        }
    }
}
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at

    Hi @techgirl99 

     

    see, you have initialized the JSONData variable before the loop and it is empty as well.

     

    Nived_Nambiar_1-1685673373084.png

     

     

    So then it won't execute any items under loop . 

     

    Hope this helps !

     

     

  • NL-25021911-0 Profile Picture
    14 on at

    Hi Nived, thanks for the response. So essential I should swap "initialize variable" and "apply to each" ? Also, I ran a test with Initialize Variable elements filled but ran into an error. I also tried filling the trigger condition and recieved this error message Request to Azure Resource Manager failed with error: '{"error":{"code":"WorkflowTriggerHistoryNotFound","message":"The workflow '________________' trigger 'When_a_file_is_created_or_modified_(properties_only)' history 'null' could not be found."}}'.

  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at

    Hi @techgirl99 

     

    actually i need to know what actually u need to pass to the loop, could you explain the process better ?

     

     

  • NL-25021911-0 Profile Picture
    14 on at

    Yes, for the loop:

    Every time I upload a JSON file to a SharePoint folder

    a preexisting excel workbook document will create a worksheet for that JSON file

  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at

    Hi @techgirl99 

     

    For that json data you are trying to create a worksheet 

     

    Could u show the action of creating worksheet and also is it like u are creating excel worksheet out of json data ?

     

     

    Kindly let me know !

     

     

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 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard