Creating a button that makes a choice On Click

[Carl143]

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 record on the sharepoint list

So it shows up the comments for this record

If the row record does not exist on the Sharepoint list nothing shows

What i would like to be able to do is when selecting button

It works as described below:

If Row Record exist then Navigate to Update Form

Else Navigate to Create Record Form

Hope someone can help

[lbendlin]

What i would like to be able to do is when selecting button

That's not how this works.  You need to select the row, not the button.  When you select the row that selection should then filter the PowerApp visual, and you can fetch that via PowerBI.Integration.

[Carl143]

Hi Ibendlin

Just to clarify

1) Yes i select the row which selects the Invoice Number, 

a) If there is no record on my Sharepoint List Comments box is blank, which is the expected result.

b) If there is a record on the Sharepoint list it retrieves the Comment, which is the expected result

2) Rather than have 2 buttons,

a) one which takes you to "Update Form" where you can edit the details on the form

b) The other takes you to "Create Form" (Via Patch) to create a new row record

I would like to have one button which recognizes if a row record exists or doesnt exist and takes the user to the correct form, "Update Form" or "Create Form"

[lbendlin]

Why have two forms?  how are they different?

[Carl143]

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]

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 · Accepted solution]

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