cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Patching problem

Hey @Meneghino

 

 

I tried it and it stays the same for some reason.

I don't know what I'm doing wrong.

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Super User
Super User

Re: Patching problem

Hey @Meneghino

 

 

Well I tried another bit and I found out this, when I look to the details in PowerApps from one order I get this:

Patch_Result.PNG

 

But in SharePoint it is still empty

 

Update: it was just Value1 that was showing the odata-type

 

Kind regards

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Highlighted
Meneghino
Level 10

Re: Patching problem

Hi @Tom_Slosse

I would suggest you try creating a new test list and a new blank app and see if this works for you doing the steps exactly as indicated:

https://powerusers.microsoft.com/t5/PowerApps-Forum/Solved-patching-to-SharePoint-choice-and-lookup-...

If it does not, then I will try to reproduce myself again.  If it does, then you will have a much clearer idea of what needs to be done.

View solution in original post

Super User
Super User

Re: Patching problem

Hey @Meneghino

 

 

Will follow your instruction and let you you know as soon as possible

Thanks for your effort and time, really appreciate it

 

Kind regards

 

 

Tom

 





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Super User
Super User

Re: Patching problem

Hey @Meneghino

 

 

Your solution worked, the only thing that was holding me back was the distinct function in the gallery.

So that's why I couldn't get the ID and Title value.

 

But now that my distinct is gone I have to find another solution to distinct that gallery otherwise the list is endless.

Any ideas how to solve that without hurting the Patch function?

 

Kind regards 

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Meneghino
Level 10

Re: Patching problem

Hi @Tom_Slosse

Can you please be a bit more specific as to why and how and where you use Distinct?

Thanks.

Super User
Super User

Re: Patching problem

Hey @Meneghino

 

 

This is what I had before I had to change it for the Patch function:

SortByColumns(Distinct(Broodjes,Beschrijving),"Result")

This code was in the BroodjesGallery in the property Itemsbroodjesgallery.PNG

 

Kind regards

 

 

Tom

 





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Meneghino
Level 10

Re: Patching problem

Hi @Tom_Slosse

I am finding it difficult to understand the structure of your data.  Since Broodjes is the lookup table, should it not have unique values of Beschrijving by design?  And if for some reason it does not, then can you not make the Beschrijving column itself a lookup column to a table with the distinct/unique values?

Super User
Super User

Re: Patching problem

Hey @Meneghino

 

 

Well you have multiple Descriptions that are the same but with different size and varieties of sandwiches like f.e.

Description: Bacon

Size: 1/2 french bread

Variety: White bread

 

Description Bacon

Size: 1/4 french bread

Variety: Brown bread

...

Thats a bit my problem to organise the data

 

Kind regards 

 

 

Tom





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





Meneghino
Level 10

Re: Patching problem

I see, now I understand.  I think you need a hierarchy type structure.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,271)