web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Cannot use patch funct...

Power Apps

Answered

Cannot use patch function to pass dropdown data selection to Excel

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

surajkv 89 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous
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)})
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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"
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

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})
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @PriyankaGeethik

I have edited my respone.

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

Thank you very much.

Join the conversation