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
Solved! Go to Solution.
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
@RandyHayes I found what I did wrong. I forgot to refresh the Dataverse table. Now it works. Many many many thanks!!!
Happy to help!!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
199 | |
52 | |
41 | |
39 | |
35 |
User | Count |
---|---|
263 | |
86 | |
71 | |
69 | |
66 |