Answered

Udating date and time field in editable grid

(0) Share

Report

Posted on by Ape Awakening

301

In my Canvas App , with Sharepoint as data source and 1:M relationship for SP List A to SP List B , I'm create and update my child list using a editable grid and Parent record using a form at the top of the grid.
When my form is in New mode ,
I'm creating record child record using below formula, colGridExpenData is the collection from the grid

ForAll(
                    colGridExpenData As itemCC,
                    Patch(
                        SP List B,
                        Defaults(SP List B),
                        {
                            Title: itemCC.Title,
                            ParentIDtxt: Text(SP List A.ID),
                            'Date From': itemCC.'Date From' + Time(Hour(itemCC.'Date From'),Minute(itemCC.'Date From'),0),
                            IsCredit: itemCC.IsCredit,
                            VAT: itemCC.VAT,
                            Currency: itemCC.Currency,
                            'Account Amounts': itemCC.'Account Amounts',
                            Amounts: itemCC.Amounts,
                            ExchangeRate: itemCC.ExchangeRate,
                            SNo: itemCC.SNo,
                            ExpenseFor: itemCC.ExpenseFor,
                            'Expense Type': itemCC.'Expense Type'
                        }
                    )
                )



and Updating it with below formula 

 
Patch(
                SP List B,
                UpdateIf(
                    colGridExpenData ,
                    Created = Blank(),
                    {
                        ID: Blank(),
                        ParentIDtxt: SP List A.ID
                    }
                )
            )



Everything is working fine except my Date and Time field, where its not storing the time in my date field.


Please help me understand the issue .

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,061 Most Valuable Professional on at

Like (0)

Report
Hi @Ape Awakening

Why are you adding the time again when the field is already Date/Time ? Also the structure below is far more efficient
Patch( SP List B, ForAll( colGridExpenData As itemCC, { Title: itemCC.Title, ParentIDtxt: Text(SP List A.ID), 'Date From': itemCC.'Date From', IsCredit: itemCC.IsCredit, VAT: itemCC.VAT, Currency: itemCC.Currency, 'Account Amounts': itemCC.'Account Amounts', Amounts: itemCC.Amounts, ExchangeRate: itemCC.ExchangeRate, SNo: itemCC.SNo, ExpenseFor: itemCC.ExpenseFor, 'Expense Type': itemCC.'Expense Type' } ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
WarrenBelz 153,061 Most Valuable Professional on at

Like (0)

Report

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No