I'm trying to use Power Automate to create a JSON file from an EXCEL Source.
Below is a sample Excel file and the output i would like to get. I want to exclude 2 columns which is highlighted in blue, then pick only the columns that have content in them.
I would appreciate any suggestions i can get to help solve this.
Thanks a lot.
Try the following. Get the rows that you need and then run a "Select" to pick the ones you want in the JSON file.
Can you please check if and let me know if you have any questions?
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
If that approach doesn't work out - check out the answer here. It's easy to do...
Check out how to claim yours today!
Check out new user group experience and if you are a leader please create your group
Test your skills now with the Cloud Skill Challenge.