how to refer excel macro fields in powerapps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Mates,

Our customers is using a excel, one of the field is using chemdraw diagrams,

Like user will enter H20, C20, O2 etc corresponding predefined chemdraw molicular formula will display in the file.

But now we are in the process of excel is converting in to powerapps forms, we can refer all the fields but not this chemdraw (add-on) fields in powerapps.

how to refer these Chemdraw(add-on) enabled fields in powerapps. then it should get and display the chemdraw diagram.

Powerapps cant refer.PNG

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Can you please provide a screenshot of the error message you are receiving in PowerApps?

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

Like (0)

Report
Copy link

Link copied!

Hi really thanks for reply,

Actually screen shot is there in the attachments also in photos,
but still i can upload here one more time,
the above pic is from powerapps. i can`t refer excel columns since that column has camdraw (app) installed on this field.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

I would actually like to see the error message generated by your code... sorry if I was not clear. The error message is always the best clue about how to fix a problem (if it can be fixed).

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

Like (0)

Report
Copy link

Link copied!

Please check now.

By any chance we refer or use JS file in powerapps ...?

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Anonymous
That error is asking "why did you split the code onto two lines?" Please try it on one line instead

ThisItem.'Chemical Formula'

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

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

Like (0)

Report
Copy link

Link copied!

Actually, the movement when i select that field its automatically going to next line, i have done there any thing, and next thing is there is another filed which is same but its not less name so its not moving to next line, but same issue.

it seems fields which are enabled with camdraw (app) those are getting these errors

By any chance can we use JS file in Powerapps ..?

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Well, I have no clue why its skipping to the next line. Please try to rewrite it again from scratch. That issue must be solved before we can go further.

No you cannot use JS in PowerApps.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

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

Like (0)

Report
Copy link

Link copied!

Tried already, but no luck
if i edit that column and save then i can able to get formula like H20, co2 etc but
you can see there is another column with diagram, even i edited and saved still i cant see any diagram output, its just displaying blank without error.

Was this reply helpful? Yes No