cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bsmith736464
Helper I
Helper I

Parse Section of JSON Output According to Field

Hi,

 

I am trying to build a flow and it is working correctly but I would like to include only the "Course" output instead of the "Subject" when I add it to an Excel Template.  Is it possible to filter an output according to a field?  Sample output from my json is below:

 

[
  {
    "LoginName""first.last@email.com",
    "LessonTitle""Sample Lesson Title",
    "LessonType""Course",
    "Status""Passed",
    "Score"100,
    "CompletionDate""2020-11-28T23:02:35Z",
  },
  {
    "LoginName""first.last@email.com",
    "LessonTitle""Sample Lesson Title",
    "LessonType""Lesson",
    "Status""Passed",
    "Score"100,
    "Time""00:28:42.00",
  }
]
 
automation.jpg
2 REPLIES 2
Paulie78
Super User
Super User

I don't think I understand the question. Do you mean that you would like to filter the output so that it only brings out the records where LessonType is equal to course?

My apologies for not being clear but yes, I would only like to add a row on the Excel sheet when the LessonType is equal to "Course"

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,525)