Unanswered

Patching Drop Down value into Excel

(0) Share

Report

Posted on by Rama96x

149

Hello everyone, this is my first time asking a question in this forum, so please feel free to give me any kind of feedbacks regarding the structure of my question etc.

My challenge:

For my data storage I have created an Excel table. In this table I have an empty column called Status.

I'm trying to pass the value from a drop down list into this column (I have hardcoded three options in this dropdown; Completed, On going and Not started.

E.g., a user chooses an option called 'Completed' in the drop down list, I want this to be patched into the empty column (Status).

A criteria for this is that I don't want to submit this value into Excel with a button. So as soon as someone chooses "Completed" I want that to be visible in Excel. Obviously, as default all the records in the Status column in Excel will be "Not started".

I'm well aware of the Patch function, but I only know how to use this, when you are working with a form and a button that Submits the form

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (2)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Hey! If you can set the Patch() Function on OnChange property. Plus, you can always set a timer. Check this video from Reza, it will help you out

https://www.youtube.com/watch?v=8I0Pt_8I6k8&t=1478s

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Rama96x ,

Could you please give some more background on the requirement like this functionality should happen for new records only or while editing any records also ?

Was this reply helpful? Yes No
Rama96x 149 on at

Like (0)

Report

@Nogueira1306
So the OnChange property kind of works, but what it instead did, it just created a new row for the value in the drop down list. I have attached an image of the data source. What I'm trying to do is to patch it in the same row as 'John Doe'

Was this reply helpful? Yes No
Rama96x 149 on at

Like (0)

Report

@PriyankaGeethik
Thank you for the reply. So basically, when creating a new record (a new form) the default row should be set to "Not started" and then a user (the admin) will have an option where they can choose "On going" or "Completed". This should then update the column that before was "Not started"
Hope this makes it more clear 🙂

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Check the video taht I sent you

https://www.youtube.com/watch?v=8I0Pt_8I6k8&t=1478s

He has create, update and delete

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Was this reply helpful? Yes No
Rama96x 149 on at

Like (0)

Report

@Nogueira1306
I did follow the video you sent the first time, but again, it doesn't work for me. Thank you for your time!

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Rama96x ,

For editing the item are you selection the value from gallery ?

Was this reply helpful? Yes No
Rama96x 149 on at

Like (0)

Report
@PriyankaGeethik I'm selecting the value from a dropdown list that I created my self (I have hardcoded 3 options in here). My patch looks like this:
Patch(Table1,{'FeedbackCompleted': drpCompleted.Selected.Value})
After the data source name I have tried to write ThisItem, but I'm not allowed to do this.

Was this reply helpful? Yes No
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
Hi @Rama96x ,

I am concerned about the condition by which you will patch
For e.g if you have a specific record for which you want to patch. Something like below
UpdateIf(Table1,ID=ItemID,{'FeedbackCompleted': drpCompleted.Selected.Value})
For e.g if you want to patch/update all the records having status Not started. Something like below
UpdateIf(Table1,FeedbackCompleted="Not started",{'FeedbackCompleted': drpCompleted.Selected.Value})

Please let me know your update or patch condition.

Was this reply helpful? Yes No
Verified answer

Rama96x 149 on at

Like (1)

Report
So I kind of figured it out. My drop down menu was located in a different screen, so I couldn't choose ThisItem in that screen. However, when I moved the drop down menu to where my Gallery is located, it now works with the property set to OnChange and with the code:
Patch([Data source], ThisItem, {[ColumnNameFromSharepoint]: [NameOfDropDown].Selected.Value})
It was the ThisItem that didn't work for me before.

It's a work-around, which is a little bit annoying because I wanted the drop down to be located in a different screen (DetailScreen), but it works now...

Was this reply helpful? Yes No