Arizona Power Apps

87 Members

Join now

Sign in with your Microsoft Power Platform Community account

If you don’t have a Community account, you can create one.

Share group

Location

Arizona, United States, Arizona, United States

Details

Arizona Power Apps focuses on learning about and developing practical business solutions with Power Apps. While geared towards Arizona-based users, we welcome all developers! UG ID: 9800

Group leaders

zmorek

Topics

Power Apps

Discussion

Join the group to participate in the discussion.

JimSInAz 17 on

Like (0)

So, I keep getting this "JSON parsing error. Expected 'string' but got 'number' whenever I try to use the REIMBURSEMENTSOURCE_ID field in my colCarveOutDetails collection.

Here is the code where I create the collection from a table. Yes, the CONTRACT_ID is a number in the table but my flow expects it in a text value, not a numeric value:

ClearCollect(colCarveOutDetails, Table({}));

ClearCollect(

colCarveOutDetails,

ForAll(

tblCarveOutDetailsRev,

{

CPTREIMBURSEMENT_ID: Text(CPTREIMBURSEMENT_ID),

CPT: Text(CPT),

REIMBURSEMENTTYPE: REIMBURSEMENTTYPE,

REIMBURSEMENTSOURCE_ID: Text(CONTRACT_ID), // CONTRACT_ID becomes REIMBURSEMENTSOURCE_ID

NAME: NAME,

RATE_MAX: RATE_MAX,

PCT_BC: PCT_BC,

PCT_COST: PCT_COST,

APPLY_MULTIPLE: APPLY_MULTIPLE,

EXCLUDE_FROM_MAX: EXCLUDE_FROM_MAX,

AUTH_REQUIRED: AUTH_REQUIRED

}

)

);

How can I force a conversion to a text value? Text() isn't cutting it.

Show previous comments

JimSInAz 17 on

Like (1)

"'string()' is an unknown or unsupported function. 'variables() is an unknown or unsupported function."

So, I went back to the Power Automate flow that pulls the data originally and altered the SQL Statement CAST(IFNULL(CONTRACT_ID,0) As VarChar(50)). Then ensured that all the downstream JSON schemas were reset to see the CONTRACT_ID as a string value instead of a number. Now it works and I'll just have to convert the value from my collection if I need to use it as a number. This isn't a fix, it's a capitulation and a work-around but I see no other way around it. Would sure like to know why I couldn't just save a number value as a text string though.

MsPacManAZ 3 on

Like (0)

Sorry - enter it as string(variables('CONTRACT_ID'))?

JimSInAz 17 on

Like (0)

This is killing me!!!

