Forum Discussion
Populate a Microsoft Word template with information from specific row in SharePoint list
Hello,
I am relatively new in Power Automate and I am trying to create new flows.
I have SharePoint List with lost of items.
Then I have form in Sharepoint with one question "ID ?".
(Sorry for Czech language in this screen)
I created a flow:
When I fill out the form, for example with ID 3, then the flow will start. And what I need from this flow is to insert row number 3 (ID of the row is 3) into the document with all information in that row.
Creating the document is working. I tested that. But I do not know how to insert only information from the specific row into document.
Can you please someone give me advice ? I tried something but nothing worked.
I appreciate any help :-).
Thank you and have a nice evening,
Standa
8 Replies
Hello,
there is the straightforward way how to do that. In Get Items step, click on "Show advanced option" and then, you must fill
- Filter query - to get item with specific ID you must use query: ID eq intVariable (this variable you must get from the form response)
- Top Count - it's a good idea limit number of responses, in this example set count to 1.
More info about filtering you can found at https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files#filter-queries.
Hello ZdenekHavel
Thank you for the reply.
I did like you said:
But there is always error:
https://prod-92.westeurope.logic.azure.com/workflows/45f233c7a777421ab4c16636df7f5d0b/runs/08585936502674784067220570969CU57/actions/Get_items/contents/ActionOutputs?api-version=2017-07-01&se=2020-12-14T18%3A00%3A00.0000000Z&sp=%2Fruns%2F08585936502674784067220570969CU57%2Factions%2FGet_items%2Fcontents%2FActionOutputs%2Fread&sv=1.0&sig=oF5d4kAGPO1j0BGJWkF_m-qVUCxlQmTY38uJwVmW_w0
Any idea what that might be ?
Thank you,