how to refer excel macro fields in powerapps

[Anonymous]

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.

[mdevaney]

@Anonymous 

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

[Anonymous]

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.

[mdevaney]

@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).

[Anonymous]

Please check now.

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

[mdevaney]

@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."

[Anonymous]

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 ..?

[mdevaney]

@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."

[Anonymous]

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.