cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
yoshihirok
Level 10

How to run when NotFound from Get a row on Excel Online?

I want to run a action when NotFound from Get a Row on Excel Online.

How can I run?

 

Test flow overview

1. Trigger: Request - When a HTTP Request arrived

2. Action: Excel Online - Get a row

3. Action: Request - Response

 2018-08-12 (3).png

Test flow details

1. Trigger: When a HTTP Request arrived

- Request Body JSON Schema

{
    "type": "object",
    "properties": {
        "Name": {
            "type": "string"
        }
    }
}

2. Action: Get a row

  Key column: Name

  Key value: Name

3. Action: Response

  Status code: 200

  Body: Value

 

Preparing

  Excel file on OneDrive

  with a table [Name] [Value]

 2018-08-12 (5).png

Repro step

  Run this flow by PowerShell Script 

$endpoint = "<http post url>"
$payload = @{
"Name" ="X"
}
Invoke-RestMethod -Method Post -Uri $endpoint -Body (ConvertTo-Json $payload) -ContentType 'application/json'

Configure run after of Request Trigger

  check on of all checks, success, failed, skip, timeout

 

Problem:

  Wheen the row of requesting Name is NotFound on Excel file,

  After the action 'Response' is not run.

 

So, my question is how to run when NotFound from the action 'Get a row' on Excel Online? 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to run when NotFound from Get a row on Excel Online?

HI @yoshihirok,

 

I am glad that you have solved the problem.

 

And thanks for sharing.

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
yoshihirok
Level 10

Re: How to run when NotFound from Get a row on Excel Online?

Solved.

 

To solved, Add a paralel activities with a Respond at Succeed, and Respond at NotFound.

and the 'Configure run after' of 'Respond at NotFound' check on at failed, skipped, timeout.

 

2018-08-13 (1).png

 

Thank you.

Community Support Team
Community Support Team

Re: How to run when NotFound from Get a row on Excel Online?

HI @yoshihirok,

 

I am glad that you have solved the problem.

 

And thanks for sharing.

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users Online
Currently online: 180 members 5,141 guests
Please welcome our newest community members: