News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Is there a way to writ...

Power Automate - Using Flows

Answered

Is there a way to write an output of a Compose into a certain field IF the output fulfills a condition?

(0) Share

Report

Report

Posted on by DragosNae

12

Hello,

I'm trying to use the "dateOfWeek" function to return the day of a timestamp.

I would then like to write a certain value into a specific field, based on the returned day of week.

Example:

- timestamp returns 2 (Tuesday) => I want to write myValue ("Duration") into the column "Tue" of the Excel file

- timestamp returns 5 (Friday) => I want to write myValue ("Duration") into column "Fri" of the Excel file

I've added a screenshot of the fields.

Any help would be appreciated.

Thank you.

All responses Img

All responses (2)

Answers Img

Answers (1)

DragosNae 12 on at

Like (1)

Report

Re: Is there a way to write an output of a Compose into a certain field IF the output fulfills a condition?

Worked like a charm, thank you very much!
Verified answer

David- 1,254 on at

Like (0)

Report

Re: Is there a way to write an output of a Compose into a certain field IF the output fulfills a condition?

You can use an expression similar to this:

if(equals(dayOfWeek(utcNow()),2),'value if yes', 'value if no')

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,668 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans