Save Button for Individual Text Input & Dropdown

(0) Share

Report

Posted on by Humanity

278

Canvas App with individual Text Inputs & Dropdowns. NO galleries. All separate.

How do we use a Save button to update independent ( Text Input & Dropdown selections into Google Sheets table records.

Database Output = Google Sheet

House Dropdown = Used to select a table row

This is an example of a Text Input - Default: 'House DropDown'.Selected.Building_Type

I use a DropDown to determine which row in the Google Sheets table to work with.

Patch('Database Output',
First( Filter('Database Output',ID='House DropDown'.Selected.House_List) ),

{User_Company:'IP User Company PD'.Text,

User_First_Names:'IP User First Names PD'.Text,

User_Last_Names:'IP User Last Names PD'.Text,

User_Country: 'User Country PD'.Selected.CountryList})

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (2)

Sort by

Gareth_C 38 on at

Like (0)

Report
Copy link

Link copied!

Use google sheets as your connector or create a collection and use flow to write to google sheets.
Thanks
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Humanity 278 on at

Like (0)

Report
Copy link

Link copied!

The connector is already made, I have no problem pulling the table.
I did this a long time ago, but I completely forgot how I wrote the function.

How would I post the input text & dropdown values to CDS so that Flow could post?

But, I'm thinking if I could do that, then it would be the same function as if posting to Sheets, would it not?

Was this reply helpful? Yes No
Gareth_C 38 on at

Like (0)

Report
Copy link

Link copied!

Please watch this video
This will explain how to use google sheets with PowerApps
https://www.youtube.com/watch?v=h3za1oheYRs

Thanks
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Humanity 278 on at

Like (0)

Report
Copy link

Link copied!

@Gareth_C
Thanks Gareth... that video is for Model-Driven apps though. Or for if you are using a gallery. For this app, each text field & dropdown is independently placed around instructions. So I have to pull & push each one separately. It does look like they did a good job on the vid though. 👍

I added mention of Canvas with individual inputs to make it more clear.

Was this reply helpful? Yes No
Verified answer

Pstork1 69,427 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
For a canvas app you can use the following to update an existing record

Patch(Sheet1,First(Filter(Sheet1,ID=ID_Value.Text)),{User_Company:UserCompany_Value.Text,User_First_Names:UserFirstName_Value.Text})

Sheet1 was the name of the Google Data Source

ID_Value was the name of the value property in the ID Data Card

UserCompany_Value was the name of the value property in the User Company data card

You can continue to add fields to the record based on the headers in the Google Sheet. Not sure I understand your problem. The code works for me. Are you using a form or just text fields?

Was this reply helpful? Yes No
Humanity 278 on at

Like (0)

Report
Copy link

Link copied!

@Pstork1

Using Text Input & Dropdown without forms.

ID_Value was the name of the value property in the ID Data Card

Please forgive me. You lost me on "... value property in the ID Data Card."

Was this reply helpful? Yes No
Humanity 278 on at

Like (0)

Report
Copy link

Link copied!

@Pstork1

This is an example of a Text Input - Default: 'House DropDown'.Selected.Building_Type
I use a DropDown to determine which row in the Google Sheets table to work with.

Was this reply helpful? Yes No
Pstork1 69,427 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Sorry, DataCards are the way Forms display things. If you are using just text boxes then it should work User_company is a text box.

Was this reply helpful? Yes No
Pstork1 69,427 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
To set defaults for the text box using a dropdown as a reference you would need to use the same First(Filter()) function you use when patching the record. Then add the fieldvalue you want to the end. Something like this

First(Filter(Sheet1,ID=Dropdown1.SelectedText.Value)).User_Country

Was this reply helpful? Yes No
Humanity 278 on at

Like (0)

Report
Copy link

Link copied!

@Pstork1

This alone gives me the value for the defaults... 'House DropDown'.Selected.Building_Type

Is there a problem with using that? The column is chosen based on the row selected in House DropDown.

Was this reply helpful? Yes No