Looking for some help if possible with the following JSON output. I need to pass the values from the items id and record into SHarePoint. I can successlly use filter array with compose on the position for each item within items but often the position is repeated throughout the JSON output so I want to instead filter on the items id and return the values. Tried and tried with no avail, response is continuously that cannot filter array with a null value. Any assistance would be greatfully appreciated.
See attached for JSON sample
Sure - see screen shots below with position used. Where I would try and replace position with id for example fails completely, tried various things with this I have lost count now, I will try and reproduce the error message as well
It looks like you are trying to get to results->Items->ID correct?
If you post the full JSON that you are trying to parse, i'll play with it and see what I can come up with
See if something in here is able to guide you. I created a flow that parses a the json in a couple different steps, and I think contains the filter statement you're after or at least will give you an idea of how to interpret the JSON and utilize it. The link below should let you download the .zip package export of the flow I did on my side and you can import it into your environment.
Thank you very much for this, I plan to come back to this on Thursday so I will update you then but wanted to say thanks in the meantime for your assistance with this.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!