web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Update input value to ...
Power Apps
Answered

Update input value to sharepoint list

(0) ShareShare
ReportReport
Posted on by 10

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});

 

Categories:
  • Gerard Simpson Profile Picture
    2,987 Moderator on at

    Hi @johanvena 

     

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

     

    Hope this helps - Good Luck!

  • johanvena Profile Picture
    10 on at

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

  • Verified answer
    Gerard Simpson Profile Picture
    2,987 Moderator on at

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

     

    Can you try this?

  • johanvena Profile Picture
    10 on at

    Indeed forgot closed bracket thanx now working

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

  • Gerard Simpson Profile Picture
    2,987 Moderator on at

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

     

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 258

#3
Mohsin Ali Profile Picture

Mohsin Ali 231

Last 30 days Overall leaderboard