cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Memorable Member
Memorable Member

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!





Highlighted
Memorable Member
Memorable Member

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!





Community Champion
Community Champion

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

Highlighted
Memorable Member
Memorable Member

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!





Highlighted
Memorable Member
Memorable Member

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!





Highlighted
Community Champion
Community Champion

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.

Highlighted
Memorable Member
Memorable Member

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!





Highlighted
Community Champion
Community Champion

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?

Highlighted
Memorable Member
Memorable Member

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!





Highlighted
Community Champion
Community Champion

Re: Patching problem

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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