Answered

Vacation Selection Program Code Problem

(0) Share

Report

Posted on by tguckiran

This code is not working but I can't understand the reason. 😕
This is basically Vacation Program.
What is the problem of this code?

ForAll(
 Gunler;
 If(
 Text(Value) <> "1.01.2001";
 Patch(
 PSY;
 Defaults(PSY);
 {
 Kişiler: Text(User().FullName);
 Başlık: "İzinli";
 Proje_Saati: "9";
 Tarih: Value;
 Faaliyet: "İzin";
 Lokasyon: "Ev"
 }
 )
 )
)

 

 

&
Navigate(AnaEkran) &
Reset(TarihSeçimi_1) &
Reset(TarihSeçimi_2) &
Set(Gorunurler; 0)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @tguckiran ，

It seems that Patch() is Right.

I consider Text(Value) <> "1.01.2001" is wrong.
May I ask what is the "Gunler" in your formula?

Best Regards,
Tina

Was this reply helpful? Yes No
tguckiran 36 on at

Like (0)

Report
Copy link

Link copied!

It is the Turkish word which means "days".

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @tguckiran ,

May I ask what's in this table, and what are the field types?

Best Regards,
Tina

Was this reply helpful? Yes No
tguckiran 36 on at

Like (0)

Report
Copy link

Link copied!
Set(Gunler; ForAll(Sequence(TarihGorevBaslangic-TarihIzinBaslangic); If(Weekday(TarihIzinBaslangic + Value - 1) in [2; 3; 4; 5; 6]; TarihIzinBaslangic + Value - 1; "-1")))

I will share code for "Gunler",

Was this reply helpful? Yes No
Verified answer

v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @tguckiran ,

According to your formula, we made a sample for you.
You can double Click "ForAll" and to see what data in the "Gunler" .

Take the data I'm currently showing as an example, please try this:
ForAll( Gunler; If( Text(Value) <> "1/1/2001, 12:00:00 AM"; Patch( PSY; Defaults(PSY); { Kişiler: Text(User().FullName); Başlık: "İzinli"; Proje_Saati: "9"; Tarih: Value; Faaliyet: "İzin"; Lokasyon: "Ev" } ) ) ) & Navigate(AnaEkran) & Reset(TarihSeçimi_1) & Reset(TarihSeçimi_2) & Set(Gorunurler; 0)

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No