Power Platform Community Forum Thread Details

Hello Everyone,

I am trying to build a flow to track the area audits. My flow gets data from the Group Form, in the form there are 13 main questions, every question has 3 possible answers similar to YES, NO and N/A. When option No is selected 2 more questions pops up related to previous question, Remarks and upload of a relevant pic.

I would like to make an audit report after the form is submitted. I have an online excel sheet in sharepoint as seen below. Excel sheet consist of 4 tables (may be reduced to 1 table) and I need to put an X or any sign on the each row (alternative solutions like indicating Yes, No or N/A to each row is also acceptable) and add Remark if the answer is NO. I am able to create the excel file from the template but I can not find the tables after that and can not update them.

I would be very appericate if someone find a solution. Thanks in advance 🙂