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.

View solution in original post

CFS
Frequent Visitor

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

Appreciate it.

 

CFS
Frequent Visitor

This works. Many thanks!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (3,527)