Unanswered

Dropdown Value into a Table on Another Screen

(0) Share

Report

Posted on by PBCBoss

I am having trouble trying to send a selected dropdown value to a table on another screen. As shown in the photos, the text in the textbox is able to be sent, however, the dropdown values and date picker selection is not sent over. What do I need to do to be able to make each form a new table row that includes the forms dropdown values and date selection after hitting the submit button. Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Mitanshu 1,658 Moderator on at

Like (1)

Report
Copy link

Link copied!

Under the OnSelect for the Button:

For Dropdown, you are using DropDown.Selected - This gives a Record and not a Text. You need to use DropDown.Selected.Value to get a text value (assuming your control name is DropDown).

Similarly for DatePicker - You need to use DatePickerCanvas1.SelectedDate (assuming your control name is

DatePickerCanvas1)

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
PBCBoss 63 on at

Like (0)

Report
Copy link

Link copied!

When I add DropDown.Selected.Value for the New Entry Slide, it says "Name isn't Valid. 'Value' isn't recognized". What does this mean, and do I need to do more to override this?

Was this reply helpful? Yes No
Mitanshu 1,658 Moderator on at

Like (2)

Report
Copy link

Link copied!

Again, DropDown3.Selected is a Record

- You need to pick a column from this record to display. Without knowing what columns you have in the datasource that is connected to the dropdown, it is not possible to advise. Typically, Value is a column found and hence that was suggested initially. Maybe try DropDown3.Selected.Color

- Use DropDown3.Selected. (notice the dot after Selected)and see if Power App suggests you some column. If not, share what columns you have in the datasource that is connected to the dropdown and which column you want to display.

@PBCBoss - Is your issue solved with the DatePicker?

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
PBCBoss 63 on at

Like (0)

Report
Copy link

Link copied!

I understand now. The Dropdown part works. The date however is showing up with a bunch of numbers like in the photo. How would this get corrected? Thank you for your help again.

Was this reply helpful? Yes No
Mitanshu 1,658 Moderator on at

Like (0)

Report
Copy link

Link copied!
It seems your problem of sending data from one screen to another is resolved.

However you have come across a different problem, where DatePicker.SelectedDate is giving you result in (probably) UNIX timestamp rather than in a human readable date.

You can try two approaches:

1 - Convert UNIX timestamp into date

Set(UnixTimestamp, DatePicker.SelectedDate); DateAdd(Date(1970, 1, 1), UnixTimestamp, TimeUnit.Seconds)

For reference, current UNIX timestamp (at the time of this comment) is around 1718825791 -- so if you are getting something close enough, then you can be confident that you are getting UNIX timestamp

2 - Format the result from DatePicker

Text(DatePicker.SelectedDate,"dd-mmm-yyyy")

If your original problem of reading values from one screen to other is resolved, you should accept a solution and close this thread. If your problem now is to read date from DatePicker, then you should start a separate thread.

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No