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 Automate
Unanswered

Add null to json

(0) ShareShare
ReportReport
Posted on by 70

I have a flow that does a couple of things

1) Gets attachments from the form

2) Creates using HTML a pdf showing the information from the form

3) gets the PDF and the form attachments then put them in an email

 

issue

To get the attachments from the form I am using a parse JSon

{
    "type": [
        "array",
        "null"
    ],
    "items": {
        "type": [
            "object",
            "null"
        ],
        "properties": {
            "name": {
                "type": [
                    "string",
                    "null"
                ]
            },
            "link": {
                "type": [
                    "string",
                    "null"
                ]
            },
            "id": {
                "type": [
                    "string",
                    "null"
                ]
            },
            "type": {},
            "size": {
                "type": [
                    "integer",
                    "null"
                ]
            },
            "referenceId": {
                "type": [
                    "string",
                    "null"
                ]
            },
            "driveId": {
                "type": [
                    "string",
                    "null"
                ]
            },
            "status": {
                "type": [
                    "integer",
                    "null"
                ]
            },
            "uploadSessionUrl": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}
 
Even with the above "Null" my flow is failing when a use is NOT uploading a file, how can I make PA ignore this step and move on when no files are uploaded through the form?
 
Thank you
Categories:
I have the same question (0)
  • Ellis Karim Profile Picture
    11,691 Super User 2025 Season 2 on at

    Hi @Helloworld2 ,

     

    You can use an Condition to test whether a file was uploaded. If the file upload question field is not empty then a file was uploaded and we can continue with the rest of the flow, for example:

     

    snag_39d757b.png

     

    If the file upload field is not empty then a file was uploaded and continue with the rest of the flow in the Yes block or take some other actions in the No block:

     

    snag_3ac8deb.png

     

    See: How to Send Microsoft Forms File Uploads to an Approval Workflow Using Power Automate – Ellis Karim's Blog

     


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as ☑️ Solved.
    If you like my response, please give it a Thumbs Up.
    My Blog Site

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

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard