You’re offline. This is a read only version of the page.
2
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
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.
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?
#1
WarrenBelz
146,594
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
Share
Report
All responses (
Answers (
