Get Dynamic column data in SharePoint get items

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building flows

I have the same question (0)

All responses (18)

Answers (1)

Sort by

PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi
This is screenshot, no errors but nothing is retrieved.
I am trying to email myself this data and nothing is in outputs .

Thanks

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

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

string() function and then test?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks, I tried
string(items('Apply_to_each_2')?[outputs('Compose_datefield')])

and still nothing

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks

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

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi

which translates to

Thanks

Was this reply helpful? Yes No
J_Porter on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No