Answered

using patch in text input and getting error: "The requested operation is invalid. Server response failed. The value must be provided for item"

(0) Share

Report

Posted on by Nanda_Pro

Need human interaction in power bi report as per client idea. So, i need to make a table structure in powerapps and make one row to human interaction to change as he like. FYI, In below table, i need human interaction in Surplus/Deficit. PBI table.PNG

I saw text input will do this work. So, i made a dummy table and made a workaround. And i am getting an error.

Please help me out. Thanks

Categories:

General Questions

Using Apps Using Formulas

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

FernandoTC 222 on at

Like (2)

Report
Re: using patch in text input and getting error: "The requested operation is invalid. Server response failed. The value must be provided for item"

Hi @Nanda_Pro

As I can see in the OnCHange Property of your Text input, you have a Patch funcion which is meant to alter the field 'Salary' of that record. You are giving the patch function a value that is neither text or number, you are giving it an objetct 'TextInput5'

Just add .Text after TextIput5 so you are referring to the Text property. Aslo you can use Value() function to convert that text string into a number to avoid data type conflicts:

Patch('[public].[demo]',ThisItem,{salary:Value(TextInput5.Text)})

This should work properly

Was this reply helpful? Yes No
Nanda_Pro 7 on at

Like (0)

Report

Re: using patch in text input and getting error: "The requested operation is invalid. Server response failed. The value must be provided for item"

Hi @FernandoTC
This works like champ, Thanks you

I have an other doubt, can you clear me please.
I am going to use this table as power apps table, and text input row (human interaction) as Surplus/Deficit. And the card visual (Current quarter achieved) and (Current quarter catchup) is calculated using Surplus/Deficit. So, my question is, can i write dax from powerapps table (Surplus/Deficit) to show value in card (power bi desktop)

Was this reply helpful? Yes No
FernandoTC 222 on at

Like (0)

Report

Re: using patch in text input and getting error: "The requested operation is invalid. Server response failed. The value must be provided for item"

Hi @Nanda_Pro

I'm not sure if I got clear what you want to do here. As I understood, you are going to build that same table in PowerApps and you want to display, inside the app, the same info shown in PowerBI data cards. Am I right?

If so, PowerApps does not allow DAX. However, there are several functions built in power apps that will allow you to manipulate the data displayed on that table to obtain the same value you have in those data-cards.

If you need more detailed help you should provide more detailed info.

Was this reply helpful? Yes No
Nanda_Pro 7 on at

Like (0)

Report

Re: using patch in text input and getting error: "The requested operation is invalid. Server response failed. The value must be provided for item"

Sorry for delay reply @FernandoTC

I'm going to change this power bi table as Powerapps table to use text input (Bcoz of human interaction, client needs). Right side card is power bi card, those calculation are depends on this power bi table. So, once i change the pbi table to power apps table, then how to calculate the pbi card which is depends on the table value. Is there any functions or formula to use power apps value to calculate in power bi card visual?

Regards
Nanda

Was this reply helpful? Yes No