Dynamically create dynamic content

[Redders]

Hi All,

Is there a way to dynamically create dynamic content?

I have a flow where I have a filter array action, I want to dynamically change the filter query depending on a value received. 

My flow is triggered when a HTTP request is received, as part of that call I receive a column name.

I get data from a SharePoint document library where there are additional columns. The columns are boolean. 

The filter array works if I add the dynamic content for the column then say equals true

I want to dynamically change the dynamic content based on the value received from the trigger.

Is this possible or do I need to create a condition for each?

[abm]

Hi @Redders 

Could you please post a screenshot of your flow?

Thanks

[Redders]

Hi @abm,

[abm]

Hi @Redders 

Thanks for your quick reply. You mentioned earlier that as part of the HTTP call you receive the column name. Above screenshot where you using the HTTP body values?  Is it always going to be a single column name it returns?

Thanks

[Redders]

Hi @abm,

Yes, it will just provide the name of just 1 of the columns.

My thoughts are whether I can dynamically change the filter based on that value. 

Within the screenshot you can see that it based on the column name of 'Underground', if I received 'Poling', could this be changed to the poling column instead?

[abm]

Hi @Redders 

Could you post a sample screenshot of the HTTP response? (Data format)

Thanks

[Redders]

It has 1 field - WorkType

[abm]

Hi @Redders 

I was asking about a sample format?

{

  "Colunname": "xxx"

}

Something like that?

Or is it returns just a plain text as one value?

[Redders]

{

  "WorkType": "Overhead"

}

[abm]

Hi @Redders 

So I believe every time you get different a different values for WorkType? If it is then why not use

body('Parse_JSON')?['WorkType']

[abm · Accepted solution]

Hi @Redders 

Ignore the above. Try using the above filter

item()?[body('Parse_JSON')?['WorkType']]

See below

Above expression for the filter is as follows:

item()?[body('Parse_JSON')?['WorkType']]

Thanks

[grantjenkins · Accepted solution]

To simplify it a bit you could just have a Filter Query within Get files based on the dynamic column from the trigger, so it only returns the items you want from the SharePoint Library.

[Redders]

Hi @grantjenkins,

Oh my gosh, I cannot believe that I have overlooked this!!

I started out trying to use this, changed my solution and completely forgot about it when trying to resolve the issue posted above.

Thank you