Cannot use patch function to pass dropdown data selection to Excel

[afeenan]

Hi,

I have tried using both of the below on a 'Submit' button in my app.

Patch(Requests, Defaults( Requests ) ,{Space: Dropdown1.Selected})

Patch(Requests, Defaults( Requests ) ,{Space: Dropdown1.SelectedText})

 The error I get is "This type of argument 'Space' does not match the expected type 'Text'. Found type 'Record'.

The drop-down data is from a table in another excel file.

I would appreciate any help or advice.

[surajkv]

Hi @afeenan 

can you please try this

Patch(Requests, Defaults( Requests ) ,{Space: Text(Dropdown1.Selected)})

or
Patch(Requests, Defaults( Requests ) ,{Space: Value(Dropdown1.Selected)})

or
Patch(Requests, Defaults( Requests ) ,{Space: Value(Dropdown1.Selected.Value)})

[afeenan]

Thanks for your reply. I have tried both options and both return the same error:

"Expected text or number. We expect text or a number at this point in the formula"

[PG_WorXz10 · Accepted solution]

Hi @afeenan ,

Please try the below formula. Instead of value if you used some other column select that column name. 

Patch(Requests, Defaults( Requests ) ,{Space: Dropdown1.Selected.Value})

[afeenan]

Hi @PG_WorXz10 

I have edited my respone.

When I swap 'value' with the column name it works fine.

Thank you very much.