Unanswered

Selection of an item from dropdown that reflects back in source

(0) Share

Report

Posted on by Aditya_G

Hi all,

I'm using an Excel source where I have two single cells, in one cell user selects current year and in other cell user selects current quarter. I want the user to choose from two dropdowns in PowerApps, the user selects quarter and year, and the selected quarter and year gets reflected back in Excel source in those two cells. I'm currently confused because those are changes in two single cells and not in a table. Let me know how to work around it.

Attached are two screenshots, one from PowerApps and other from Excel.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Geeks_D 1,169 on at

Like (0)

Report
Copy link

Link copied!

Reflected back as in the values get saved in Excel ?

Was this reply helpful? Yes No
Aditya_G 4 on at

Like (0)

Report
Copy link

Link copied!

Yeah, basically write back to Excel.
For tabular data it is easier as you just need to select the data source as the table and using Edit Forms, we can change the values in the table. But not sure how to do this for a single cell.

Was this reply helpful? Yes No
Aditya_G 4 on at

Like (0)

Report
Copy link

Link copied!

Yeah, basically write back to Excel.
For tabular data it is easier as you just need to select the data source as the table and using Edit Forms, we can change the values in the table. But not sure how to do this for a single cell.

Was this reply helpful? Yes No