web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Applying a formula to ...
Power Automate
Unanswered

Applying a formula to a specific property from List Rows

(0) ShareShare
ReportReport
Posted on by

Hey fellow dudes/dudettes, 

 

My flow fetches data from an excel file using the "List rows from table action". Then, I use the "Create csv table" action to map field names to their values as shown below:

Hm_20_0-1604063482956.png

However, Test Due, because it is a date in the Excel file, gets converted to a number. I have a formula that I use to revert back that number to a date. But, I cannot apply that formula to the "Test Due" dynamic field without getting an error. This is quite logical since "Test Due" here is not a one value: it represents the whole column of Test Due data.

 

Please advise as to how I can apply this formula for each value in the "Test Due" column. 

Categories:
  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi @Hm_20 

     

    You can try out something like this: 

     

    formatDateTime(item()?['Start time'],'yyyy-MM-dd')
     
    Here, item()?['Start Time'] is my excel column and you can use item()?['Test Due'] in your expression you are trying to build. 
     
    Hope this Helps!
     
    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 389

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard