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
If this reply has answered your question or solved your issue, please mark this question as answered.
Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Solved! Go to Solution.
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
If this reply has answered your question or solved your issue, please mark this question as answered.
Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
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
If this reply has answered your question or solved your issue, please mark this question as answered.
Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
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:
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.
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
If this reply has answered your question or solved your issue, please mark this question as answered.
Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
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
If this reply has answered your question or solved your issue, please mark this question as answered.
Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Hi @Tom_Slosse
Can you please be a bit more specific as to why and how and where you use Distinct?
Thanks.
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
If this reply has answered your question or solved your issue, please mark this question as answered.
Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
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?
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
If this reply has answered your question or solved your issue, please mark this question as answered.
Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
I see, now I understand. I think you need a hierarchy type structure.