Power Apps

Answered

In EditForm and ViewForm - I want datacardvalue to reflect Parent.Default but I have a funtion added in Default for NewForm

(0) Share

Report

Posted on by Sharinah1

101

Hi need your advice.

My DataCard in a NewForm Mode has this default function:

If(Day (Today()) >=20 && Day (Today ()) <=31, Text (Today(),"[$-en-US]mmmm yyyy"), Text (DateAdd(Today(),-1,Months) "[$-en-US]mmmm yyyy"))

This is to reflect the previous Month but if entered within 20th to 31st of the Month it will reflect month today. And this works well when adding new entries.

But I don't want this as default when the form is in View or Edit Mode. I want to reflect the Parent.Default.

I tried the syntax below but has error:

If(
Form3.DisplayMode = DisplayMode.New,
If(
Day(Today()) >= 20 && Day(Today()) <=31, Text(Today(),"[$-en-US]mmmm yyyy"),
Text(DateAdd(Today(), -1, Months),
"[$-en-US]mmmm yyyy")),
Parent.Default)
)

Thank you!

@NandiniBhagya20 @AhmedSalih @Drrickryp

Categories:

Building Power Apps

All responses (9)

Answers (2)

Sort by

Verified answer

AhmedSalih

6,680 Moderator on at

Like (1)

Report

Copy link

Link copied!

Hello, @Sharinah1 , you can use this:

If(FormName.Mode=FormMode.Edit || FormName.Mode=FormMode.View, 
Parent.Default, 
If(Day (Today()) >=20 && Day (Today ()) <=31, Text (Today(),"[$-en-US]mmmm yyyy"), Text (DateAdd(Today(),-1,Months) "[$-en-US]mmmm yyyy"))
)

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Sharinah1 101 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. I just tried now and still an issue. 😔
AhmedSalih 6,680 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Sharinah1 , what is the error that your are getting?
Sharinah1 101 on at

Like
a
(0)

Report
Copy link

Link copied!

Here is the Details.

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@Sharinah1, Okay, I see the error, use this formula in the Default property of the control inside the DataCard not the DataCard itself. So If you have an InputText inside the DataCard, select the InputText and add the formula into its Default property Instead. The Default property of the DataCard should be always: ThisItem.ColumnName << of the correspondent data.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@Sharinah1, It seems you are using the default of the Control in side the DataCard. Your Formula need to include the conversion from String to Date Function DateValue()

If(FormName.Mode=FormMode.Edit || FormName.Mode=FormMode.View, 
Parent.Default, 
If(Day (Today()) >=20 && Day (Today ()) <=31, DateValue(Text (Today(),"[$-en-US]mmmm yyyy")), DateValue(Text (DateAdd(Today(),-1,Months) "[$-en-US]mmmm yyyy")))
)

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Sharinah1 101 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you but I'm actually using this inside the Text Input.

I tried removing the "else" function in the meantime and it works properly. And then I also tried to use this
formula alone:

it works properly. But when merged to be a multiple if, there seems to be an issue.

Verified answer

AhmedSalih

6,680 Moderator on at

Like (1)

Report

Copy link

Link copied!

@Sharinah1, Try this:

If(FormName.Mode=FormMode.Edit || FormName.Mode=FormMode.View, 
Parent.Default, 
If(Day (Today()) >=20 && Day (Today ()) <=31, DateValue(Text (Today(),"[$-en-US]mmmm yyyy")), DateValue(Text (DateAdd(Today(),-1,Months) "[$-en-US]mmmm yyyy")))
)

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Sharinah1 101 on at

Like
a
(0)

Report
Copy link

Link copied!

It is working now thank you so much. Realized that I just need to input it part by part first. And apparently my datacard was blank instead of ThisItem.NameofColumn.