Hi @yashag2255 ,
That was quite an impressive notice; unfortunately I did this in a hurry on the DisplayMode, but originally it was giving the error on the Default property (I don't have a TEXT property)
This is the error I got when I tried entering it on the Default property - screenshot below
Thank you for replying back so promptly, I seem to solve complex problems but struggle with the simple ones
Good day @yashag2255 ,
I tried moving the "AMOUNT REQUESTED" into the same form as "SERVICES", and everything worked fine.
Are there any restrictions to keep them in different forms though? I don't see a reason it should honestly but I may be unaware of certain powerapps rules.
My goal is to have them on seperate forms for user experience purposes and to also have flexibility of playing around with the design.
Any advice would be appreciated - thanks 😃
Hi @Luka84 ,
Could you please share a bit more about the "AMOUNT REQUESTED" field in your SP list? Is it a Number type column?
Do you want to populate the calculation value within the "AMOUNT REQUESTED" field based on the 'SERVICE 1 AMT' field value, 'SERVICE 2 AMT' field value, ...?
Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Please consider set the Default property of the "AMOUNT REQUESTED" field Text Input box to following:
'SERVICE 1 AMT'.Text,
'SERVICE 2 AMT'.Text,
'SERVICE 3 AMT'.Text,
'SERVICE 4 AMT'.Text,
'SERVICE 5 AMT'.Text,
'SERVICE 6 AMT'.Text,
'SERVICE 7 AMT'.Text
Sum( Value('SERVICE 1 AMT'.Text), Value('SERVICE 2 AMT'.Text), Value('SERVICE 3 AMT'.Text), Value('SERVICE 4 AMT'.Text), Value('SERVICE 5 AMT'.Text), Value('SERVICE 6 AMT'.Text), Value('SERVICE 7 AMT'.Text) )
If the issue still exists, please add a Label control (SUMOFAMTLabel) within your app, set the Text property to following:
Sum( 'SERVICE 1 AMT'.Text, 'SERVICE 2 AMT'.Text, 'SERVICE 3 AMT'.Text, 'SERVICE 4 AMT'.Text, 'SERVICE 5 AMT'.Text, 'SERVICE 6 AMT'.Text, 'SERVICE 7 AMT'.Text )
Then set the Default property of the "AMOUNT REQUESTED" field Text Input box to following:
Hi @v-xida-msft ,
I appreciate your detailed response, I really do !!
But i tried all these solutions without success, and after many tests i realized it is probably not working because I have the "AMOUNT REQUESTED" on a different form than "SERVICE COSTS" - the error is related to a Circular reference.
I even tried assigining the value of my SUMOFAMT label, also with fail
Screenshot below, I really hope we can fix this, since I use this field for my MS FLOW and I really don't want to make so many changes there as it works and I dont want to break anything lol 😃
Hi @yashag2255 ,
I really don't know what to say - since the issue seems to be from my end I ended up doing the following workaround:
Seems to be working fine; therefore I will be closing this as solved.
Thank you, and to everyone who tried to help me with my issue - This is truly appreciated !!
Stay well 😃
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications