cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Default value

Good afternoon, I have a CALENDARIO list where there are all the dates of the years and I assigned a week and a month for each one, here is an example:
CALENDARIO LIST.PNG 

So, I have 2 dropdowns one to filter months and another to filter weeks:
Dropdowns.PNG

Here are the items property:
Month dropdown: 

Distinct(CALENDARIO;MES)

Week dropdown: 

Distinct(Filter(CALENDARIO;MES=Lista_meses.SelectedText.Result);SEMANA)

 

What I need is to set the default property in the dropdown to see today's week assigned in the list. In this case to show '09/03-15/03 (SEMANA 2)'

today.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Default value

@JoseC12 

Here's a different LOOKUP for you to try.  I forgot about the ISTODAY function which is what we need to use here.

LookUp(CALENDARIO, IsToday(FECHA), SEMANA)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

10 REPLIES 10
Highlighted
Super User
Super User

Re: Default value

@JoseC12 

What happens when you try this code in the Default property of the dropdown?

LookUp(CALENDARIO, FECHA=Today(), SEMANA)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Highlighted
Helper V
Helper V

Re: Default value

Hi @mdevaney 

error.PNG

they are not equivalent

Highlighted
Community Champion
Community Champion

Re: Default value

Hi @JoseC12 ,

If I am reading this right, you simply need to add FECHA to the search, so

 

Distinct(
   Filter(
      CALENDARIO;
      MES=Lista_meses.SelectedText.Result &&
      DateDiff(
         FECHA,
         Now(),
         Days
      )=0
   );
   SEMANA
)

 

***************************
Update no responses when I started post. I see @mdevaney  handling now. I will leave you with him.

 

 

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.

 

 

Highlighted
Helper V
Helper V

Re: Default value

Hi @WarrenBelz 

what you wrote is to filter only today's week (Items property), I'm asking to set the default value (Default property)

Highlighted
Super User
Super User

Re: Default value

@JoseC12

What column type is FECHA in SharePoint?  Examples are: Text, Number, Date, Choices, Yes/No..

Highlighted
Helper V
Helper V

Re: Default value

@mdevaney Date&Time

Highlighted
Community Champion
Community Champion

Re: Default value

Hi @JoseC12 ,

As noted in my update, after I posted, I saw @mdevaney was handling and also saw your reply. I will leave you with him.

Highlighted
Helper V
Helper V

Re: Default value

@WarrenBelz alright thanks anyway

Highlighted
Super User
Super User

Re: Default value

@JoseC12 

Here's a different LOOKUP for you to try.  I forgot about the ISTODAY function which is what we need to use here.

LookUp(CALENDARIO, IsToday(FECHA), SEMANA)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (8,824)