cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rowlinx
Level: Powered On

Re: Need an alternative to BrowseGallery1.Selected in an editform

It's a sharepoint list called proptest#2

 

 

Anonymous
Not applicable

Re: Need an alternative to BrowseGallery1.Selected in an editform

Are you 100% sure that the field names are correct and that the cases match exactly to the cases in SharePoint

rowlinx
Level: Powered On

Re: Need an alternative to BrowseGallery1.Selected in an editform

I had originally shortened it to ProposalNumber just when I replied to you for simplicity. But yes I'm sure everything is correctly named. I believe the error is more specifically in BrowseGallery1, because it gets highlighted when I double click the error symbol, but that is the correct name for that form. 

 

Patch('proptest#2', BrowseGallery1.LastSubmit, {Proposal_x0020_Number:ID+1699974})

nickduxfield
Level 8

Re: Need an alternative to BrowseGallery1.Selected in an editform

I saw the add to ID and I realised you were trying to use powerapps to continue an old database.

Is your datasources in a SharePoint List or somewhere else. It is important you know because you cant usually edit, or even patch the ID column. Its not something you can change.

You know what I think. The ID column may not be critical for you unless you are replicating your old database again. If thats the case, you should rethink that idea unless you know how.

If this is an Excel in a OneDrive then this could be easy to replicate.

 

If not, youre now replicating, you should conduct a test case first before you bring on the original database.

create another table with entries. If you can edit the table directly, edit the ID to reflect the ID numbers your targeting, say 1337755678.

Now create some records using the edit form.

Verify that the ID column increments normally to 1337755679... and so on.

 

After that consider if you need to do what you mentioned.

Anonymous
Not applicable

Re: Need an alternative to BrowseGallery1.Selected in an editform

I think I see the problem.

 

Patch('proptest#2', BrowseGallery1.LastSubmit, {Proposal_x0020_Number:ID+1699974}) should be 

Patch('proptest#2', BrowseGallery1.LastSubmit, {Proposal_x0020_Number:BrowseGallery1.LastSubmit.ID+1699974})

nickduxfield
Level 8

Re: Need an alternative to BrowseGallery1.Selected in an editform

I was going to say that, The source name In my experience is not right and the character # I dont beleieve is allowed. This is the case in SharePoint. It may be just an Excel.

I was going to suggest. removing the source, Changing the name, then readding it. Initally it will throw errors, but it will get back to order after that. 

Anonymous
Not applicable

Re: Need an alternative to BrowseGallery1.Selected in an editform

Wait I typed the wrong thing.

 

Patch('proptest#2', BrowseGallery1.LastSubmit, {Proposal_x0020_Number:ID+1699974}) should be 

Patch('proptest#2', New_Form.LastSubmit, {Proposal_x0020_Number:New_Form.LastSubmit.ID+1699974})

 

You need to use the form name not the browser name.

View solution in original post

rowlinx
Level: Powered On

Re: Need an alternative to BrowseGallery1.Selected in an editform

Oh my god you're amazing it worked! Thank you so much, I really really apreciate it! What a great way to end off the day 😄

Highlighted
Anonymous
Not applicable

Re: Need an alternative to BrowseGallery1.Selected in an editform

I can not believe I did not notice earlier. I think that has been the problem for a while.

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,102)