Answered

how to create new form if sharepoint list is empty

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

how to create a new form if a user selects a row in the power BI table visual and there is no entry for that row, this is my current formula that displays the form if there is a SharePoint list entry for the row - LookUp('Sales', Text(ID) = First(PowerBIIntegration.Data).Index) . *ID is the index column of my SharePoint list

I have asked chatGPT and it has provided the following formula, but the power app has errors - 'If' function has invalid arguments, 'NewForm' and 'EditForm' are not showing as valid functions in the formula. I have no idea why?

If (isEmpty(First (PowerBIIntegration.Data).Index), NewForm(Form), EditForm (LookUp ('Sales', Text (ID) = First (PowerBIIntegration.Data).Index)))

even when I shorten the formula to - If(IsEmpty('Sales') - there are still invalid arguments for 'If'. Any advice?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous Are you having the If(.....) code in the Item property of the Form?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

yes, the item property is where the formula is located.

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@Anonymous That won't work.

In the Item property of the Form set this,

LookUp('Sales', Text(ID) = First(PowerBIIntegration.Data).Index)

In the DefaultMode property set this,

If(IsBlank(LookUp('Sales', Text(ID) = First(PowerBIIntegration.Data).Index)), FormMode.New, FormMode.Edit )

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No