@BS10 -
It is difficult to visualise what you're trying to do.
As I understand it, you have what I assume is a SharePoint list. This list contains a single-select Choice field. The choices contained in that field are the days of the week (Monday, Tuesday etc).
You have another field in your list which is a calculated column. This displays a number value for each day entered in your list (which has already been populated with data).
You have multiple Edit Form controls across 5 screens. In your Form, you have added the Choice field as a DataCard.
You want to Filter the combobox control inside the DataCard on a specific number returned in the Calculated day column in your list.
To do this, on the Items property of the Choice combobox in your Form, enter:
Distinct(
Filter(
'Your List',
'Your Calculated Column' = 1
),
'Your Choice Field'.Value
)
On the Update property of the DataCard, enter:
LookUp(
Choices([@'Your List'].Choice),
Value = 'Your Choice Combobox'.Selected.Value
)
However, I would recommend that you avoid using Calculated columns. These columns are very unwieldy and were created for the SharePoint user experience in mind. If the ultimate intention is for users to interact with the data using an app, I would replace the calculated column with a Number column, and then handle all calculations within your app.
