cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JMp365
Regular Visitor

Output not reflecting input

Hi,

 

So I'm trying to build a flow and without going to specifics, I kept on getting a failure when I was using the outputs of a filter array as dynamic content.

 

 

 

A value must be provided for item.
clientRequestId: 2951a598-e1de-4d6e-ab62-4437f406f49e

 

 

 

Now, I'm pretty new when it comes to Power Automate, so thinking that I must be doing something wrong I decided to test some static content, so manually wrote a JSON array: 

 

 

 

{
"Question":"What is your favourite colour",
"Response":"Blue. Wait green..",
"Answer":"Argghh"
}

 

 

 

The flow succeeded this time, which is good, but it cut off the last item:

 

JMp365_0-1666635676619.png

What am I doing wrong?

 

For reference, I am trying to add a row to an excel table

2 REPLIES 2
grantjenkins
Community Champion
Community Champion

Are you able to post some screenshots of your flow and inputs, etc.?

 

What do you have for your Filter array (input, values)?

 

Filter array needs to take an array as input, but you just have a single object.

{
  "Question":"What is your favourite colour",
  "Response":"Blue. Wait green..",
  "Answer":"Argghh"
}


----------------------------------------------------------------------

If I've answered your question, please mark the post as Solved.

If you like my response, please consider giving it a Thumbs Up.
JMp365
Regular Visitor

Hey Grant, thanks your reply.

 

I actually ended up deleting the flow and starting again, and have gotten past  that stage now - I think it was an issue with how I was either parsing or creating the JSON.

I'm onto another problem, which is that in my JSON I have a nested array, and I'm trying to use the nested array to populate a nested repeating section in a word doc template - but as I research it I'm coming to conclusion that it's simply not possible.

 

I'm onto a completely un-related task now, but if I get the chance to I will make a new post!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,079)