web

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

News and Announcements icon

Power Platform CommunityForums Power Apps DateAdd does not want ...

Power Apps

Answered

DateAdd does not want to add date in the patch function

(0) Share

Report

Report

Posted on by Garjet1

18

Hi every one, I really can do with some help here for i'm a bit lost,

My code below should count the days between the date pickers. After that it should patch new items in the sharepointlist for as many days counted in the sequence. The only thing is: It does not add 1 day to the variable "VarEersteZaterdag" every time it runs over the patch. Below my code:

ForAll(
Sequence(
DateDiff(DatePicker1.SelectedDate;DatePicker2.SelectedDate));

Patch(MonteurPlanning;Defaults(MonteurPlanning);
{
Title: VarNieuweMonteur.Title;
XXFocusDatum: DateAdd(VarEersteZaterdag;Value(1);TimeUnit.Days)
}
)
)

Hope you can help me on my way. Thanks in advance

Kind regards Garjet

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Garjet1 ,

I do not know what you are doing with the Variable, but if you want a record for each date between the Date Pickers (inclusive of their dates), you would do this

ForAll( Sequence( DateDiff( DatePicker1.SelectedDate; DatePicker2.SelectedDate ) ) + 1; Patch( MonteurPlanning; Defaults(MonteurPlanning); { Title: VarNieuweMonteur.Title; XXFocusDatum: DateAdd( DatePicker1.SelectedDate; Value - 1; TimeUnit.Days ) } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Garjet1 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi warren, Thanks for your reply. Very helpfull.
I Adjusted the code and it works fine now.
Lateron I struggled a bit with an interval of 7 days because de DateADD only wanted to do 1 day interval. I adjusted the "number of units" to: Value * 7 and now it does a 7 days interval.

Thanks again for you help.

Kind regards
Garjet

Join the conversation