HELP! PowerApps send a JSON with an array of codes, flow to get data using odata filter
a week ago
I have a flow that uses Odata to get items. The thing is I'm doing it dynamically using an array of values to filter... I get everything to work inside the Apply to each and inside the Get Items from sharepoint.... The question here is... how do I use then those records... It seems to be impossible for me (I'm not an expert in Power Automate) and it's been frustrating getting the values but not being able to use them to make an html table as report. Any help? [This is the original question I posted on @Reza 's YouTube channel]
I already managed to get it to work but I'm sure there is a less "pirate" way to do this... Please any help. I attach some screenshots so you can see what I did... At the end I ended Up by creating a JSON schema all manually by replacing characters.
Here I post the complete ODATA filter and the "Apply to each" (as you can see I appended the results in a variable for further use... no way to use them in an easier way?):