I have the following problem. I have a series of questions I ask my staff periodically (once every 6 months). Currently run this as an MS Form, but wanted to improve it a little. Would like to put this through as a Power App, so people can see their last response and modify if needed. However, my main concern is that users cannot have access to the underlying data file and see each other responses. This either should be a sharepoint list or excel file. I thought of configuring it as a power automate flow that pulls the data from a sharepoint location. This way, a user only needs access to the flow, not to the file. I do it as follows:
Where I have a problem is I can't seem to find a way to parse it into fields on Power App end. What I would like to do also is have a second flow to allows to capture user's input from the power app and update the fields.
Much appreciate your help!
Managed to resolve it myself. I retrieve data from a gallery, create a collection from specified items. then save json format of this data using JSON function. then sending that saved text in a newly created automated flow. this then is parsed using json parses. Final step is for each item in this json, update item from a sharepoint list with a specified id. anyone needs more info, let me know