web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How to get the value o...

Power Automate

Answered

How to get the value of the sharepoint in select tag

(0) Share

Report

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:

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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'))

Join the conversation