How to get the value of the sharepoint in select tag

(0) Share

Report

Posted on by nagestiada

504

Hello guys, I am filtering a row from Sharepoint list and wanted to use the value from column Date_To and Date_From to a variable

I want it to be transferred or called to a variable so that I can convert the format of the dates and use the variable to create a date range from Date_From to Date_To

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Expiscornovus 33,181 Most Valuable Professional on at

Like (0)

Report
Re: How to get the value of the sharepoint in select tag

Hi @nagestiada,

You are only expecting one item in that Select action?

If that is the case you could try and use the below expression in a string variable:

Make sure you second key in the Select action is renamed to DateTo (I see you are using the same key twice) 😉.

concat(formatdatetime(first(body('DateFrom'))['DateFrom'], 'dd-MM-yyyy'), 'to ', formatdatetime(first(body('DateFrom'))['DateTo'], 'dd-MM-yyyy'))

Was this reply helpful? Yes No