Read from a column in Excel Online and add new inputs to another column

[CFS]

Hi,

SCREEN SHOT A

Data Source - a table in Excel Online (in OneDrive for Business)

SCREEN SHOT B

User interface of a screen in PowerApps (for mobile phone)

1)

I am trying to make the "Space Type" in SCREEN SHOT B to start off by automatically showing "Meeting Room 1" (reading the data from the table in SCREEN SHOT A). So that the app user could use the dropdown to select a "Status" (either "Empty" or "Occupied" ~ this has already been set)

2)

After point 1 above is done, the app user should be able to see "Meeting Room 2" automatically appearing on the user interface (SCREEN SHOT B) and from which the app user could then input the "Status" for this Meeting Room 2 (either "Empty" or "Occupied" from the dropdown menu)

3)

The user interface should then continue to progress down the list (Column A of SCREEN SHOT A) until the last item ("Meeting Room 5") so that the app user could input the "Status" for each of the meeting rooms.

The parts in red font in the above three points are the problems that I face.

Kindly help.

Very much appreciated. Thank you.

[v-micsh-msft · Accepted solution]

Per my understanding, please take a try with the steps below:

1. Under the Text property of the Label (Assuming its Label1 ) control, enter the following:

First(Distinct(Filter(TableA, IsBlank(Status)), Space Type)).Result

2. Under the OnChange property of the dropdown control, enter the following:

Patch(Table7,LookUp(TableA,Space Type=Label1.Text),{Status:Dropdown1.Selected.Value});ReSet(Dropdown1)

Once the Dropdown has Value changed, it will save to the Data Source.

So for the items of the Dropdown, it is recommended to set as:

["Please Select","Empty","Occupied"]

Let me know if this works for your scenario.

Regards,

Michael

[CFS]

Thank you! Will test it out & update you soon.

Appreciate it.

[CFS]

This works. Many thanks!