Unable to Patch to Sharepoint List

[Dhanya]

I'm looking to patch 2 fields using patch. I have 2 drop down options. 

First drop down is 'My Name' and the 2nd drop down is 'I would like to shadow'. 

I'm looking to patch on submission, 2 items. 1st: 'I would like to shadow' selected field should be Host for . and 2nd 'My Name' to be updated in Guest column next to 'I would like to shadow'.

eg: Person A wants to shadow Person C. Person C will be Person A's host and Person A is Person C's guest. 

Name	Host	Guest
Person A	Person C
Person B
Person C		Person A

[eka24]

Use this;

Patch(Datasource Defaults( Datasource ), {Column1: Dropdown1.Selected.Value ,

Column2: Dropdown2.Selected.Value } )

If you have issues with the above formula, take a screenshot of the items property of the 2 dropdowns

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Dhanya]

Thank you @eka24 . I'm still facing issues. I now get error Guest does not match the expected type 'Text'. Screenshot of the items propery of the 2 dropdowns

[eka24]

What Data type are you patching to, Single line of text?

Please show a screenshot of the Patch formula:

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Dhanya]

Yes, it's a single line of text.  Screenshot below

[eka24]

Your formula is incomplete, kindly relook at the formula i stated above:

Patch(Datasource Defaults( Datasource ), {Column1: Dropdown1.Selected.Value ,

Column2: Dropdown2.Selected.Value } )

Or

Patch(Datasource Defaults( Datasource ), {Column1: Dropdown1.Selected.Result ,

Column2: Dropdown2.Selected.Result} )

Not: Dropdown2.Selected

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Dhanya]

Thank you @eka24 . I'm not looking to created a new record.  I have a single column with a list of names. This column feeds into Guest and host columns. eg: Person A wants to shadow person C. Both drop down lists reference the same column 'Name'. The Host results needs to be stored against the person who name is looked up (person C Host column against person A) and the Guest needs to be updated against the row Person C in Guest column

ame	Host	Guest
Person A	Person C
Person B
Person C		Person A

[yashag2255 · Accepted solution]

Hi @Dhanya 

Can you try to update the configuration as: 

Patch(DataSoureName, LookUp(DataSourceName, Name = 'My Name'.Selected.DisplayName), {Host: 'I would like to shadow'.Selected.DisplayName});Patch(DataSoureName, LookUp(DataSourceName, Name = 'I would like to shadow'.Selected.DisplayName), {Guest: 'My Name'.Selected.DisplayName});

Hope this Helps!

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. THANKS!

[Dhanya]

Thank you @yashag2255 . I only tried the first patch, but I got error. The function 'Patch' has some invalid arguments. and The type of this argument 'Host' does not match the expected type 'Text'.

I have tried Selected.DisplayName, Selected.Result, Selected.Text

[Dhanya]

I tried adding a new row and I get this message: 

I'm able to add a new row with this: Patch('GDP FY22 Job Shadow',Defaults('GDP FY22 Job Shadow'),{Guest:NTName.Text})

But not with the below: 

I've also tried adding selected.value and selected.result

All Sharepoint columns are single line text