Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Unanswered

The type of this argument does not match the expected type 'DateTime'. Found type 'Text'.

Posted on by
Hi, im new to poewApp but loving it so far!
 
I am trying to patch data back to an Excel ( Excel Online(Business) Data source), but keep getting this error. Ive set my datasouce to "Text" and nothing. any help wouldb be great.!
 
Here is my code:
ForAll(
    Gallery3.AllItems,
    If(
        !IsBlank(inputName_txt.Value),
        Patch(
            NameList,
            Defaults(NameList),
            {Name: inputName_txt.Value,
             EntityType: InputEntity_drpdwn.Selected.EntityTypes
            }
        )
       
    )
),
 
Clear(myInput);
Notify("Rows have been successfully saved to the database.", NotificationType.Success);
Reset(inputBpNumber_txt);
 
// Repopulate myInput collection with 10 empty entries
ClearCollect(myInput,
ForAll(Sequence(10), {Name: "", EntityType: "", Relationship: "", Involvement: "", CountryOfResidency: "", Notes: ""})
);
 
This is the errro im getting:
 
The type of this argument 'EntityType' does not match the expected type 'DateTime'. Found type 'Text'.
 
 
 
  
  • WarrenBelz Profile Picture
    WarrenBelz 143,532 on at
    The type of this argument does not match the expected type 'DateTime'. Found type 'Text'.
    Firstly, try Blank() instead of "" on the collection of that field.
     
    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,532

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,050

Leaderboard