cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tamer66
Helper III
Helper III

Problems with Datediff minus days

Hello,

 

i have a list with a datetime field in my SharePoint. In my App i change the fill color of an icon if i found a record like this

 

If(LookUp(myControlList;Title = DropdownGew.Selected.Result;true);RGBA(255; 0; 0; 1);RGBA(0; 0; 0; 0))

 

My Problem is, i would change only the Fill Color if additionaly the datetime is minus x days

 

Is this possible or has anyone an idea?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

@Tamer66 Is your formula error flagged? I doubt that this syntax is correct:

DropdownGew.Selected.Result

Could you try with: 

DropdownGew.SelectedText.Value

 And also the reference to your Sharepoint list, but here I'm not sure. You could try this: 

DateAdd(myControlList.KontrollDatum;-7;Days)

View solution in original post

3 REPLIES 3
TJO
Resolver II
Resolver II

@Tamer66 You could use the DateAdd() Function: 

DateAdd(DatePicker.SelectedDate, -7, Days)

 

Hi,

 

thanks an think it is the right way but my formula not working and i dont know what's the Problem.

 

If(LookUp(myControlList;Title=DropdownGew.Selected.Result && DateAdd(KontrollDatum;-7;Days); true );RGBA(255;0;0;1);RGBA(0;0;0;0))

 

So the KontrollDatumist the dateTime field in my SP List

 

Take a look here

Tamer66_0-1599140421580.png

 

@Tamer66 Is your formula error flagged? I doubt that this syntax is correct:

DropdownGew.Selected.Result

Could you try with: 

DropdownGew.SelectedText.Value

 And also the reference to your Sharepoint list, but here I'm not sure. You could try this: 

DateAdd(myControlList.KontrollDatum;-7;Days)

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,196)