cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johanvena
Regular Visitor

Update input value to sharepoint list

Need help unable to update data to sharepoint list with following senario

* List name:- Clients
* Lookup Column:- Customer

* Lookup Value: CustomerValue (input text box name:- CustomerValue  (gets populated by selection box name:- DropdownCustomers)

* Column name to update:- FullName

* Value to update:- FullNameValue (input text box name:- FullNameValue  (gets populated based on selection box name:- DropdownCustomers)

 

This is my attempt but get following error:- Invocation of unknown or unsupported function

 

Patch(Clients, Lookup(Clients, Customer = CustomerValue,{FullName:FullNameValue});

 

and

 

Patch(Clients, Lookup(Clients, Customer = CustomerValue,{FullName:FullNameValue.Text});

 

When I do a normal patch everything is working

 

Patch('Clients',Defaults('Clients'),{FullName:FullNameValue.Text});

 

1 ACCEPTED SOLUTION

Accepted Solutions

Looks like you may have a close bracket missing for your lookup?.. after Customer Value.Text 

 

Can you try this?

View solution in original post

5 REPLIES 5
AmDev
Super User
Super User

Hi @johanvena 

 

Please add .Text after both TextInput controls 'CustomerValue' and 'FullNameValue' in all your formulas.

 

Hope this helps - Good Luck!

johanvena
Regular Visitor

Tried:-   Patch(Clients, Lookup(Clients, Customer = CustomerValue.Text,{FullName:FullNameValue.Text});
Not working still error
These type can't be compared: error,control 

Looks like you may have a close bracket missing for your lookup?.. after Customer Value.Text 

 

Can you try this?

Indeed forgot closed bracket thanx now working

Patch(Clients,LookUp(Clients, Customer=CustomerValue.Text),{FullName: FullNameValue.Text})

AmDev
Super User
Super User

That's great @johanvena - glad to hear it.

 

If this helped you, please consider marking this a solution. 👍

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (4,714)