Hello everyone,
I am very new to powerapps and sharepoint. Your help would be greatly appreciated.
I have a table RWB(Region Wise Budget) Available defined in sharepoint list as shown in the following screenshot.
I want to know, how to access a cell value for a specific year and a quarter. Please refer the formula i am trying to use but am not able to work it properly.
"currregion" variable is recognized inside the lookup function, but it is unknown outside the function.
For context, datacardvalue264 is the value from a card in an edit form which is to be submitted by user.
What i want to do is extract the available budget for the selected region (in the input form) for the current year and financial quarter use it as a validation against trip totals, before allowing the user to submit the form.
This code is written in the Onselect() function of the submit button.
(if avlbudg>total, patch() is called)
Thanks in advance.
@WarrenBelz @Pstork1
