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

Connect form to multiple excel tables

Hello,

 

I have an excel workbook (Onedrive) with multiple tables. 

 

I have created a form and used the data from one of these table. I want to create a drop down that have the data from the second table. 

 

How to achieve that? 

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Connect form to multiple excel tables

Hi @Khader

 

Here's a post that I answered a few days ago. Perhaps this might help you?

 

https://powerusers.microsoft.com/t5/Creating-Apps/Drop-Down-Box-Lookup/m-p/82000#M823

View solution in original post

9 REPLIES 9
Sienna Memorable Member
Memorable Member

Re: Connect form to multiple excel tables

One of the best solution is to not use forms. I'm not using a form whatsoever unless I need to edit something really very simple in my database. Forms are very limited to use but I'm sure this can be achieve there but I would never recommend that

Khader
Frequent Visitor

Re: Connect form to multiple excel tables

I will be doing some editting to my excel tables. That's why I'm using forms. 

 

Any suggestions? 

Sienna Memorable Member
Memorable Member

Re: Connect form to multiple excel tables

Use patch function. Manualy insert all your items in the screen. Link them with the excle row you want to edit and patch it into your database. Do you want me to give you simple example how to do it?

Khader
Frequent Visitor

Re: Connect form to multiple excel tables

Yes please 🙂

Sienna Memorable Member
Memorable Member

Re: Connect form to multiple excel tables

I'm not sure what happend but my post was removed so once again

My databse is very simple with column name and amount

 

1/Create gallery and link it with your database

gal.png

 

2/Crate 2 TextInputs and link them to your selected gallery row

 

text.png

 

3/ and finaly crate a button with patch function

 

Patch(Test,Gallery1.Selected, {Name:TextInput2.Text, Amount: Value(TextInput1.Text)})

 

patch.png

Sienna Memorable Member
Memorable Member

Re: Connect form to multiple excel tables

the example is for editing.. for adding row just modify pach function to

 

Patch(Test,Defaults(Test), {Name:TextInput2.Text, Amount: Value(TextInput1.Text)})

 

You can find more about the patch here

https://docs.microsoft.com/en-us/powerapps/functions/function-patch

Khader
Frequent Visitor

Re: Connect form to multiple excel tables

That's interesting. Thanks a lot!

 

Question: According to the requirements, I have to use forms. Again, how can my drop down in a form have data from another table? 

Sienna Memorable Member
Memorable Member

Re: Connect form to multiple excel tables

In that case I can't help you but trust me there are no requirements to tell you to use forms. Hopefully someone will help you with it soon. Good luck 😉

Super User
Super User

Re: Connect form to multiple excel tables

Hi @Khader

 

Here's a post that I answered a few days ago. Perhaps this might help you?

 

https://powerusers.microsoft.com/t5/Creating-Apps/Drop-Down-Box-Lookup/m-p/82000#M823

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (7,483)