Verify if a Microsoft Form has an attachment

Like (1) Share

Report

Posted on 1 Jan 2020 22:09:25 by Community Power Pla...

I need to verify if a Microsoft Form was submitted with an attachment.

Here is the attachment option on my Microsoft Form

Here is how I have my Flow setup

Regardless of whether I have an attachment or not, I'm still getting "expression result = false". I'd expect to get a TRUE or FALSE depending on whether I had an attachment on the Form or not.

I have the same question (0)

All responses (14)

Answers (1)

Verified answer

abm abm 32,585 Most Valuable Professional on 01 Jan 2020 at 23:15:40

Like (3)

Report

Re: Verify if a Microsoft Form has an attachment

Hi @Anonymous

Happy New Year

Check the length of the attachment response using expression.

The above expression is as follows:

length(body('Get_response_details')?['rfd1b4aaa0a4f441da35ecb4dca0bdf7d'])

This is my run history of Get Response Details:

Thanks

Was this reply helpful? Yes No
Community Power Pla... on 01 Jan 2020 at 23:20:15

Like (0)

Report

Re: Verify if a Microsoft Form has an attachment

Thanks @abm, would I then use the expression in the condition? What would that look like?

Thanks!

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on 01 Jan 2020 at 23:33:40

Like (0)

Report

Re: Verify if a Microsoft Form has an attachment

Hi @Anonymous

Thanks for the quick reply. Here I have added a compose action. In your case you can add the expression directly under the If condition under the expression tab next to Dynamic content. See below.

length(body('Get_response_details')?['rfd1b4aaa0a4f441da35ecb4dca0bdf7d'])

If you need any further help please let me know.

Thanks

Was this reply helpful? Yes No
Community Power Pla... on 02 Jan 2020 at 00:02:17

Like (0)

Report

Re: Verify if a Microsoft Form has an attachment

@abm I was able to compose the expression successfully, but I don't know where to go from here. Do I put the "outputs" in a condition to check if there's an attachment? I feel like I'm missing the next step.

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on 02 Jan 2020 at 00:32:28

Like (3)

Report

Re: Verify if a Microsoft Form has an attachment

Hi @Anonymous

Yes you can add the output in the condition greater than 0 (Zero).

Or without the compose you can add the expression under the IF statement. See below.

Both should work.

Thanks

Was this reply helpful? Yes No
v-alzhan-msft on 02 Jan 2020 at 01:04:40

Like (0)

Report

Re: Verify if a Microsoft Form has an attachment

Hi @Anonymous ,

Please take a try with @abm 's solution and let me know if you have any problem s.

Best regards,

Alice

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

Was this reply helpful? Yes No
Community Power Pla... on 02 Jan 2020 at 01:11:44

Like (1)

Report

Re: Verify if a Microsoft Form has an attachment

@abm This is exactly what I was missing. Thank you so much and Happy New Year :)!

Was this reply helpful? Yes No
Community Power Pla... on 15 Apr 2021 at 15:11:04

Like (1)

Report

Re: Verify if a Microsoft Form has an attachment

This helped me fixed my problem also.
Thanks a lot

Was this reply helpful? Yes No
jmillar99 23 on 03 Jun 2021 at 00:13:27

Like (1)

Report

Re: Verify if a Microsoft Form has an attachment

Thank you for the time you spend to help people with these questions. Your response helped me as well.

Was this reply helpful? Yes No
Nicolas07 42 on 23 Jun 2021 at 10:26:06

Like (0)

Report
Re: Verify if a Microsoft Form has an attachment

Hi @abm ,
I am trying to do the same thing, but I am getting the following error on the condition:

Unable to process template language expressions for action 'Condition' at line '1' and column '27420': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#length for usage details.'.

This is how my flow looks like.
It copies responses submitted in a Form into a Sharepoint list. I want it to copy also the attachments (i'm using a parse JSON) in the Sharepoint list too. But if there are no attachments, the Parse JSON fails. So I would like to have the condition to check first if there are any attachments. If yes --> Parse JSON. If not, go to the next step (send email from shared mailbox).

Thanks for your help!!

Was this reply helpful? Yes No