Unanswered

Auto populate one choice column value to another choice column value according to the value in label

(0) Share

Report

Posted on by Mahesh006

Hello Team,

I have one date(datacardvalue01) field date and 2 choice fields in form i.e., 1. X_Hours (1 to10) (datacardvalue02), 2. Y_Hours(1 to10)

I have written a label on top of date filed in form i.e., text (Datacardvalue01.SelectedDate,LongDate) which will be shown as

(Weekday (Sunday, Monday etc.) based on the selected data, Month (January, Ferbraury etc.) based on the selected data, Year (2020,2021,2022) based on the selected data.

My scenario is if label weekday is Monday i.e. it should auto populate X_Hours (1 to10) value into Y_Hours (1 to10)

I have written a code in Default Property of Y_Hours(1 to10) choice column like this if("Monday" in label.text,datacardvalue01.selected.value) but it is not working.

Please help me to solve this scenrio

Thanks

Mahesh

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Mahesh006,

Modify your formula as below:

If("Monday" in Label6.Text,X_Hours.Selected.Value)

Was this reply helpful? Yes No
Mahesh006 4 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-qiaqi-msft

I am trying with form component. i wrote a code like If("Tuesday" in Label.text, DatacardValue02.text.Selected.Value) but it is throwing a error like "EXPECTED A RECORD VALUE"

Thanks
Mahesh

Was this reply helpful? Yes No
Mahesh006 4 on at

Like (0)

Report
Copy link

Link copied!

hello @v-qiaqi-msft

FYI - here label should be selected value from the date card value from the form.

Thanks
Mahesh

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Mahesh006,

Could you please tell me that if X_Hours (1 to10) and Y_Hours (1 to10) are both Combo Box?

How you set the Items property of the X_Hours (1 to10) and Y_Hours (1 to10)?

I have the formula on the Default property of a Dropdown box instead of a Combo Box.

Was this reply helpful? Yes No