Unanswered

Every Monday in picklist

(0) Share

Report

Posted on by CU17121854-0

Hi,

I used this code to get every Monday of the week in a picking list. It was working very well.

ClearCollect(weeksList,
 ForAll(Sequence(52,-26,1) As DD,
 DateAdd(DateAdd(Today(),-Weekday(Today(),Monday)+1),7 * DD.Value ,Days)
 )
);

I don't know why, it now shows time with the date. Can you help me to get ride of this time ? Since this, my gallery isn't working. Is there a way to get around this ?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yujincui-msft on at

Like (1)

Report
Hi @jlarouche21 ,

Maybe you can try the following formula:

ClearCollect(weeksList, ForAll(Sequence(52,-26,1) As DD, Text(DateAdd(DateAdd(Today(),-Weekday(Today(),Monday)+1),7 * DD.Value ,Days),DateTimeFormat.ShortDate) ) );

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
rbn_nue on at

Like (0)

Report

Hi @v-yujincui-msft

This helped me. But how can I modify it to get values of current financial year (eg: 2022 April 1 to 2023 March 31)
Could you please help?

Thanks,
Robin

Was this reply helpful? Yes No