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 III
Super User III

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

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (100,479)