cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ClaireAllen
Post Prodigy
Post Prodigy

Connect Gallery to Form Error

Hello Community,

 

I am recently new to Power Apps, and have built a canvas app that connects to an excel file on my OneDrive.

 

I have completed all my steps, but now I am trying to connect my Gallery to my form as shown in my image

Screenshot 2020-11-17 125030.png

I selected the Forms Card and went to the Property section and selected Item and then in the formula I enter Gallery1.Selected, but I get an error 

Error details Power Apps.png

Can anyone help me resolve my error please?

Thank you in advance

Claire

8 REPLIES 8
RandyHayes
Super User
Super User

@ClaireAllen 

Yes, what is your Items property on the Gallery?  It must be based on Abartlett if you are going to try and edit an Item in the EditForm (which is based on Abartlett).

 

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
ganeshsanap
Memorable Member
Memorable Member

@ClaireAllen What is the DataSource of "Gallery1" control? 

 

The data source of Gallery1 and Form1 control should be compatible with each other (Should have same fields/columns).

 


Please click Accept as solution if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

 

Hello @RandyHayes 

 

The Items property on the Gallery is ABartlett, if I try to change it to Gallery1, I get errors

Screenshot 2020-11-18 110141.png

Do you have any suggestions?

Thank you & regards

Claire

Hello @ganeshsanap 

The data source for Gallery1 and Form1 are the same ABartlett, and I have the same fields/columns

Do you have any further suggestions?

Thank you & regards

Claire

RandyHayes
Super User
Super User

@ClaireAllen 

Well, so far all looks good.  Your datasource is ABartlett on both your Gallery and Form - all good.

Things to try:

1) Refresh your datasource ABartlett in your datasource list.

2) Cut your EditForm off the screen (ctrl-X), then do an undo (or ctrl-Z) to bring it back.

 

Also, have you been making any changes to the datasource since adding it to your app?  And, you did add the datasource as a OneDrive Excel file and it is in your Personal OneDrive?

 

Let's see if any of the above trigger any flags.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

@RandyHayes ,

 

Step 1 completed - Refreshed by Datasource

Step 2 completed

 

Yes I did my datasource as OneDrive Excel file, but its not on my personal OneDrive as this is a business flow and I am not able to connect to my personal OneDrive via my Business Connection.

Excel Datasource.png

 

The excel file does have multiple Tabs, does that make a difference, my understanding was that I could connect my datasource for each tab?

 

I appreciate your help with this, 

Thank you & regards

Claire

RandyHayes
Super User
Super User

@ClaireAllen 

Sorry for delay...trying to catch up on all the posts.  Are you still experiencing issues that you need help with?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

@RandyHayes ,

It's not an issue, thank you for coming back to me.

I've reconsidered the way I work with the Excel File and PowerApps, instead of using a Power App form, we are continuing to use an excel spreadsheet, and a Power Automate that updates a SharePoint List.

Kind regards

Claire

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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