Forum Discussion

Copper Contributor

Dec 13, 2020

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 ?". (...

ZdenekHavel
Dec 16, 2020
Hello StandaK

Filter query must be like this:
ID eq IDVariable

ZdenekHavel

Copper Contributor

Dec 14, 2020

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

StandaK
Copper Contributor
Dec 14, 2020
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,
- ZdenekHavel
  Copper Contributor
  Dec 16, 2020
  Hello StandaK
  
  Filter query must be like this:
  ID eq IDVariable
  - RobElliott
    Silver Contributor
    Dec 16, 2020
    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