Get Dynamic column data in SharePoint get items

[Anonymous]

Hi

I am trying to retrieve dynamic column's data in flow using SharePoint get items but I am unable to

The following works:
items('Apply_to_each_2')?['MinCorroDueDate']

The following does not work:

items('Apply_to_each_2')?[outputs('Compose_datefield')]

where 

outputs('Compose_datefield') = 'MinCorroDueDate'

I want to do this as I want to get dynamic column each time, they are all data columns but they can be different.

Any suggestions?

Thanks

[PrasadAthalye]

Can you please upload your flow picture and tell us what error are you getting and where exactly its failing?

[Anonymous]

Hi

This is screenshot, no errors but nothing is retrieved.

I am trying to email myself this data and nothing is in outputs .

Thanks

[PrasadAthalye]

Can you check what is the output of Compose? Also, can you convert that to string using 

string() function and then test?

[Anonymous]

Thanks, I tried

string(items('Apply_to_each_2')?[outputs('Compose_datefield')])

and still nothing

[PrasadAthalye]

Inputs and outputs both appear to be empty on compose.. can you tell me what is the input expression of compose?

[Anonymous]

Thanks

string(items('Apply_to_each_2')?[outputs('Compose_datefield')])

[PrasadAthalye]

Looks like you have another compose.. Can you upload picture of Compose Datefield?

[Anonymous]

Hi

which translates to

Thanks

[J_Porter]

Perhaps try using the longhand expression items('Apply_to_each_2')?[actions('Compose_datefield').outputs]

Although it could be that the expressions seems to search for the 'Apply_to_each_2' section which doesn't house 'Compose_datefield' so it may be feasible to try just actions('Compose_datefield').outputs or outputs('Compose_datefield')

Difficult to tell without assuming flow structure and layers. Let me know if this helps.

[Anonymous]

Thanks.

I tried both

items('Apply_to_each_2')?[actions('Compose_datefield').outputs]

AND

items('Apply_to_each_2')?[outputs('Compose_datefield')]

and they both came out as empty string.

cheers

[J_Porter]

What do you get when you just use actions('Compose_datefield').outputs or outputs('Compose_datefield') without the "items('apply_to_each_2')?[]" ?

[Anonymous]

Hi

That comes out as its supposed to with the dynamic column I want to get value for but when combined with apply to each , it does not work.

Thanks

[J_Porter]

I see.

You have a SharePoint action somewhere giving 'Apply_to_each_2' it's dynamic content.

What is that item?

From what I can see using items('Apply_to_each_2')? will gather dynamic content from that SharePoint dynamic item. 

[Anonymous]

Hi

Yes it gets it from sharepoint get items and then loops as shown.

Thanks

[PrasadAthalye]

So Instead of this Compose, can you test it with a string variable and see if that works? I think this compose output is not a string. Maybe you can remove single quotes... I tested with variable and it worked...

[Anonymous]

Hi

I tried but no go

Var set to:

items('Apply_to_each_2')?[outputs('Compose_datefield')]

and still the same

cheers

[J_Porter · Accepted solution]

Perhaps the original value needs to be converted to a string before being used in the second compose?
In 'compose_datefield' remove the signal quotes and use string():

string() = outputs('compose_datefield')

then run your flow as you had it with items('Apply_to_each_2')?[outputs('Compose_datefield')]

[Anonymous]

A star you are!

That was it. 

It does not even needs changing to string, simply pass in the variable and all good.

cheers