Unanswered

Input value from Form showing as NULL

(0) Share

Report

Posted on by Joehpool

Hi,

I've set up a flow to add a new row of data to an excel document every time somebody completes a form. It adds in the response ID fine but the rest of the data keeps showing as "NULL" even though there is definitely data inputted as I can see in the forms data.

This is the flow

This is what it then shows in excel

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

wskinnermctc 6,519 Moderator on at

Like (0)

Report

Did you manually put in the Form Id in the first trigger When a new response is submitted? Are you able to select the form from a drop down instead?

Was this reply helpful? Yes No
Joehpool 2 on at

Like (0)

Report

Yes - It didnt appear from the drop down, I think its because i didnt create the form but it has been shared to me to edit etc.

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report

You could try putting the value in as an expression. So basically take the dynamic content value you currently have in the field, copy it, then go into Expression instead of Dynamic Content and paste it into the expression.
If you highlight and copy the whole dynamic content value and paste it into expression you will need to remove the extra characters at the beginning which is an @ at symbol and opening curly bracket { and at the end the closing curly bracket }

For example if I copy the dynamic content field from my form and paste it, then it will look like below:
@{outputs('Get_response_details')?['body/re8d527f4f4494e389ae100f72dda1cfc']}

If I go into Expressions then I would make it look like below:
outputs('Get_response_details')?['body/re8d527f4f4494e389ae100f72dda1cfc']

It will change the value from a green Dynamic content to a pink fx expression, but it should still work.

See if that makes a difference.

Was this reply helpful? Yes No