cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CFS
Frequent Visitor

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

Hi,

 

SCREEN SHOT A

 

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

 

 

 

SCREEN SHOT B

User interface of a screen in PowerApps (for mobile phone)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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-micsh-msft
Community Support
Community Support

 

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-micsh-msft
Community Support
Community Support

 

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CFS
Frequent Visitor

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

Appreciate it.

 

CFS
Frequent Visitor

This works. Many thanks!

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (5,208)