cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Goerami
Regular Visitor

Save collection to Dataverse Table saves null

I'm trying to save a collection (called: artikelen) to a dataverse table (called: orderregels) by using the Patch function.

 

My collection has the following columns:

artikel

fabrikant

 

My Dataverse table has the following columns:

artikelnaam

fabri

And of course the default columns

 

I give a button the following formula:

 

ForAll( artikelen;
Patch('orderregels';

Defaults('orderregels');

{ artikelnaam: artikel ;
fabri: fabrikant
}
)
)

 

the problem is There is a new record created in the DataVerse table but the artikelnaam and fabri are empty (null)

I tried very many like artikelen(@artikel] but nothing seems to work. 

Please can anybody give me the solution?

 

thnx!

Erik

 

12 REPLIES 12
Goerami
Regular Visitor

@RandyHayes 

WOW! thnx! now I can see the items I added in the collection, but, now the formula to save the collection to the dataverse table gives an error. Powerapps say it expect a record and not a table :S 

 

Goerami
Regular Visitor

@RandyHayes I found what I did wrong. I forgot to refresh the Dataverse table. Now it works. Many many many thanks!!!

RandyHayes
Super User
Super User

@Goerami 

Happy to help!!

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,156)