Creating a Temporary Collection

(0) Share

Report

Posted on by billf24

169

Could use some help with creating a Temporary Collection.

The following statement is used to create the collection with empty cells:

NewForm(frm_Master);ClearCollect(RequestCollection, {LineDate: "", LineLocation: "", LinePerDiemDate: 0, LineNotes: "", LineTravelDay: "", LineReimbursement: 0, LineHousing: "", LineCar: ""});Navigate(NewRequest,ScreenTransition.Fade)

What I am not sure of are items like the LineDate and Yes/No choices.

Also, when creatng the Vertical Gallery,, do I use the Date Picker or Text Input? If the Date Picker, how do I reference it to the LineDate in the Collection? Same with the Yes/No columns.

In my Dataverse Table, Date is set as a Date Picker, and three other columns are set as Yes or No.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

@billf24 ,
Why are you creating the temporary collection?

Was this reply helpful? Yes No
billf24 169 on at

Like
a
(0)

Report
Copy link

Link copied!

I am creating repeating tables before posting to the Dataverse Table.

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

So you are going to use the form to populate the Collection?

Was this reply helpful? Yes No
billf24 169 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, then write back to the Dataverse Table

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

You could set your form to your Dataverse Table and let it populate the data cards. Then change the form DataSource =RequestCollection . If the column names are identical between dataverse and the collection you shouldn't have to change anything else. Otherwise, you may have to adjust the DataField, DisplayName, and Default of each card.

In the Gallery's DatePicker use ThisItem.LineDate

Not sure exactly how to show the Yes/No other than text.

Was this reply helpful? Yes No