Answered

Conditional form to spreadsheet

(0) Share

Report

Posted on by mvillamaino

Good afternoon all,

I've got a form that I would like to send some of the responses to a separate spreadsheet if a condition is true. In the flow I created, even though the condition is true, it is being recorded as false. Any suggestions on how to fix this? I've tried using quotes around the condition, but that did not work. Thanks!

Screen Shot 2021-06-18 at 1.59.01 PM.png

All responses (4)

Answers (1)

Verified answer

mvillamaino 31 on at

Like (1)

Report

Re: Conditional form to spreadsheet

@abm, thanks for your help in this! When I added that step and ran the test it was blank. On a hunch, I created the flow from scratch and got it to work fine. I had duplicated another flow (going from the same form and doing something similar), but somewhere along the way, it got disconnected from the original form so it wasn't picking things up. I've got to create this flow for a bunch of parks, so hopefully, I'll be able to use the save a copy function rather than do each from scratch - though even if I have to do that it will still save time in the long run (the purpose behind the flow is for each site to have a copy of what they submit in addition to the master with all of the sites). It's taking time to learn everything but will be worth it in the long run.

I appreciate your time!
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Conditional form to spreadsheet

Hi @mvillamaino

Thanks for your reply. What I need to see is the value of the Park. Add a compose action step above the Conditional action step. Map the Park dynamic content under the Compose action step. Run the flow and check the value what it is returning. Currently I can't see that value.
mvillamaino 31 on at

Like (1)

Report

Re: Conditional form to spreadsheet

@abm, thanks for your assistance. I've attached what I hope is a screenshot of what you asked for - I'm very new to this. The park is listed as BLST in the input, so that should not be the issue. I did try switching the condition to does not meet and it rated it as true.

The code in the raw inputs link is
{
    "host": {
        "connectionReferenceName": "shared_microsoftforms",
        "operationId": "GetFormResponseById"
    },
    "parameters": {
        "form_id": "FORM",
        "response_id": 246
    }
}
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Conditional form to spreadsheet

Hi @mvillamaino

Could you post the run history of Get Response Details and show the value of Park how it is retrieved? You don't need double or single quotes to compare the string values but they are case sensitive. If your form is getting the value as Blst then it will be false. You could use ToUpper() expression to convert to capital case.

Thanks

Thanks

Community site session details

Conditional form to spreadsheet

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Conditional form to spreadsheet

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates