I have created a Power App with Excel as a data source. One of the columns in the Excel is "Status" Column with status Open and Closed. I have added a drop down to my Power App and pulled the Status Column and used Distinct to show Open and Closed in the drop down. But, when I change the selection in the dropdown from Open to Close and save the form, it does not reflect back in my Excel and does not change the status from Open to Closed.
Solved! Go to Solution.
Hi @JV_DXB ,
Firstly, make sure that the excel file is closed when you edit it in PowerApps.
Secondly, make sure that the status is not a read-only filed. If it's a read-only field, then it can't be updated in PowerApps.
You don't need to use the function of patch.
Set the status's DataCard's Update:
Dropdown1.Selected.status
Then, using the submitform will update the datacard's value.
Best regards,
Community Support Team _ Phoebe Liu
Hey! The code should be placed at the "Save" Control. You already have the submit form action on that so you can add a semi colon and add the code over there (onSelect property)
Hope this Helps.
Thanks.
Hey!
Please refer to the expression below:
Patch(Table1,LookUp(Table1,Name="Yash"),{Status: Dropdown2.SelectedText.Value})
Screenshot in powerapps editor:
Note:
Hope it helps!
Thanks,
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!
Dear @yashag2255
Thank you for your reply. Below screen from Power App. As you can see I have a dropdown and upon changing status from Open to Closed, I want the change to be saved back to the excel as well (open saving). I will have multiple fields being updated, not just the drop-down field.
Hi,
Can you please share the snippet of the code that you have used. I have tried and tested that formula and it updates the Excel as well.
Important Notes:
Can you share where is your excel file located? It should'nt be a static file on your computer. It should be somewhere on the internet (I mean onedrive, dropbox etc).
Also, it should not be opened while you are running the app.
Thanks,
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!
Where should I add your code? Should it be at save or at the dropdown? At Save, I already have SubmitForm(EditForm1). Also, the status can change from Open to Close or vice-versa.
Excel is located in OneDrive.
Hi @JV_DXB ,
Firstly, make sure that the excel file is closed when you edit it in PowerApps.
Secondly, make sure that the status is not a read-only filed. If it's a read-only field, then it can't be updated in PowerApps.
You don't need to use the function of patch.
Set the status's DataCard's Update:
Dropdown1.Selected.status
Then, using the submitform will update the datacard's value.
Best regards,
Community Support Team _ Phoebe Liu
Hey! The code should be placed at the "Save" Control. You already have the submit form action on that so you can add a semi colon and add the code over there (onSelect property)
Hope this Helps.
Thanks.
User | Count |
---|---|
193 | |
126 | |
89 | |
48 | |
42 |
User | Count |
---|---|
278 | |
162 | |
137 | |
81 | |
78 |