cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MaryMThompson
Frequent Visitor

Patch/Collect? How to save data fields from a PowerApp

 

 

detail screen.png

 

Early this week I posted Re: Need Help with Calculated Fields .  Quick summary:  I am working on an App that will pull a specific commission rate based on the zip code, and then take that rate, mulitple it by the invoice amount, and then push parts of that data, to a seperate entity, that I will eventually trace back to a pending journal in BC.

 

With that being said, I have worked through the calculation issues, and now need to get this data extracted, and saved to an excel file.  I want only the fields in red to pull over.   The two top fields (No., and Salesperson) are fields that come from the mapped entity. The $22.5- (Due in Commission) is a text input box, and has a caluclation taking the Amount, and an entity field from the previous screen.

 

2019-07-16_7-40-04.png

 

When I use the collection function- it will not pull over this text input field.  When I use a Patch function on the Process button I get an error message about it not being the right data type.

 

What is the best option for what I am trying to achieve? Patch or a Collection? and how do I get that to work correctly?

 

Thank you!

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
MaryMThompson
Frequent Visitor

I am happy to say that I actually resolved this issue.  I ended up going with a collection approach.  After watching video's on PowerApps 911 https://www.youtube.com/watch?v=yS6mTRlmuls. I realized where I was going wrong in my collection approach.  I was not grabbing the correct DataCardValue.Text.

 

Here is what I found to be a working solution:

 

2019-07-16_11-40-03.png

 

 

 

View solution in original post

1 REPLY 1
MaryMThompson
Frequent Visitor

I am happy to say that I actually resolved this issue.  I ended up going with a collection approach.  After watching video's on PowerApps 911 https://www.youtube.com/watch?v=yS6mTRlmuls. I realized where I was going wrong in my collection approach.  I was not grabbing the correct DataCardValue.Text.

 

Here is what I found to be a working solution:

 

2019-07-16_11-40-03.png

 

 

 

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Kudoed Authors
Users online (22,754)