Where to use data validation and calculated fields

[mattterry13]

I'm currently building a canvas app that has a form for users to add/edit items in a SharePoint list. I have an excel file that stores current currency codes and their respective conversion rates to Euros so users can select the currency code and their input will automatically be converted to Euros. I'm wondering if it's easier to implement a data validation field/combo box and calculated field in the app itself, or directly in the sharepoint list (assuming it's possible in both instances). If it was done in the SharePoint list, I would still like for the data card with the converted amount to display in the form when the user filled out the other information, so hopefully that's a possibility? I didn't know if there was one preferred way of doing this over the other?

[WarrenBelz]

Hi @mattterry13 ,

Do the calculation in Power Apps - SharePoint calculated fields have many limitations in Power Apps, including Delegation.

Please click Accept as solution 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 Thumbs Up.

[mattterry13]

Okay thanks for the info. I'm assuming I can do this using the existing datacards that were created when I linked the form to the SharePoint list and updating the properties?

[WarrenBelz]

Hi @mattterry13 ,

The best way really is a Variable that is triggered when all the elements required are present. If not, make the Default of a Text control the value.

Please click Accept as solution 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 Thumbs Up.

[WarrenBelz]

Hi @mattterry13 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution 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 Thumbs Up.

[mattterry13]

I actually had to take care of some other stuff and am just coming back to this now -you did answer my initial question, I'll likely have some more questions about actually implementing your recommendation so will post again shortly. 

[WarrenBelz · Accepted solution]

Hi @mattterry13 ,

You can calculate it off the fields you have in the linked table the same as you did in SharePoint. You can either use a label in the form or (better still) set a Variable to the calculation when you open the record.

Please click Accept as solution 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 Thumbs Up.

[mattterry13]

Okay, I just want to make sure I'm understanding correctly. I now have 2 SharePoint lists: one list is simply currency codes, conversion rates and the date the rate is retrieved (this is updated weekly). The second is the actual tracker with all the detailed information. The second list also contains currency codes and and conversion rates. In the form itself, I can set it up so that the currency code field is a drop-down from the first list, and there's a conversion variable that automatically converts the input to euro and populates the second list with both the rate in Euros and the currency code the data was input with from the first list? I'm still new at this so uncertain how I can mix the two lists in one form.

[mattterry13]

Looks like I was able to figure out what I needed for this step - thanks for the assistance