cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SamantaBoodram
Level: Powered On

Re: Saving Data to Excel

See attached error

SamantaBoodram
Level: Powered On

Re: Saving Data to Excel

other error

Super User
Super User

Re: Saving Data to Excel

Hey @SamantaBoodram, I see I had more typos that are part of the errors you are getting. In the first line there should be a comma between Patch(Table2 and If(IsBlank(LookUp...

So, with your changes:

ForAll(
    Farms,
    Patch(
        Table2,
        If(
            IsBlank(LookUp(Table2,  'Growout' = Farms[@'Growout'])),
            Defaults(Table2),
            LookUp(Table2,  'Growout' = Farms[@'Growout'])
        ), 
        {
            'Growout': Farms[@'Growout'],
            'Age': Farms[@'Age'],
            'Farm': Farms[@'Farm'],
            'DatePlaced': Farms[@'DatePlaced'],
            'QtyPlaced': Farms[@'QtyPlaced'],
            'Weight': Farms[@'Weight'],
            'TARWeight': Farms[@'TARWeight'],
            'MTD': Farms[@'MTD'],
            'Feed': Farms[@'Feed'],
            'PDF': Farms[@'PDF'],
            'Comments': Farms[@'Comments'],
'LOU%': Farms[@'LOU%']
} ) )

Notice the single quotes around the column names (the ' characters). Those are optional for column names that don't have a space in the name but required for ones that do. I am guessing you renamed your columns so I tried to match that in the formula.

Try that out and we'll see where things are. Hopefully we're getting there! 

SamantaBoodram
Level: Powered On

Re: Saving Data to Excel

See attached error

Super User
Super User

Re: Saving Data to Excel

@SamantaBoodram 

From looking at your original Excel file, it looks like the DatePlaced column is really 'Date Placed'

I would change that reference in your formula to 'Date Placed'

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Super User
Super User

Re: Saving Data to Excel

As @RandyHayes  said, the error you are getting now is due to the name of your DatePlaced column. Those column names need to match exactly what is in your data source. I had assumed you had changed them because of the different names in your previous screenshots, but maybe that isn't the case? If you go through your table and make sure each column name matches its reference in the formula, it should clear things up.

SamantaBoodram
Level: Powered On

Re: Saving Data to Excel

Hi,

 

just to clairfy the names on the left and on the right should match the excel file or the edit form?

SamantaBoodram
Level: Powered On

Re: Saving Data to Excel

See attached

Super User
Super User

Re: Saving Data to Excel

@SamantaBoodram 

Coming into this post on page 4...not sure how your Farms collection is set up, but you might try this on that line in your formula:

'Date Placed': DateValue(Farms[@'Date Placed']),
_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
SamantaBoodram
Level: Powered On

Re: Saving Data to Excel

I added some screenshots with the results when I changed it and also with what the collection contains.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 290 members 4,031 guests
Please welcome our newest community members: