cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 III
Super User III

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
Memorable Member
Memorable Member

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

Frequent Visitor

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

 

Any suggestions? 

Memorable Member
Memorable Member

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?

Frequent Visitor

Yes please 🙂

Memorable Member
Memorable Member

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

Memorable Member
Memorable Member

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

Frequent Visitor

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? 

Memorable Member
Memorable Member

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 III
Super User III

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

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