I'm building a canvas app to interact with data in our Snowflake database. From within Power Apps, I've built 3 instant flows to query data from Snowflake to use in table variables. When I test them in Power Apps, they run without errors. When I test them in Power Automate they run without errors and show JSON structured data as Raw Output. When I attempt to call the flows from within my app: "Set(tblFlowData, SelectSFData.Run())", I get nothing. Last week I had one flow working using: "Set(tblFlowData, SelectSFData.Run().data)". This week, after a refresh of the flows, I get an error: "Name isn't valid. 'data' isn't recognized."
From Power Automate, here is a sample of what is being output (I've removed any actual data in the two records):
{
"statusCode": "200",
"schema": {
"type": "object",
"properties": {
"CONTRACT_ID": {
"type": "integer"
},
"CENTER_ID_NOTES": {
"type": "string"
},
"CENTER_STATES": {
"type": "string"
},
"CONTRACTED_PAYER_NAME": {
"type": "string"
},
"CONTRACTED_SHORT_NAME": {
"type": "string"
},
"CONTRACTED_TYPE": {
"type": "string"
},
"PLAN_TYPE": {
"type": "string"
},
"PRODUCT_NAMES": {
"type": "string"
},
"RATE_EFF_DATE": {
"type": "string"
},
"RATE_END_DATE": {
"type": "string"
},
"NEGOTIATION_DATE": {
"type": "string"
},
"INITIAL_TERM_END_DATE": {
"type": "string"
},
"CONTRACT_EFF_DATE": {
"type": "string"
},
"CONTRACT_END_DATE": {
"type": "string"
},
"CONTRACT_LEVEL": {
"type": "string"
},
"CONTRACT_TYPE": {
"type": "string"
},
"NEGOTIATED_BY": {
"type": "string"
},
"MID_TERM_INC_1": {
"type": "string"
},
"MID_TERM_INC_2": {
"type": "string"
},
"MID_TERM_INC_3": {
"type": "string"
},
"MID_TERM_INC_NOTES": {
"type": "string"
},
"XWALK_FS_UPDATE_DATE": {
"type": "string"
},
"APPLY_SEQUESTRATION": {
"type": "boolean"
},
"DEFAULT_RATE_MAX": {
"type": "string"
},
"DEFAULT_PCT": {
"type": "string"
},
"DEFAULT_TYPE": {
"type": "string"
},
"CASE_RATE": {
"type": "string"
},
"PCT_BILLED_RATE": {
"type": "string"
},
"MAX_PER_PROC": {
"type": "string"
},
"MAX_PER_CASE": {
"type": "string"
},
"HST_NOTES_250_CHAR_LIMIT_": {
"type": "string"
},
"OTHER_NOTES": {
"type": "string"
},
"PREV_CONT_ID": {
"type": "integer"
}
},
"required": [
"CONTRACT_ID",
"CENTER_ID_NOTES",
"CENTER_STATES",
"CONTRACTED_PAYER_NAME",
"CONTRACTED_SHORT_NAME",
"CONTRACTED_TYPE",
"PLAN_TYPE",
"PRODUCT_NAMES",
"RATE_EFF_DATE",
"RATE_END_DATE",
"NEGOTIATION_DATE",
"INITIAL_TERM_END_DATE",
"CONTRACT_EFF_DATE",
"CONTRACT_END_DATE",
"CONTRACT_LEVEL",
"CONTRACT_TYPE",
"NEGOTIATED_BY",
"MID_TERM_INC_1",
"MID_TERM_INC_2",
"MID_TERM_INC_3",
"MID_TERM_INC_NOTES",
"XWALK_FS_UPDATE_DATE",
"APPLY_SEQUESTRATION",
"DEFAULT_RATE_MAX",
"DEFAULT_PCT",
"DEFAULT_TYPE",
"CASE_RATE",
"PCT_BILLED_RATE",
"MAX_PER_PROC",
"MAX_PER_CASE",
"HST_NOTES_250_CHAR_LIMIT_",
"OTHER_NOTES",
"PREV_CONT_ID"
]
},
"body": {
"data": [
{
"CONTRACT_ID": 155,
"CENTER_ID_NOTES": "null",
"CENTER_STATES": "AZ",
"CONTRACTED_PAYER_ID": 53,
"CONTRACTED_PAYER_NAME": "A Name",
"CONTRACTED_SHORT_NAME": "A Short Name",
"CONTRACTED_TYPE": "A contracted type.",
"PLAN_TYPE": "A plan type.",
"PRODUCT_NAMES": "A product name or names.",
"RATE_EFF_DATE": "1/1/2000",
"RATE_END_DATE": "1/1/2000",
"NEGOTIATION_DATE": "1/1/2000",
"INITIAL_TERM_END_DATE": "1/1/2000",
"CONTRACT_EFF_DATE": "1/1/2000",
"CONTRACT_END_DATE": "null",
"CONTRACT_LEVEL": "Low",
"CONTRACT_TYPE": "ReadySetGo",
"NEGOTIATED_BY": "Someone",
"MID_TERM_INC_1": "null",
"MID_TERM_INC_2": "null",
"MID_TERM_INC_3": "null",
"MID_TERM_INC_NOTES": "null",
"XWALK_FS_UPDATE_DATE": "null",
"APPLY_SEQUESTRATION": false,
"DEFAULT_RATE_MAX": "null",
"DEFAULT_PCT": "null",
"DEFAULT_TYPE": "null",
"CASE_RATE": "null",
"PCT_BILLED_RATE": "null",
"MAX_PER_PROC": "null",
"MAX_PER_CASE": "null",
"HST_NOTES_250_CHAR_LIMIT_": "Some Notes.",
"OTHER_NOTES": "null",
"PREV_CONT_ID": 0
},
{
"CONTRACT_ID": 155,
"CENTER_ID_NOTES": "null",
"CENTER_STATES": "AZ",
"CONTRACTED_PAYER_ID": 53,
"CONTRACTED_PAYER_NAME": "A Name",
"CONTRACTED_SHORT_NAME": "A Short Name",
"CONTRACTED_TYPE": "A contracted type.",
"PLAN_TYPE": "A plan type.",
"PRODUCT_NAMES": "A product name or names.",
"RATE_EFF_DATE": "1/1/2000",
"RATE_END_DATE": "1/1/2000",
"NEGOTIATION_DATE": "1/1/2000",
"INITIAL_TERM_END_DATE": "1/1/2000",
"CONTRACT_EFF_DATE": "1/1/2000",
"CONTRACT_END_DATE": "null",
"CONTRACT_LEVEL": "Low",
"CONTRACT_TYPE": "ReadySetGo",
"NEGOTIATED_BY": "Someone",
"MID_TERM_INC_1": "null",
"MID_TERM_INC_2": "null",
"MID_TERM_INC_3": "null",
"MID_TERM_INC_NOTES": "null",
"XWALK_FS_UPDATE_DATE": "null",
"APPLY_SEQUESTRATION": false,
"DEFAULT_RATE_MAX": "null",
"DEFAULT_PCT": "null",
"DEFAULT_TYPE": "null",
"CASE_RATE": "null",
"PCT_BILLED_RATE": "null",
"MAX_PER_PROC": "null",
"MAX_PER_CASE": "null",
"HST_NOTES_250_CHAR_LIMIT_": "Some Notes.",
"OTHER_NOTES": "null",
"PREV_CONT_ID": 0
}
]
}
}
Can anyone tell me what I'm doing wrong here? Why am I getting that error now when it worked last week and what do I need to do to fix this?

Show previous comments

Yetla 2 on

Like (0)

Hello everyone! I'm working on power apps alongside sharepoint. I have a form where I must choose an email to be able to send a request, the problem is that this field is not saved in my sharepoint.

The code I use is this:

Office365Users.SearchUser({searchTerm:cmb_Assigned_To.SearchText,top:500})

Could someone tell me if I have had this problem or if I need to do something?

Thank you very much! ☺

Show previous comments

gonzo504 9 on

Like (0)

Can anyone assist with a Form Quiz that does not calculate the score correctly when used with Power Automate?

concat(string(mul(div(float(variables('Score')),float(18)),100)),'%')

Any help is appreciated!

Show previous comments

ManojKumarGG on

Like (0)

Hi Everyone,

I had a query on powerApps form.

It happens rarely , why form value is changing sometimes when a user just opens the form?

My form has lookups in dropdown and only these fields in form gets changed when a user opens it to update it. I also see while form is loading dropdown starts changing.

any fix for this?

Thanks,

Manoj

Show previous comments