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
Carl143's avatar
Carl143
Frequent Visitor
1 year ago

I thought thats how you did it, 

When updating a row record use Update Form (to avoid duplication of row records)

When creating a row record use Create From via Patch 

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