web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Custom dynamic item in...

Power Automate

Answered

Custom dynamic item in "update row"

(0) Share

Report

Report

Posted on by NicolasVerdie

23

Hi folks,

In my project, I'm trying to recover a dynamic data. By dynamic, I mean that with each execution of the script it will change.

This data is a date (every Friday). So I try to retrieve in an excel an "Date" data in the column of the previous week in relation to the day of execution of the flow.

So I created a variable "checkDates" containing the date I want with the right format.
But no way to retrieve the data in Excel. Either via item() or via items().

If you have an idea, I'm interested!

Thanks a lot !

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @NicolasVerdie,

You could refer to the following screenshot to get value of dynamic column:

item()?[variables('checkDates')]

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
NicolasVerdie 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

sorry for the late of my response.

This works ! Thank you so mush !

Join the conversation