Populate a Microsoft Word template with information from specific row in SharePoint list

[StandaK]

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

[#2]

@StandaK 

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 | ....

[#3]

Hello @ZdenekHavel 

Thank you for the reply.

I did like you said:

But there is always error:

Link for error.

Any idea what that might be ?

Thank you,

[#4 · Accepted solution]

Hello @StandaK 

Filter query must be like this:

ID eq IDVariable

[#5]

@ZdenekHavel @StandaK and the dynamic content in the filter query must have single apostrophes before and after it:

The operators in a filter query are:
eq = equals
ne = not equals
gt  = greater than
ge = greater than or equals
lt = less than
le = less than or equals

Rob
Los Gallardos
Microsoft Power Automate Community Super User

[#6]

Hello @RobElliott and @ZdenekHavel 

Thank you both for your help and information. It is working now.

To bad I can not mark both of your answers as the best answer :-).

Thanks again and wish you the best Christmas ;-).

[#7]

@StandaK  do bear in mind that @ZdenekHavel 's answer was actually incorrect since the apostrophes were omitted 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

[#8]

@RobElliott 

You are true about that but he was the first who wanted to help and gave me a direction, which was also important .

And two other things..

1. It is Christmas so lets give credit to both of you
2. And based on his name I think we are neighbors (same country) 

Best regards,

Standa

[#9]

@StandaK no worries 

Rob