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

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