Answered

Power App to Sharepoint Form

(0) Share

Report

Posted on by Bryanna

I have a Power App connected to a Sharepoint form and am having issues with the correct fields populating when the date range is selected. The team enters a date range and then fields become enabled depending on this range. Ex. If my Start Date was January 1,2023 to June 30,2023 I would expect January - June Fields to become enabled. However, right now June - December become enabled instead. Below is the formula being used when I select the January card. Any help is appreciated!

//Parent.DisplayMode
If(DataCardValue10.Selected.Value="Variable Monthly Savings (Enter Quantity)" ,
If(DateDiff(DataCardValue6.SelectedDate,DataCardValue7.SelectedDate, TimeUnit.Months) >= 0,DisplayMode.Edit, DisplayMode.Disabled), DisplayMode.Disabled)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Bryanna ,

Do you want to set cards of January to June are editable when the Start Date is from January to June?
Please try this:
If(DataCardValue10.Selected.Value="Variable Monthly Savings (Enter Quantity)" , If(Month(DataCardName.SelectedDate)>=1&&Month(DataCardName.SelectedDate)<=6,DisplayMode.Edit, DisplayMode.Disabled), DisplayMode.Disabled)

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Bryanna 24 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Yes, cards show up as editable depending on the start and end date selections.

How would I format it though if someone can do any combination of months. So they can enter something for January through March, January through December, March through December, etc.

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

Like (0)

Report
Copy link

Link copied!
Hi @Bryanna ,

I assume your cards look like this：
Please try this:
For Visible of each card:
//JanuaryCard !IsBlank(LookUp(Sequence(DateDiff(DatePicker3.SelectedDate,DatePicker4.SelectedDate,TimeUnit.Months)+1,Month(DatePicker3.SelectedDate)),Value=1)) //FebruaryCard !IsBlank(LookUp(Sequence(DateDiff(DatePicker3.SelectedDate,DatePicker4.SelectedDate,TimeUnit.Months)+1,Month(DatePicker3.SelectedDate)),Value=2)) . . . //DecemberCard !IsBlank(LookUp(Sequence(DateDiff(DatePicker3.SelectedDate,DatePicker4.SelectedDate,TimeUnit.Months)+1,Month(DatePicker3.SelectedDate)),Value=12))

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Bryanna 24 on at

Like (0)

Report
Copy link

Link copied!

Looks like i am getting an error on the ! ....any thoughts?

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Bryanna ,

Please try this:
If( !IsBlank( LookUp( Sequence( DateDiff( DateCardValue6.SelectedDate, DateCardValue7.SelectedDate, TimeUnit.Months ) + 1, Month(DateCardValue6.SelectedDate) ), Value = 0 ) ),DisplayMode.Edit,DisplayMode.Disabled)

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Bryanna 24 on at

Like (0)

Report
Copy link

Link copied!

that worked!! thank you so much!

Was this reply helpful? Yes No