Forum Discussion

Copper Contributor

Dec 13, 2020

Solved

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 https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files#filter-queries.

StandaK

Copper Contributor

Dec 14, 2020

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,

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
  - StandaK
    Copper Contributor
    Dec 16, 2020
    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 ;-).