Get Dynamic column data in SharePoint get items

(1) Share

Report

Posted on by Community Power Pla...

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

All responses (18)

Answers (1)

Community Power Pla... on at

Like (1)

Report

Re: Get Dynamic column data in SharePoint get items

A star you are!
That was it.

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

cheers
Verified answer

J_Porter on at

Like (0)

Report

Re: Get Dynamic column data in SharePoint get items

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')]
Community Power Pla... on at

Like (0)

Report

Re: Get Dynamic column data in SharePoint get items

Hi
I tried but no go
Var set to:
items('Apply_to_each_2')?[outputs('Compose_datefield')]

and still the same

cheers
PrasadAthalye on at

Like (1)

Report

Re: Get Dynamic column data in SharePoint get items

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...
Community Power Pla... on at

Like (0)

Report

Re: Get Dynamic column data in SharePoint get items

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

Thanks
J_Porter on at

Like (0)

Report

Re: Get Dynamic column data in SharePoint get items

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.
Community Power Pla... on at

Like (0)

Report

Re: Get Dynamic column data in SharePoint get items

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 on at

Like (0)

Report

Re: Get Dynamic column data in SharePoint get items

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

Like (0)

Report

Re: Get Dynamic column data in SharePoint get items

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 on at

Like (0)

Report

Re: Get Dynamic column data in SharePoint get items

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.