Hi,
I have this logic that if this is a new request the status should be 'Not Yet Started' but once it is submitted the status should be the one that chose by the requestor in the dropdown.
For Example: When I open this app and want to create a new one the status should be 'Not yet Started' then after I populate all the fields and in status dropdown I chose 'Approval Request' then once I click the submit button the status should be 'Approval Request'. Thank you in advance.
Hi Ethan,
Thank you so much for your help. My issue has been resolved! 🙂
Hi @Abardaje1194 ,
Choices('column name (datasource)')
Here, your column name is as per datasource and not in the App.
You are getting info from ur datasource.
Circular reference means you are directly making same control value dependent on itself somehow.
Avoid that,
Change the syntax of the code and it will work, don't hard-code -> the app will give suggestions from ur list.
Hi Ethan,
Thanks for the prompt reply.
Hi Ethan,
Tried but it didn't work.
Hope it helps to resolve my issue!
Hi @Abardaje1194 ,
So if you wanna set something like that, use this formula
If(!IsBlank(DataCardValue35.SelectedItems), [Parent.Default], Choices('Approval Status (<DataSource Name>)'.'Not Started'))
//Considered column name as 'Approval Status' and your Table or List name as <DataSource Name>
//Do replace with your values
//The ( .'Not Started' ) I considered as Value in Status, make Sure you set yours.
//You will see your values as you enter the dot
Hope this helps
Hi Ethan,
Tried this logic in DefaultSelectedItems property but it didn't work
If(!Isempty(DataCardValue35.SelectedItems), ThisItem.Status, "Not Yet Started")
Hi @Abardaje1194 ,
There's If conditions where you can use If ladder to perform if-else statements.
If(
<condition>,
//operations on true,
If(
<condition>,
//operations on true,
//operations on false
)
)
For Status, you need to set Default in dropdown control and if you have combobox then use DefaultSelectedItems property
Hope this helps
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional