Patching problem

[Tom_Slosse]

Hey all

I want to know if it is possible to Patch a Textbox.Text into a SharePoint lookup column? 

And how is it done?

If this would be possible all my problems would be solved!!!

Thanks in advance

Kind regards

Tom

[Tom_Slosse]

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

[Tom_Slosse]

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:

But in SharePoint it is still empty

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

Kind regards

Tom

[Meneghino · Accepted solution]

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.

[Tom_Slosse]

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

[Tom_Slosse]

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

[Meneghino]

Hi @Tom_Slosse

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

Thanks.

[Tom_Slosse]

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 Items

Kind regards

Tom

[Meneghino]

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?

[Tom_Slosse]

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

[Meneghino]

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