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
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 In-depth analysis into 'Get items' and 'Get files' SharePoint actions for flows in Power Automate | Microsoft Docs.
Hello ZdenekHavel
Thank you for the reply.
I did like you said:
But there is always error:
Any idea what that might be ?
Thank you,
