Verify if a Microsoft Form has an attachment

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

Sort by

Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@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,985 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@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... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

This helped me fixed my problem also.
Thanks a lot

Was this reply helpful? Yes No
jmillar99 23 on at

Like (1)

Report
Copy link

Link copied!

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 at

Like (0)

Report
Copy link

Link copied!
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