cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DrishM13
Helper II
Helper II

Flow to get approval based on rating in Forms

Hi,

 

I have a simple form where a user must enter their name & surname, email, managers email and also indicate a rating from 1 to 5.

 

My flow is set up to send the manager an email that the rating is awaiting their approval or rejection.

 

Flow as follows:

 

DrishM13_0-1621495199790.png

 

I seem to have an error in this Pasre JSON

 

DrishM13_1-1621495229945.png

 

{
    "type""integer",
    "items": {
        "type""object",
        "properties": {
            "name": {
                "type""string"
            },
            "link": {
                "type""string"
            },
            "id": {
                "type""string"
            },
            "type": {},
            "size": {
                "type""integer"
            },
            "referenceId": {
                "type""string"
            },
            "driveId": {
                "type""string"
            },
            "status": {
                "type""integer"
            },
            "uploadSessionUrl": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}
 
I think it may be the above.
I had "type": "integer" as  "type": "array" which made the error that it should be integer so I changed it but then I get this error:
 
DrishM13_2-1621495330751.png
Any assistance would be greatly appreciated.
1 REPLY 1
PrasadAthalye
Super User
Super User

Why do you want to parse it as Json? Output of Rating question is an integer. 

 

I have my last question as rating and I selected 3 rating.. See below... You can directly use that question to get rating.

 

  "body": {
        "responder""Prasad_Athalye@YYY.com",
        "submitDate""5/20/2021 11:42:33 AM",
        "rd7f84d633bd24b01bd831a1128630b83""Black",
        "rb155ddff72364222b289b17c7727a3e9""",
        "r4154547b9a294106946e4ce67887d728""1",
        "r6c6ad0ab931a4a26b0564e655ebd153c""HR",
        "r4adde042418f49f9895b0acdde6385ac""3"
    
PrasadAthalye_0-1621511187829.png

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,102)