Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Solution brainstorming for Help Desk

I built a Help Desk app using one SharePoint List,

I would like to let ticket creator to attach the file/image for the issue,

and the operator to submit the solution with document or image too.

I found a solution which is create a one to many list and create a comment column(version control) as dialog box to let them leave the massage and attach the doc in attachment, but facing some problems that need to fix, anyone know?

Now I have 2 lists
1) The parent list(List name: Issue tracker) store all the detail of ticket except comment 

2) The child list(List name:  Comment) store the related ticket comment (using version history)

Columns of Issue tracker:









Columns of Comments:

Comment list.PNG







I make a Flow to get the comment, but I don't know how to fix these 2 issues:
1) how to auto create a record on comment list when Issue tracker create a new record.

2) I don't know the syntax of SharePoint API, how to get the record which equal to Ref ID; pseudocode: get(all version of comment which Comment's Ref ID = Issue tracker's ID)



Please help!


Helpful resources

PA 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 Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

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

Top Solution Authors
Top Kudoed Authors
Users online (40,972)