powerapps - Power App pulling data from Power Automate Flow - Stack Overflow

admin管理员组

文章数量:1310526

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:

1. When Power App calls a flow (v2)
2. Get Items (specified list) with a filter by email address
3. Select creating a key value pairs
4. Sending as a string to Power App.

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!

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:

1. When Power App calls a flow (v2)
2. Get Items (specified list) with a filter by email address
3. Select creating a key value pairs
4. Sending as a string to Power App.

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!

• power-automate
• powerapps

Share Improve this question Follow asked Feb 3 at 12:42 sampaksampak 15711 gold badge22 silver badges1313 bronze badges 2

• If you send the string in JSON format back to Power Apps from the flow, you can use the ParseJSON function to extract the information from the result. – carlosfigueira Commented Feb 3 at 14:07
• ok, managed to get this to work with ParseJson and Table in a gallery. But this is the read part, any idea, how would I do the write part? – sampak Commented Feb 3 at 14:59

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

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

本文标签： powerappsPower App pulling data from Power Automate FlowStack Overflow