web

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

News and Announcements icon

Power Platform CommunityForums Power Apps DateDiff in Power Auto...

Power Apps

Answered

DateDiff in Power Automate is a String?

(0) Share

Report

Report

Posted on by R_KW

80

Hi all,

I am using PowerApps in Teams and I created a Power Automate to change the field value if the selected date is smaller than today.

PowerAppsDay1.Run(DateDiff(Today(),DateValue(Gallery6.Selected.'Join Date')),LookUp(Progress_Table,Name=Chosen,'Day 1'),Chosen);

Here's the result. It became String, even if I added Int() to it.

Any idea how to fix it? Thanks!

Categories:

Building Power Apps

All responses Img

All responses (6)

Answers Img

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @R_KW ,

Convert the variable using the formatDateTime() function
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey! Try this:
Initialize a var of type string and set it for the the item from power apps.

Then, Initialize another var of type int and set it to Int( THE VAR YOU CREATED BEFORE)

So you can force it

Try it and tell me something
R_KW 80 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Nogueira1306

Thx for responding! But it didn't work well.
Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Okay, check this post:
https://powerusers.microsoft.com/t5/General-Power-Automate/Convert-text-to-number/m-p/40776#M36793
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@R_KW if it does not work you can try this in Power Apps:

PowerAppsDay1.Run(Value(DateDiff(Today(),DateValue(Gallery6.Selected.'Join Date'))),LookUp(Progress_Table,Name=Chosen,'Day 1'),Chosen);
R_KW 80 on at

Like
a
(0)

Report
Copy link

Link copied!

Thx! It works

Join the conversation