You’re offline. This is a read only version of the page.
247
Hello,
i have a SharePoint list "A" with a column "Vendor Name" which is a "single line of text" and then i created a canvas app named "new".
i have data but i was wondering if i can somehow pull previous data from the "Vendor Name" field at canvas. I need this in order not to have the same vendor introduced twice e.g.
1) Microsoft
2) Microsoft Corp.
thank you
thank @WarrenBelz as mentioned this is great!!
Just open the screen and select OnVisible from the drop-down at top left and add the code in the box to the right of this
For the Save, add it after your SubmitForm() command.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
@WarrenBelz hello,
you mention "add this to the screen OnVisible and your Save function" and i dont know where do i find this.
This is what i meant.
let me know pls
Sorry I do not understand your last question. Also the OnVisible is on the Screen settings.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
@WarrenBelz that is amazing thank you so much.
i have not used the last portion
Share
Report
All responses (
Answers (
UpdateContext({varMatch:Blank()})
as i dont know where is the OnVisible.
Also i went at your bog (thank you) and the last portion for the Text, where is that exactly?
thank you
In addition to the below, I have now done a blog on the process and expanded the functionality.
Hi @kouliscon ,
The user needs to press enter after entering the first few matching letters. The example below is on a test list I have, but could be used on any list.
There are only two things to set - the OnChange of the Text box
With(
{
wMatch:
If(
!IsBlank(Self.Text),
LookUp(
YurListName,
StartsWith(
YourFieldName,
Self.Text
)
).YourFieldName
)
},
UpdateContext(
{
varMatch:
If(
!IsBlank(wMatch),
wMatch,
Self.Text
)
}
)
)and the Default of the Text Box
If(
!IsBlank(varMatch),
varMatch,
Parent.Default
)NOTE: Parent.Default is only necessary if the box is in a Form as you want to show the existing value once saved. You would also add this to the screen OnVisible and your Save function
UpdateContext({varMatch:Blank()})
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
thank you @WarrenBelz
i will try to be more clear about my request so maybe you can assist me better.
i have a SharePoint Online list and a specific column which is type of "Single line of text" we use it for introducing the Payee Company name e.g. "Microsoft"
i would like to know if there is a way to when starting to inputting the name "Microsoft" to identify that the value exists already at the column and to appear.
the reason i want to do something like that if is possible is to not have duplicate data like "Microsoft", "Micro Soft"...etc
let me know if you understand and if is possible.
thank you
Hi @kouliscon ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @kouliscon ,
Yes, you can search most things as long as you have a query that will result in a single record.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
