Forum Discussion

Carl143's avatar
Carl143
Frequent Visitor
1 year ago
Solved

Creating a button that makes a choice On Click

Hi  I have created a PowerApp within a PowerBi dashboard. It has a "Comment" writeback function to a Sharepoint list    Visual below has the "Invoice Number" (Can be Alpha Numeric) as a row recor...
Need Help
  • Carl143's avatar
    Carl143
    1 year ago

    Hi Ibendlin

     

    Thanks for your guidance, 

     

    I used the below code to make the switch work -

    If(IsBlankOrError(LookUp('ACTION_&_COMMENT_LIST2',ThisItem.ROW_ID="")), Navigate(IssueUpdateForm ),Navigate(CreateRecordForm))
     
    The strange thing that i have been struggling with is getting the order of the argument, i thought Navigate(CreateRecordForm should go before Navigate(IssueUpdateForm
     
    and using the ROW_ID="" i had been trying to use 0
     
    Thanks
    Carl
lbendlin's avatar
lbendlin
Super User
1 year ago

You would make that decision in PowerApp. When you get the single value from Power BI, try to match it to your collection. Show the edit form if you have a match, the create form otherwise. Upon patching use the ID for edit and default for add.

Carl143's avatar
Carl143
Frequent Visitor
1 year ago

Hi Ibendlin

 

Thanks for your guidance, 

 

I used the below code to make the switch work -

If(IsBlankOrError(LookUp('ACTION_&_COMMENT_LIST2',ThisItem.ROW_ID="")), Navigate(IssueUpdateForm ),Navigate(CreateRecordForm))
 
The strange thing that i have been struggling with is getting the order of the argument, i thought Navigate(CreateRecordForm should go before Navigate(IssueUpdateForm
 
and using the ROW_ID="" i had been trying to use 0
 
Thanks
Carl